By studentcritics on

I installed the comments part, when I add a comment i get the following error

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 = 8 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50 in C:\xampp\htdocs\public\modules\comment\comment.module on line 992.

And the comments dont show

Help please!

Thankyou

Comments

vertazzar’s picture

vertazzar commented

disable user signature ability, clear website cache. if it works, enable the ability again, and if error shows again, there's something wrong with user signatures.

as i see from error you keep getting error about user signature tables.
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 = 8 AND c.status = 0 ORDER BY c.thread DESC LIMIT 0, 50 in C:\xampp\htdocs\public\modules\comment\comment.module on line 992.
n4cqw’s picture

n4cqw commented

OK this is what I have had show up... but I am total newbie so forgive me asking dumb questions....

Here is what I have ....

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

Which appears to be the same error. When I do update.php it goes to update but I can't seem to be able to see the module 6051 update. I have looked in the pull downs and can't see it to manually add it.

What am I doing wrong!?!?!???? Sorry I am trying to learn this and I have been chasing my tail it seems for 3 days withthis thing and it's about to drive me nuts! LOL

Thanks for the help and the advice!

Moe

yelvington’s picture

yelvington commented

Run update.php after upgrading Drupal core.

petertj’s picture

petertj commented

Previously functioning fine, no other changes in modules or configuration were made, only the upgrade to 6.13 was done. Now receiving the same error:

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 = 70 ORDER BY c.thread DESC LIMIT 0, 50 in /home/content/a/d/m/adminsyn8/html/meta/modules/comment/comment.module on line 992.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

That happens because you didn't run update.php after you copied the new files on your server; differently, an update function would have added the new database field that is missing in your database.

I installed Drupal 6.13, and I ran update.php after I copied the new files. My site is working fine, and I don't get such error messages.

petertj’s picture

petertj commented

Even though it said "No updates available" on all modules, including comments, I ran it anyway - installed 0 of 0 updates of course. Am I missing something else somewhere?

petertj’s picture

petertj commented

Makes sense, the only difference between v1.617.2.7 and v1.617.2.8 of comments.module was "u.signature_format" added on lines 939, 960, and 1471.

Is this an acceptable workaround until I can find out why update isn't working to add the required tables?

petertj’s picture

petertj commented

Dug back into my FTP log and found a connection timeout - I wasn't watching while it uploaded, my bad.

Put the correct files, and update.php properly updated system module. The error from comments.module was a red herring.

Thanks for the pointer, it was an update problem after all!

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

I really hate when the FTP application doesn't copy all the files it is supposed to copy, and it doesn't get back an evident error message. It happened to me when I copied the new version of a third-party module, and I was not able to understand why all in a sudden the home page of my site was showing a beautiful WSOD, while the other pages where visible.

It was evident that Drupal didn't execute the update function (otherwise you would have noticed a message in the updates page that said a new database field was added); to find out that the FTP application didn't copy all the files is quietly a difficult "bug" to discover.

I am glad you found out the problem.

kakajoe’s picture

kakajoe commented

run the update.php .. it works for me just fine.. and i uploaded the upgrade via ftp too.. seem ok for me..

maximum’s picture

maximum commented

Hi, I too was faced with the problem, but I decided it:
run update.php - select version - system module - 6051 - update

Seneschall’s picture

Seneschall commented

That worked for me too. But is that really a fix? Or did I just downgrade my install somehow?

My problem is similar, but I was taking some user tables from an older version of Drupal & porting over to a different 6.13 version.

maximum’s picture

maximum commented

the latest version of the module 6051, so this does not downgrade. But UPGRADE says that you must run after the upgrade file update.php, but it does not work for me, this is a bug?

Skelly1983’s picture

Skelly1983 commented

i can confirm this aswell had same error message on pages with comments on, ran upadate.php and manualy made sure 6051 was selected in versions and clicked update, everything is workin fine now on my site

tlangston’s picture

tlangston commented

I am getting the same error. Is this going to get looked at?

dontgoquietly’s picture

dontgoquietly commented

I upgraded to the recent 6.14 core... this error message just started appearing for me. Any one have any luck with finding the cause of this?

himagarwal’s picture

himagarwal commented

@dontgoquietly, I had the same problem. Follow the comments provided by max. at http://drupal.org/node/508666#comment-1783504 which solved my problem.

tomitom’s picture

tomitom commented

Where is the problem when I have the latest module version 6003? Thank you

lilon’s picture

lilon commented

I am trying to fix an update from 6.11 to 6.14 which is missing the #6051 update. As a result I don't see any comments in my forums.

But when I try your suggestion of using update.php, the versions drop downs do not show 'system', only systeminfo.

How can I run 6051?

I have tried to do it via the dbadmin but I am a novice and don't know how to change the script so that the database will accept it.

Will appreciate help, thanks.

lilon’s picture

lilon commented

Hurray, I've done it.
I run the two sql queries off PHPMyAdmin. I only had to discard the {} around the table name and the rest was good to go.

Problem solved.

smackcoders’s picture

smackcoders commented

Update

Kindly provide me the queries that you executed for this fix.

Thanks

Hugo Estrada’s picture

Hugo Estrada commented

alter table users add column signature_format smallint not null default 0

jebro’s picture

jebro commented

Thanks Hugo, that query worked for me. I must've forgotten to run update.php after some Drupal update a while ago.