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...
Bookmarks