Hi I get this Error on /admin/content/signup

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node n INNER JOIN signup s ON s.nid = n.nid LEFT JOIN signup_log s_l ON s.n' at line 1 query: SELECT n.nid, n.title, n.type, s.status AS signup_status, COUNT(s_l.nid) AS signup_total, s.close_signup_limit AS signup_close_signup_limit, event. FROM node n INNER JOIN signup s ON s.nid = n.nid LEFT JOIN signup_log s_l ON s.nid = s_l.nid LEFT JOIN `event` ON event.vid = n.vid WHERE (s.status = 1) GROUP BY n.nid, n.title, signup_status, signup_close_signup_limit ORDER BY n.title ASC LIMIT 0, 25 in /usr/www/users/mywebsite/sites/all/modules/signup/includes/admin.signup_administration.inc on line 76.

Line 76 is

$result = pager_query($sql, 25, 0, $sql_count);

Server:
Drupal 6.13 (fresh install)
MySQL 5.0.32
PHP 5.2.10
Apache/1.3.34 (Debian)

Signup Administration tab on event works though.

Comments

dww’s picture

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

What version of event.module are you using? Seems like bugs in event module. I hate trying to support that module since there are no official releases and the API keeps changing.

Try using date + calendar, and your life will probably be a lot better.

funana’s picture

funana commented

I use date and calendar. It's just the node type which is called "event". ;-)

walden’s picture

walden commented

@funana Did you ever locate a fix for this? I'm having the same issue.

steve.colson’s picture

steve.colson commented
Version: 6.x-1.0-rc4 » 6.x-1.0
Status: Postponed (maintainer needs more info) » Active

I had this problem too. I've tracked it down to a configuration option in the manage content type interface. Specifically, if "Date field to use with signup" is "<Not Specified>", then I get the error. If it is set to "<None>", the error goes away.