Problem after signing up, unknown column status in *_signup_log
TRex2003 - August 25, 2009 - 14:11
| Project: | Signup Status |
| Version: | 6.x-1.0-alpha1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Hi,
after subscribing to an event I get the following error:
user warning: Unknown column 'status' in 'field list' query: UPDATE web1_signup_log SET status = 2 WHERE sid = 3 in /srv/drupal-web/sites/all/modules/signup_status/signup_status.module on line 224.
The column doesn't exist in the named table, only the cols sid, uid, nid, anon_mail, signup_time, form_data and attended exist in the table.
What did fail here?
#1
This would happen if signup wasn't already installed and enabled when you installed and enabled signup_status. Sadly, signup_status does a slightly unholy thing by trying to alter the schema of a DB table defined and used by signup, the {signup_log} table. So, if {signup_log} doesn't exist when signup_status_install() is invoked, the attempt to alter an existing table will fail and you'll have problems like this.