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

dww’s picture

Component: Code » Database
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

- 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.