I just installed webform_reports 6.x-2.0 with Webform 6.x-3.6 and Webform PHP 6.x-3.x-dev, running MySQL 5.0.51a-3ubuntu5.7, Drupal 6.19.

I created a new "Webform Report" content type and filled out the required fields and selected the webform that I want to use to create the report, clicked on Save and I get a message:

"It appears that no criteria have been specified for this report. Please click on Report Criteria under Edit to add webform data to your report."

So, I click on Edit and then Report Criteria and get the message:

"Error - Webform is not set for this report - cannot proceed. Please delete and re-create this report."

I checked the webform_report table and there are no entries so evidently the initial save was not successful.

Any clues as to where to go from here?

Thanks,
Gary

Comments

jimbullington’s picture

jimbullington commented

Thank you for the report - sorry you are having trouble.

This message usually indicates that the webform_report table was not created at install time. Try to disable and uninstall the module, then re-enable it.

Failing that, you may have to create the table manually - for MySQL, something like:

CREATE TABLE IF NOT EXISTS `webform_report` (
  `nid` int(10) unsigned NOT NULL DEFAULT '0',
  `wnid` int(10) unsigned NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `columns` text NOT NULL,
  `filters` text NOT NULL,
  `sorton` text NOT NULL,
  `options` text NOT NULL,
  PRIMARY KEY (`nid`)
);
gary.betz’s picture

gary.betz commented
Status: Active » Closed (fixed)

Thanks Jim,

I removed the webform_report table and reinstalled the whole module and all is fine. I'm guessing that I may have installed webform_report previously with an older version and the table was lingering about. My bad.

Thanks for the speedy response.

Best,
Gary