After update of drupal to 6.13 al of my comments disappeared, and i got following, annoying message on every page

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 = 4 ORDER BY c.thread DESC LIMIT 0, 50 in /home/baraba/public_html/modules/comment/comment.module on line 992.

I do not understand this, since I am a newbie on drupal, cms, coding... what to do?

thankful for help!

Comments

dark.o’s picture

dark.o commented

ok, after some updates of databases and other things under status rapport issues (after the update) the message disappeared. Still, all of the comments are gone. In my case, not so much damage since it is test site, but for someone else, it could be devastating.

Drake’s picture

Drake commented

Hi

I had this problem too...
It seem that the comment.module file (or a part in this file) is the issue.
I have simply removed the comment module from the server and repalced it with the previous version 6.12.

May I ask you what did you change in the database? or how you have solved this issue?

dark.o’s picture

dark.o commented

to be honest with you, i do not really know what caused the error message to disappear. Under report status menu, i got urged, among else, to update databases, and after that i think the above mentioned error message disappeared.

no i got another annoying alert, will post a new issue, regarding this message:

Fatal error: Only variables can be passed by reference in sites/all/modules/admin_menu/admin_menu.inc on line 536

heine’s picture

heine commented
Status: Active » Closed (won't fix)

You need to run the updates on update.php.

Drake’s picture

Drake commented

Thanks Heine.

I have executed the update.php and this helped to sort out this issue!

Thanks!!!