Feedback comments are not working at all at the moment; whenever anyone tries to submit feedback, the insert fails silently with the following error in Watchdog being the only indicator of a problem:

Unknown column 'url' in 'field list' query: INSERT INTO {feedback} (uid, message, location, location_masked, url, timestamp, useragent) VALUES (3, 'Test', 'node/48', 'node/%', 'http://www.kssdeanery.org/departments', 1265634369, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.6 (KHTML, like Gecko) Chrome/4.0.266.0 Safari/532.6') in /var/www/html/sites/kssdeanery.org/httpdocs/sites/all/modules/feedback/feedback.module on line 228.

Is this a problem with Feedback, a borked update.php run, or ...?

Any help would be greatly appreciated :o)

Al

Comments

alexgreyhead’s picture

alexgreyhead commented
Title: MySQL error - Unknown column 'url' when saving feedback comment - feedback.module, line 228 » Feedback broken if update.php fails to complete - unknown column 'url' when saving feedback comment

This issue appears to have been caused by update.php failing to rejig the feedback table:

http://drupal.org/node/697456

Could the next update provide an update.php script to make sure this is fixed for all please? Many users will be unaware they are suffering from this bug unless they spotted the error in their logs.

Many thanks in advance,

Alex

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

I'm not sure what happened on your site. I tested the update path on a couple of sites already and didn't get the result you got.

Do you see any particular improvement?

jody lynn’s picture

jody lynn
she/her
Primary language English
commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Sounds like your update went awry and you have to rerun update 6101. Closing since no one has noted reproducing in almost a year.