If you've turned on database prefixes, this'll crash out.

user warning: Table 'X.webform_report' doesn't exist query: UPDATE webform_report SET... in /drupal/sites/all/modules/webform_report/webform_report.module on line 233.

Just have to update the 2 references there to webform_report to {webform_report} to fix it.

Comments

klance’s picture

klance commented

Fixed. There was another reference to 'users' table without the {} as well. Funny thing is, I run Drupal in a PostgreSQL schema that isn't called 'drupal' and I never encountered this error message! Thanks, bc.

klance’s picture

klance commented
Status: Active » Fixed
kcolbe’s picture

kcolbe commented

Actually it isn't fixed quite yet...line 233:

db_query("UPDATE {webform_report}u SET wnid = %d, kcid = %d, sort = %d, components = '%s', filter_type = %d, filter_value = '%s', results_per_page = %d
WHERE nid = '" . $node->nid . "'", $node->wnid, $node->kcid, $node->sort, addslashes(serialize($node->components)), $node->filter_type,
$node->filter_value, $node->results_per_page

should be

db_query("UPDATE {webform_report} u SET wnid = %d, kcid = %d, sort = %d, components = '%s', filter_type = %d, filter_value = '%s', results_per_page = %d
WHERE nid = '" . $node->nid . "'", $node->wnid, $node->kcid, $node->sort, addslashes(serialize($node->components)), $node->filter_type,
$node->filter_value, $node->results_per_page

notice the required space after "UPDATE {webform_report}"

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.