I recently moved my Drupal installation to a new server at my host (same host as before, theoretically same server configuration). I think everything worked at that point. Then I upgraded from Drupal 6.4 to Drupal 6.14. Now I'm having problems: I get an error and no comments are displayed when I try to view a forum topic.

The error is:

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 = 132 ORDER BY SUBSTRING(c.thread, 1, (LENGTH(c.thread) - 1)) LIMIT 0, 50 in {.../drupal}/modules/comment/comment.module on line 992.

Did the column name change between versions, and maybe an update didn't happen? I ran update.php again just to make sure, but it says everything has been updated and no errors are listed. I don't have any idea how to debug this. Signature support isn't even enabled on my system. Can anyone offer any advice?

Comments

cindyr’s picture

cindyr commented
Status: Active » Closed (fixed)

The column doesn't appear to exist in the database, so I removed three references to it in comment.module and one in comment.pages.inc. The error is gone and the comments appear.

Se7enLC’s picture

Se7enLC commented
Status: Closed (fixed) » Active

I have this same problem, but I am wary about editing the comment module - clearly the database should contain those fields but the update database script did not create them. Can anyone point me to which database upgrade should perform that change?

Se7enLC’s picture

Se7enLC commented

Found it - System Module database update #6051

lilon’s picture

lilon commented
Category: support » bug

I have the same problem when upgrading from 6.11 to 6.14 - all my comments to forums have disappeared. What to do?

thanks

kkobashi’s picture

kkobashi commented

I just noticed I am missing all the comments in all my websites also. To solve this, run update.php for each website.

kkobashi’s picture

kkobashi commented
Status: Active » Closed (fixed)
wolf1030’s picture

wolf1030 commented

I found a solution for this issue with following steps:

1. open url http://yourdrupaldomain/update.php

2. At Select updates step, expend Select versions div and select system module to 6051,then click update button

this should solve this issue by avoiding any data losing. hope it's helpful

RaRi’s picture

RaRi commented

Mmmh .. not sure whether I really have to do this. I got the error after upgrading to 6.15 and the latest version for the system module is 6053.

Is that okay to run 6051 anyway?