Hi all,

I tried to install signup module for my system and got the following error message:

* user warning: Table 'drupaltest.signup' doesn't exist query: SELECT COUNT(*) 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, s.completed, e.event_start, e.timezone in C:\p3t\public_php\Drupal\includes\database.mysql.inc on line 120.

* user warning: Table 'drupaltest.signup' doesn't exist query: SELECT n.title, n.nid, s.completed, e.event_start, e.timezone, COUNT(s_l.nid) AS count 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, s.completed, e.event_start, e.timezone ORDER BY n.title ASC LIMIT 0, 25 in C:\p3t\public_php\Drupal\includes\database.mysql.inc on line 120.

What do I need to write for the SQL as code so i can it to my system?

Thanks.

Comments

dww’s picture

dww
we/he/they
commented
Assigned: k.tang » dww
Status: Needs work » Fixed

i'm assuming by the version of this issue you're using Druapl 4.7.x, right? you probably just didn't include the signup.install file in your "modules/signup" directory when you tried to enable the module. if the signup.install file is present, it will install all the database tables you need.

run this query:

DELETE FROM system WHERE name='signup';

then make sure you copy the entire contents of the signup directory into your modules directory from the release package you downloaded, then try installing it again. it should all work just fine.

good luck,
-derek

p.s. if it doesn't work, you *must* include some more information here:
- version of Drupal core
- MySQL or PostgreSQL? what version?
- what steps did you take to install the module?
...

p.p.s. "patch (code needs work)" is a status for this particular support request. you didn't post a patch to solve a problem, so this issue doesn't have a patch associated with it. see http://drupal.org/node/22568 for more about what a patch is. in general, the module maintainer (me) would set an issue to "patch (code needs work)" if a user (you) posted a patch for a bug fix, but i decide the patch wasn't good enough (introduced another bug, didn't adhere to the coding guidelines, etc).

p.p.p.s. the "assigned" field for an issue is for keeping track of who is working on it, not who reported it. ;)

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)