When a person selects ' Create New Account' they get the following error message
"user warning: Table 'paddlers_drupal.signup' doesn't exist query: SELECT n.nid FROM drupal6_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 in /home/paddlers/public_html/sites/all/modules/contrib/signup/signup.module on line 643..."
I've looked at the code and found the the table name 'signup' is hard coded in the module rather than inside {}, so it is not picking up the correct table name drupal6_signup.

Should signup be inside {} or is there more to it than that?

Comments

barry769’s picture

barry769 commented
Priority: Normal » Major

I too am getting this error when trying to create a new account.

andrewm63au’s picture

andrewm63au commented

I got mine working by putting {} around the table name 'signup' in the signup.module on line 643. I think the {} allows the signup table name to be replaced by the actual table owner name from the database.

I'm not sure how to create a patch to load onto this forum, but I'm working on it.

dww’s picture

dww
we/he/they
commented
Status: Active » Closed (duplicate)

This bug was already fixed at #1020758: Missing table prefix in query on line 643 of signup.module. You need to either use the 6.x-1.x-dev release or wait for #1298530: Create 6.x-1.1 release