SQL error in drupal 6.3
vallab444 - August 8, 2008 - 11:12
| Project: | Whisper |
| Version: | 6.x-1.0-rc2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | won't fix |
Jump to:
Description
I ran update.php after enabling Guestbook and Whisper. Settings were made for both. But, when I post an entry, I get this error:
user warning: Unknown column 'sealed' in 'field list' query: UPDATE drupal_guestbook SET sealed = 1 WHERE id = LAST_INSERT_ID() in /var/www/domains/linux.medianewday.com/docs/sites/all/modules/whisper/whisper.module on line 178.
what's the matter?
cheers
-vallabh

#1
The error message clearly states that the error is caused by Whisper module.
#2
Are u using the RC2 version of whisper? From the warning, it seems that you do not already have the sealed column added to the guestbook table. You have to run update.php and select the 6110 update to have the column added.
The field only gets added during installation if guestbook has already been enabled first so you might have missed out on getting the column added. However update 6110 will also perform the table alter to add the field.
#3
Is the problem solved?
#4
#5