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

[CraigW]

To fix the 1064 error above:

Just remove all the entries under "Purchase Order payment module configs" heading in the SQL file. These are not required.

These are the lines from the SQL file you want to remove.

-- Purchase Order payment module configs
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', ...
INSERT INTO configuration VALUES (NULL, 'Make payable to:', ...
INSERT INTO configuration VALUES (NULL, 'Sort order of display.', ...
INSERT INTO configuration VALUES (NULL, 'Payment Zone', ...
INSERT INTO configuration VALUES (NULL, 'Set Order Status', ...

I dropped all the tables in phpMyAdmin and then imported my backup SQL file, then re-ran the upload of this SQL file with Zen Cart.