Closed (fixed)
Project:
Drupal core
Version:
6.20
Component:
comment.module
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
3 Feb 2010 at 20:20 UTC
Updated:
21 Jul 2011 at 04:19 UTC
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
Comment #1
Robert Kraut commentedI'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.
Comment #2
le dendrite commentedMe 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.
Comment #3
le dendrite commentedFound the solution here.
http://drupal.org/node/508666#comment-1783504
phpMyAdmin
alter table: users
add column = signature_format
smallint
not null
default 0