Hi, I have the same error as this closed report:
http://drupal.org/node/212790
I am using Event 5.x-1.0, as it is the recommended version on that project page, and I tried Sign Up 5.x-2.4 (so I could try to use the PayPal payment modules). In the previous post, it seemed the issue was fixed, but it does not seem to be so with my combo. I did previously have Sign Up 5.x-1.0 installed, and that worked.

Thanks for any help . . .

The error message on the Sign Up Admin page is:
user warning: Unknown column 's.status' in 'field list' query: SELECT DISTINCT(n.nid), n.title, s.status AS signup_status, COUNT(s_l.nid) AS signup_total, s.close_signup_limit AS signup_close_signup_limit, e.event_start, e.timezone FROM signup s INNER JOIN node n ON n.nid = s.nid LEFT JOIN signup_log s_l ON s.nid = s_l.nid LEFT JOIN event e ON e.nid = n.nid GROUP BY n.nid, n.title, signup_status, signup_close_signup_limit, e.event_start, e.timezone ORDER BY n.title ASC LIMIT 0, 25 in /usr/www/users/ceo3141/includes/database.mysql.inc on line 167.

Comments

dww’s picture

dww
we/he/they
commented
Status: Active » Postponed (maintainer needs more info)

After you upgraded to 5.x-2.4, did you run update.php? The DB schema changed. What does this query return on your site:

SELECT schema_version FROM {system} WHERE name = 'signup'

?

ceo3141’s picture

ceo3141 commented

1) Yes, I did run update.php.
2) It does appear there is a problem with the database. Running that query, nothing comes up, and examining the 'system' table, there is no entry for signup (or anything like it). There is a separate table called 'signup' present.

Before sending you this post, I tried deleting the module, uninstalling, and then re-installing, running php.udate.
I can enable Signups for an Event, but on any event I get "Signups closed for this event". (I have closed signups only 24hrs before, and the events are far in the future.)

The error in my original post on the SignUp Admin page remains.

I am not sure what to do at this point. Should i uninstall the module, and then delete the signup table and try putting the module in again new??

I had also installed SignUp Staus, SignUp Status Mailer, should I delete the tables for those also?

Thanks for your reply and help!

dww’s picture

dww
we/he/they
commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)

You realize that if you run that query directly on your DB, you need to strip off the {} around 'system', and potentially prepend your database table prefix (if any), right? Assuming you're not using a table prefix, that'd be:

SELECT schema_version FROM system WHERE name = 'signup';

Anyway, sounds like you really hosed your site somehow. I suggest you start over with a clean test site and see what happens. I think there's nothing wrong with the code here, just how you tried to install/upgrade it on your site. Sorry I can't be more help.