Just upgraded webform module to the latest development version and got the following error message after upgrade when running the database update:

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 '== -1 WHERE submit_interval == 157784630' at line 1 query: UPDATE webform SET submit_interval == -1 WHERE submit_interval == 157784630 in /home/webbikau/public_html/includes/database.mysql.inc on line 172.

The following queries were executed
webform module
Update #17
* Failed: UPDATE {webform} SET submit_interval == -1 WHERE submit_interval == 157784630

Comments

Abilnet’s picture

Abilnet commented

Sorry, forgot the server info:

MySQL database 5.0.45
PHP 5.2.3
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server Apache/1.3.37 (Unix) PHP/5.2.3 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Fixed

Thanks Abilnet. I wonder why this didn't throw an error when I tested it locally. The SQL should be:

UPDATE webform SET submit_interval = -1 WHERE submit_interval = 157784630;

Note the single = instead of ==. Apologies for the mistake. It's now fixed in 2.x CVS.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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