Hi,

I'm in UTC+12 timezone (which I think is related) and I have a problem with SignUp showing the wrong day. The system wide time zone is setup correctly in Drupal and users are not allowed to set their own timezone. I just created 2 events:

Saturday 29 Sep 2012 from 11 am onwards event on Saturday 29 September 0 0 View signups Signup broadcast
Saturday 30 Sep 2012 from 11 am onwards event on Sunday 30 September 0 0 View signups Signup broadcast

Note that signup shows "Saturday" for both 29 and 30 Sep?

Also, I just discovered that I get the following errors on the user registration page:

user warning: Table 'drup01.signup' doesn't exist query: SELECT DISTINCT n.nid FROM drup_node n INNER JOIN signup s on n.nid=s.nid INNER JOIN drup_node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author'))) AND ( s.user_reg_form = 1 AND s.status = 1 AND n.status = 1) in /....../sites/all/modules/signup/signup.module on line 643.

Apparently I'm not the only one with this problem, see https://www.google.co.nz/search?q=.signup'+doesn't+exist+query%3A+SELECT+DISTINCT+n.nid+FROM+drup_node&sugexp=chrome,mod=9&sourceid=chrome&ie=UTF-8#q=.signup%27+doesn%27t+exist+query:+SELECT+DISTINCT+n.nid+FROM+drup_node&hl=en&prmd=imvns&filter=0&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&fp=22b27deff168197e&biw=1920&bih=912

I'm sure it's a problem with my site configuration or something I have done wrong, but any pointers would be much appreciated!

Comments

mverhagen’s picture

mverhagen commented

The 1.x dev branch fixed the SQL error, but I still have the wrong day name for 29 and 30 September (Signup thinks both dates are a Saturday)...

Hopefully somebody is still maintaining the 6.x branch?

spamjim’s picture

spamjim commented

Regarding the SQL error on line 643 for 1.0 "stable" users who have not moved to the dev version...

Just add curly brackets around "signup".

Before:
$query = db_query(db_rewrite_sql("SELECT n.nid FROM {node} n INNER JOIN signup s on n.nid=s.nid WHERE s.user_reg_form = 1 AND s.status = 1 AND n.status = 1"));

After:
$query = db_query(db_rewrite_sql("SELECT n.nid FROM {node} n INNER JOIN {signup} s on n.nid=s.nid WHERE s.user_reg_form = 1 AND s.status = 1 AND n.status = 1"));