Update code to be consisten with new Page Title Schema (changed in Page Title 2.2)

nothing update from developer regarding my problem?

Are you running PostGres as your database? If so... See #488844: No database schema updates for PGSQL

Did you upgrade or fresh install? If upgraded, did you run update.php?

Im running on mysql and PHP..

i upgrade.. not fresh install from previous version, it is 2.1.

yes i have run update.php.

after doing some diagnosis, i try to re-install again this module and found that there is a table call "page_title_old" still there although i have been uninstall through drupal module.

and i see that "nid" is refer to "page_title_old" while "id" is refer to "page_title" table.

i don't know which line is run this script but just give some ideas on this.

and both table are EMPTY...

this error is out when i try to preview creating new nodes:

Warning: Unknown column 'nid' in 'field list' query: SELECT nid AS id FROM page_title WHERE page_title='' in /home/kripkorn/domains/kripkornstudios.com.my/public_html/includes/database.mysqli.inc on line 128

nothing information regarding my problem?

Just to say that I have the same error message.

Am using Page Title 6.x-2.2 too, upgraded from previous module. Update.PHP was run. Will try a manual re-run of update code.

Re-run of #6200 update code has had no effect, error still appears when I save a page.

I have looked at the code that is falling over (SEO Friend) when it queries the page title table and it appears to be looking for a column entitled 'nid'. As parasolx is suggesting, has the column name changed to 'id' from 'nid' in a recent release (6.x-2.2)?

OK, have had a look back though old releases. The page_title schema changed in version 6.x-2.1 from including 2 columns (nid,page_title) to 3 columns (id, type, page_title).

I guess other modules need to be updated to support this schema change? I am going to make a temp change to 'SEO Friend' and inform that developer of the issue (as I think it is)

Regards

Adam

Yeah - the column name changed in 2.2 to allow extended Page Titles. A title is no longer bound to a node id, but rather a "type" and a numeric ID...

I'll move this issue over to SEO Friend...

wow.. thanks a lot.. thats answer my testing regarding disable Page Title, the error still came out.

then i try to search which other module that depend on this Page Title but seems don't found it.

thats mean, it came form SEO friends.. thanks..

Wow! I apologize greatly for not seeing this thread. I thought that the system was emailing me upon issues. Very weird.

Yes, the page_title module has changed its database table structure so I will need to update to handle both. I can do that right now.

Again, sorry about the delay. I will see what is going on with the notifications.

I have updated the code to handle page_title changing its schema. It checks for "id" column first and, if not found, the "nid" column. I have released a beta2 version with this fix along with a referrers report which I haven't tested yet because I didn't have any data. If anyone wants to click on that tab and let me know if they see any errors, that'd be great.

Note that the system may take a little while before it puts up beta2 on the website.

Again, I apologize for not seeing this earlier. I did get previous issues emailed to me but not these until just recently. Not sure if there was a glitch in the email system or what. I have "subscribed" to these issues as an additional measure, so hopefully I will be getting them in the future.

Or, if you don't notice any activity from me when posting a bug, you can always contact me directly.

Thanks,
Kristen