Hi,

I'm under Drupal 6.9 ; using php 5.2.8 with 64MB memory_limit ; MySQL 5.0.45 with phpMyAdmin - 2.10.2 & MySQL: UTF-8 Unicode (utf8) ;

All seems to work correctly but Drupal sends me warning messages when I use webform (don't understand why...) :

For example : when I have cleared a webform entrie, this message appears :

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY sid ASC, cid ASC, no ASC' at line 1 query: SELECT s.*, sd.cid, sd.no, sd.data, u.name, u.mail, u.status FROM webform_submissions s LEFT JOIN webform_submitted_data sd ON sd.sid = s.sid LEFT JOIN users u ON u.uid = s.uid WHERE sd.nid = 5 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /home/www/client/www/sites/all/modules/webform/webform_submissions.inc on line 168.

What could I do ?

Is webform not supported by MySQL 5.0.45 ?

Thank you for your help.

CommentFileSizeAuthor
#3 myadmin-semi5.celeonet.fr - 193.200.139.15 - pub_drupal - webform_submissions - phpMyAdmin 2.10.2_1233658024793.png64.84 KBmarcelduchamp
#3 myadmin-semi5.celeonet.fr - 193.200.139.15 - pub_drupal - webform_submitted_data - phpMyAdmin 2.10.2_1233658032418.png66.33 KBmarcelduchamp

Comments

gaele’s picture

gaele commented
Component: User interface » Code

Using webform 5.x-2.4 on Drupal 5.15, MySQL 5.0.67, PHP 5.2.6.

This is what happens when I visit an empty "node/#/results" page:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY sid ASC, cid ASC, no ASC' at line 1 query: SELECT s.*, sd.cid, sd.no, sd.data, u.name, u.mail, u.status FROM webform_submissions s LEFT JOIN webform_submitted_data sd ON sd.sid = s.sid LEFT JOIN users u ON u.uid = s.uid WHERE sd.nid = 505 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /home/www/drupal/includes/database.mysql.inc on line 174.

Same error, except for the calling file. Once the webform is submitted at least once the error disappears.

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (duplicate)

#360443: Empty results tab generates SQL error

marcelduchamp’s picture

marcelduchamp commented
StatusFileSize
new myadmin-semi5.celeonet.fr - 193.200.139.15 - pub_drupal - webform_submitted_data - phpMyAdmin 2.10.2_1233658032418.png66.33 KB
new myadmin-semi5.celeonet.fr - 193.200.139.15 - pub_drupal - webform_submissions - phpMyAdmin 2.10.2_1233658024793.png64.84 KB

YES quicksketch !

When I browse tables on phpMyAdmin, I Find these warnings under webform_submissions & webform_submitted_data tables :

"The column `sid ` should not be part at the same time of a primary key and a index key"

translated from french...

skilip’s picture

skilip commented

AFAIK this is caused by $sids being empty in the query.

marcelduchamp’s picture

marcelduchamp commented

In spite of this MySQL warning, Webform seems to work correctly for me...