Jump to:
| Project: | Page Title |
| Version: | 5.x-2.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | nicholasThompson |
| Status: | closed (fixed) |
Issue Summary
I am getting the following error in my watchdog hundreds of times a day (pretty much every time a page is viewed):Unknown column 'type' in 'where clause' query: SELECT page_title FROM page_title WHERE type = "node" AND id = 3436 in /home/myuser/public_html/includes/database.mysql.inc on line 174.
Looking at the page_titles table, the error seems to be very straightforward... there is no 'title' column in my database. Coincidentally, there is also no 'id' column. I just started using the page title module at version 5.x-2.1 and have not needed to do any updates yet. Looking into the page_title.install file, it appears that some or all of the updates may be necessary for the module to be used, even if it is a fresh install.
I should note that the page titles module IS working properly, but I guess it is not caching the generated page titles, forcing it to regenerate the title every page load.
Comments
#1
I just checked, and it appears that running update 5203 fixes the errors. My suggestion is that the function page_title_install() be updated to include the changes made in update 5203.
I can also confirm that this update allows custom page titles to be written to the database.
#2
I got this error on a fresh install of drupal with ONLY the following setup...
drupal-5.18 (fresh install)
token 5.x-1.13
page title 5.x-2.1
now running update.php and selecting update 5203 did fix the problem...but this cannot be good if the module does not even install to a fresh drupal installation correctly...
#3
I'm *really* sorry guys - I completely forgot about the hook_install! I'll get this sorted ASAP!
#4
Commited into 2.x-dev - will appear in 2.2 in the next few hours.
#5
subscribing
#6
Automatically closed -- issue fixed for 2 weeks with no activity.