Error message while installing (1064 - SQL syntax)

[DataJack]

I've been reinstalling the latest version of Zen cart (1.3.0.2) from scratch on a online hosting account at Brinkster.com...

I've had a working older version working.

Now, i'm getting an error message while installing (using Zc_Install) here it is:

Installation In Progress...

~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~

~ ~
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 'asc\', \'desc\'), ', now())' at line 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', 'zen_cfg_select_option(array(\'asc\', \'desc\'), ', now());]

This happen right after the db settings screen.

I tried many times, deleting and reuploading the files each time.
I've drop all the tables from the db using the MySQL Administrator tool each time, ensuring the db was empty.

Any clues?

I've been suspecting versions of MySQL on the server but everything seems alright and it use to be working!

Webserver = Microsoft-IIS/6.0
HTTP Host = technoselect.brinkster.net
Path_Translated = C:\\Sites\\Single23\\Technoselect\\webroot\\zc_install\\index.php
PHP O/S = WINNT
PHP API Mode = cgi-fcgi Click here for more info
PHP Max Execution Time per page = 60
Register Globals = OFF
MySQL Support = ON
MySQL Version = 5.0.15-nt Click here for more info
PHP Version = 4.3.6
PHP Safe Mode = OFF
PHP Sessions Support = ON
PHP Session.AutoStart = OFF
PHP session.use_trans_sid = OFF
Current SQL Cache Folder = C:/Sites/Single23/Technoselect/webroot/cache -->Writeable
Suggested SQL Cache Folder = C:/Sites/Single23/Technoselect/webroot/cache
PHP magic_quotes_runtime setting = OFF
PHP GD Support = ON
GD Version = GD bundled (2.0.23 compatible)
PHP ZLIB Compression Support = ON
PHP cURL Support = OFF Click here for more info
PHP Upload Support = ON upload_max_filesize=10M; post_max_size=10M
PHP Upload TMP dir = C:\PHP\uploadtemp
PHP XML Support = ON
PHP FTP Support = ON


Any help from you guys will be appreciated...

[superprg]

Seems like at the time of running the query, all the queries are not getting copied when the query is getting run
May be you can try running the sql queries in parts

[Vger]

I'm afraid you are going to have severe problems with that server setup. Windows isn't best for dynamic php applications anyway, but on top of that the server is running a very old version of PHP with one of the most up to date versions of MySQL. It's also running PHP as a cgi exec (not good news), and there's no support for cURL which you'll find necessary to perform basic encryption with many payment modules.

Vger

[DataJack]

Thanks both of you guys for your reply.

Actually im running on these version:

MySQL Version = 5.0.15-nt
PHP Version = 4.3.6

And weirdly enough, it was working pretty neatly couple of months ago with an older version of ZenCart


I'll probably have a hard time explaining this to the boss if there's actually no way of fixin' this... Actually i'll have the installation move to another server witch support PHP5 and retry...

I'll give you guys news of further development!

[DrByte]

Lovely Brinkster. My first experience working with Zen Cart on a Brinkster windows server was bad ... couldn't do it, and their FTP and control panels were slow. Ended up going elsewhere. Never came back.


Anyway, that aside, the problem is occurring where escaped quotation marks are getting translated.

This is usually a result of magic-quotes-runtime being enabled, but your system specs show that they are not enabled. At the moment I'm not recalling any quick workaround for it without rewriting code specifically for Brinkster... One would hope it's simply a PHP setting that can be changed for your setup and make it work like most other sites do ;)

[Loupblanc]

I have exactly the same issue:

When I install the super_orders_sql.sql over the SQL-patches Tool in ZC Admin, I get following error message:

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 _ppconfiguration 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'), ');]

but: with Linux and not Windows:

System Linux vmu1-2 2.6.18.5-xen-x86-domu-001 #1 SMP Wed Sep 26 14:45:56 CEST 2007 i686
Build Date Aug 28 2007 18:09:28
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /opt/php/lib/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.zlib

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/opt/misc/mysql/include/mysql
MYSQL_LIBS -L/opt/misc/mysql/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent Off Off
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

Can someone help me?

Thanks

[DrByte]

use phpMyAdmin instead, and include your table-prefix in front of each table name.

[Vger]

To clarify a little further, when using phpMyAdmin to install an sql file for an add-on you usually upload the file itself. If you open the file and run the contents in the SQL Query window then you'll need to modify the contents.

Vger