This problem is happen when I want to do those three jobs:

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

Warning: Cannot modify header information - headers already sent by (output started at /home/kripkorn/domains/kripkornstudios.com.my/public_html/includes/database.mysqli.inc:128) in /home/kripkorn/domains/kripkornstudios.com.my/public_html/includes/common.inc on line 328

Comments

parasolx’s picture

parasolx commented

nothing update from developer regarding my problem?

nicholasthompson’s picture

nicholasthompson
Primary language English
commented
Status: Active » Postponed (maintainer needs more info)

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?

parasolx’s picture

parasolx commented

Im running on mysql and PHP..

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

yes i have run update.php.

parasolx’s picture

parasolx commented

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...

parasolx’s picture

parasolx commented

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

parasolx’s picture

parasolx commented

nothing information regarding my problem?

anea02’s picture

anea02 commented

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.

anea02’s picture

anea02 commented

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

anea02’s picture

anea02 commented

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)?

anea02’s picture

anea02 commented
Status: Postponed (maintainer needs more info) » Active

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

nicholasthompson’s picture

nicholasthompson
Primary language English
commented
Title: Problem when create, edit and delete node » Update code to be consisten with new Page Title Schema (changed in Page Title 2.2)
Project: Page Title » Drupal SEO Friend (Tools & Reports)
Version: 6.x-2.2 » 6.x-1.x-dev
Status: Active » Needs work

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...

parasolx’s picture

parasolx commented

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..

kristen pol’s picture

kristen pol
she/her
Primary language English
Location Santa Cruz, CA, USA
commented

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.

kristen pol’s picture

kristen pol
she/her
Primary language English
Location Santa Cruz, CA, USA
commented

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

kristen pol’s picture

kristen pol
she/her
Primary language English
Location Santa Cruz, CA, USA
commented
Status: Needs work » Fixed
kristen pol’s picture

kristen pol
she/her
Primary language English
Location Santa Cruz, CA, USA
commented
Status: Fixed » Closed (fixed)