Refering to http://drupal.org/node/604584
--
Unfortunately, nobody takes a look into an already closed issue. Hence, I opened a new one ;)

The solution mentioned on the same issue was to run update.php and selecting system module 6051.
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?

Comments

Robert Kraut’s picture

Version: 6.15 » 6.20

I'm using Drupal 6.20. Running the status report says that modules, themes and database are all up to date. Yet I still get the error below saying that the u.signature_format column is unknown when running queries in the comment.module. The comment.module is v 1.617.2.17 2010/08/1 and system version is 6055.

bob kraut

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

le dendrite’s picture

Me too.

Drupal 6.20
All Modules up to date.
update.php done.
signatures and user pictures are disabled.

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 = 34 ORDER BY c.thread DESC LIMIT 0, 10 in /home1/ :) /public_html/ :) /modules/comment/comment.module on line 992.

Help Please. Thank you.

le dendrite’s picture

Status: Active » Fixed

Found the solution here.
http://drupal.org/node/508666#comment-1783504

phpMyAdmin
alter table: users
add column = signature_format
smallint
not null
default 0

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.