I installed webform-6.x-2.6 under the modules directory. I tried to create the report and it gave me the below errors.
"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."
I saw some similar queries 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.
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
Could anyone help me
Could anyone help me regarding this?
create a bug report
you're better of creating a new issue in the webform project page, see http://drupal.org/node/add/project-issue/webform
Attiks - Print and web design
Web Form
I have some similar problems. Here are some of things that I did to solve the problem. Start at the top and work down the list.
1.If you are running Acqual Drupal, make sure that you have the latest version and that it is the acquia directory and not sites/all/modules.
2. On the module page, uncheck webform and any associated files associate with webform.
3. On the module page, at the top of the screen click unstall and unstall webform and others that you have unchecked. Then re-install modules
4. run update.php
5. If all else fails, go into mysqul and delete all webform tables, run update.php.
I hope that this helps.
James Roughton, Safety Professional and Drupal Fan
regarding drupal webform report
Thanks a lot. Will try it out and let you know
Hi Gotsaftety, Thanks a lot.
Hi Gotsaftety,
Thanks a lot. Finally it worked. I did the below things to work.
1. File name - In webform_report.install file i removed the default values for component and description fields
function webform_report_schema() {
$schema['webform_report'] = array (
'fields' => array(
'nid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
'wnid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
'kcid' => array('type' => 'int', 'not null' => TRUE, 'default' => 0),
'description' => array('type' => 'text', 'not null' => TRUE),
'sort' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 4, 'size' => 'small'),
'components' => array('type' => 'text', 'not null' => TRUE),
'filter_type' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'size' => 'small'),
'filter_value' => array('type' => 'varchar', 'not null' => TRUE, 'default' => '', 'length' => 128),
'results_per_page' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 20, 'size' => 'tiny')
),
'primary key' => array('nid')
);
return $schema;
}
2. In C:\Program Files\MySQL\MySQL Server 6.0\my.ini file i modified the
i changed
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to
sql-mode=""
restart mysql service
and work fine for me
I did the below things to work:
1. webform_report.module line 230:
Remove the extra 'u': http://drupal.org/node/331574
2. webform_report.install line 18:
Remove the 'not null' and 'default' keys:
'description' => array('type' => 'text'),
3. webform_report.install line 20:
Remove the 'not null' and 'default' keys:
'components' => array('type' => 'text'),
And it works.
I didn't change anything in the MySQL's "my.ini" file.