Regarding webformreport installation issue

Posted by arav5555 on March 10, 2009 at 2:35pm

Issue Summary

I installed webform report under the modules directory. I tried to create the report and it gave me the below errors. I saw some similar queries in the forum and change the line 230 UPDATE {webform_report}u SET wnid to UPDATE {webform_report} SET wnid.. in webform_report.module file. After changing it also , enabling and disabling the module also it doesn't work. It is showing table not found.

"user warning: Table 'drupal.webform_report' doesn't exist query: UPDATE webform_report SET wnid = 8, kcid = 5, sort = 4, components = 'a:10:{i:-1;s:2:\\\"-1\\\";i:-2;s:2:\\\"-2\\\";i:-3;s:2:\\\"-3\\\";i:-4;s:2:\\\"-4\\\";i:3;s:1:\\\"3\\\";i:2;s:1:\\\"2\\\";i:4;s:1:\\\"4\\\";i:5;s:1:\\\"5\\\";i:6;s:1:\\\"6\\\";i:-5;s:2:\\\"-5\\\";}', filter_type = 0, filter_value = '', results_per_page = 20 WHERE nid = '14' in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal\modules\webform_report\webform_report.module on line 233.
user warning: Table 'drupal.webform_report' doesn't exist query: SELECT wnid, kcid, description, sort, filter_type, filter_value, results_per_page, components FROM webform_report WHERE nid = '14' in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal\modules\webform_report\webform_report.module on line 170.
user warning: Table 'drupal.webform_report' doesn't exist query: SELECT wnid, kcid, description, sort, filter_type, filter_value, results_per_page, components FROM webform_report WHERE nid = '14' in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal\modules\webform_report\webform_report.module on line 170.
user warning: Table 'drupal.webform_report' doesn't exist query: SELECT wnid FROM webform_report WHERE nid = '14' in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal\modules\webform_report\webform_report.module on line 326."

The database name is drupal in mysql. I am not sure why the table webform_report is not created.

Could any one help me regarding this?

Comments

#1

Posted by Vako on March 10, 2009 at 8:46pm

My initial response would be to remove and re-install the webform_report module.
When you edited the file webform_report.module, did you remove only the character u or anything else as well? and hope you only used a text editor to edit that file.

After I removed the "u", the module is working excellent for me.

#2

Posted by arav5555 on March 11, 2009 at 6:39am

I did only one change in the webform_report module Just removing the character 'u' in line number 230.
I deleted the webformreport module directory and i created it again. Did the same change in webform_report.module file and tried it . Not sure why it is not working. Also tried enabling and disabling the module after making the changes. It's saying drupal.webform_report table is not created.