Super Orders 2.0: error 1064 SQL syntax

[henryvuong]

I am installing Super Orders 2.0 (rev 45) on Zen Cart 1.3.7. When I run the super_orders_sql.sql file on database, I got this error:

1064 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 'True', 'False'), ')' at line 1
in:
[INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I reinstalled the original database and tried this script both ways, from admin>tools>Install SQL Patches, and from phpMyAdmin, both produced the same error. Can somebody tell me what to do? Thanks.

[henryvuong]

I'm not very good at SQL syntax, but it looks like this command is missing a closing parenthesis at the end isn't it?

[henryvuong]

Please advise.

[henryvuong]

I found the solution. Instead of running the whole sql script, I broke it down and run one part at a time, but I must first restored my original database, otherwise I would get duplicate command error.

[Nichole]

Just wanted to say 'thanks' for figuring out and posting your workaround to this. I ran into this exact thing today and you saved me a lot of work!

[rbobzin]

Seems the sql file loaded OK (I used cut-n-paste method), but now get this error:

Warning: reset() [function.reset]: Passed variable is not an array or object in C:\Apache2\htdocs\ZenStart\admin\includes\functions\database.php on line 26
Warning: Variable passed to each() is not an array or object in C:\Apache2\htdocs\ZenStart\admin\includes\functions\database.php on line 50
1064 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 'where payment_type_id = '5'' at line 1
in:
[update so_payment_types se where payment_type_id = '5']

I'm using on localhost:
Apache/2.0.58 (Win32)
PHP/5.1.4
MySQL/5.0.22
Zen Cart 1.3.7

Is this a PHP or MySQL version problem, or something else? All help would be most appreciated. Thanks,

Rainer