Hi,
I'm writing to let you know of an error I just received while working with the signup module. Here's the error message text:
user warning: Unknown column 's_l.sid' in 'field list' query: SELECT u.uid, u.name, u.mail, s_l.sid, s_l.anon_mail, s_l.form_data FROM bse_signup_log s_l INNER JOIN bse_users u ON u.uid = s_l.uid WHERE s_l.nid = 11 in /var/www/html/bse/modules/signup/includes/broadcast.inc on line 97.
I received this when I clicked "Signup broadcast".
I'm relatively new to Drupal, so it may have been caused by something I did, but I don't think so. The only significant change that I made to the module was updating the verbiage from "signup" to "registration". Needless to say, I did not change variable names, functions, permissions, DB tables or fields, filenames, etc.
There doesn't seem to be an apparent solution. No sid field on the {signup_log} or {user} tables, no field names that could be confused with that, so for now I have removed the field from the query text.
I apologize if there's a patch or solution out there; Drupal and Google searches haven't gotten me anywhere.
Thanks.
Sincerely,
Jason
Comments
Comment #1
dww- Did you upgrade from a previous version of signup?
- Did you run update.php to update your database schema? signup_update_6001() has to run before the {signup_log} table has a 'sid' field.