By thomasmind on

Hi,

I was with Drupal version 6,12 and upgraded it to 6,14.

Then I got this error when I activate comments in node :

user warning: Unknown column 'u.signature_format' in 'field list' query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 142 AND c.status = 0 ORDER BY SUBSTRING(c.thread, 1, (LENGTH(c.thread) - 1)) LIMIT 0, 10 in /public_html/modules/comment/comment.module on line 992.

Then I downgrade only the comment module to 6,13. The same problem occured.

I downgrade (always only the comment module) to 6,12, the error gone.

There is probably some kind of a bug somewhere in this area.

Comments

scott m. sanders’s picture

scott m. sanders commented

Did you run your database upgrade script? Example: http://www.mydrupal.com/upgrade.php

thomasmind’s picture

thomasmind commented

I should always worry when I am the only one to have a bug ...

I completely forgot this update script.

Now all is working fine.

Thank you guys.

Se7enLC’s picture

Se7enLC commented

I have this same problem - but I HAVE tried to run the upgrade script - to no avail!

u.signature_format does not exist in the database, but DOES exist in comment.module and comment.pages.inc.

Should the column be created, or should the comment module files be edited? Can anyone tell me which database upgrade makes that change?