-----------------------------------------------------------------------------------------------------------
Zen Cart 1.5.1
Database Patch Level: 1.5.1
v1.5.1 [2013-06-23 18:22:47] (Version Update 1.5.0->1.5.1)
v1.5.0 [2013-06-23 18:22:47] (Version Update 1.3.9->1.5.0)
v1.3.9h [2011-02-02 09:45:55] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-08-27 00:17:50] (Fresh Installation)
PHP Version 5.2.17
Server OS: Linux 3.2.44 Database: MySQL 5.5.23-55
Server Date: 06/27/2013 13:35:50 Database Date: 06/27/2013 13:35:50
Server Up Time: 13:35:50 up 44 days, 3:11, 0 users, load average: 0.05, 0.01, 0.00 HTTP Server: Apache
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 256M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M
Database Data Size: 24,686 kB Database Index Size: 4,178 kB
-----------------------------------------------------------------------------------------------------------
The problem.... I've installed several mods and I'm not sure at what point this happened but when I try to access the Attributes Controller, Options Name Manager, or Options Value Manager through the admin, I get the following with strict error reporting enabled:
Code:
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 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1
in:
[INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')]
I've backtracked my steps and uninstalled mods one by one that were recently added or upgraded and still nothing, I am no good with SQL so I'm afraid to go poking around in there.... any help ya'll might have regarding this would be appreciated.....
The mods I was working on today were the Stock by Attributes, Dynamic Dropdowns for SBA, and Inventory Report.... but I can't be certain it wasn't working before messing with the site today either
Bookmarks