Hey

on the registration page, signup showed an error that it was unable to find the "signup"-database in

signup.module line 643
$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"));

because my table is called drupal_module

there are brackets around {signup} missing, this should fix the problem:
$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"));

Greets
Marco

Comments

dww’s picture

Status: Active » Closed (duplicate)

#1020758: Missing table prefix in query on line 643 of signup.module

Already fixed in 6.x-1.x-dev. Will be available in 6.x-1.1.