Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    43
    Plugin Contributions
    0

    Default Problem with Attributes Controller, Option Name Manager, Option Value Manager

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

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: Problem with Attributes Controller, Option Name Manager, Option Value Manager

    Do you use a non-blank DB_PREFIX (e.g. 'zen_') for your database? If so, this bugfix will help: http://www.zen-cart.com/showthread.p...-after-upgrade

  3. #3
    Join Date
    Feb 2008
    Posts
    43
    Plugin Contributions
    0

    Default Re: Problem with Attributes Controller, Option Name Manager, Option Value Manager

    That did the trick... thanks

 

 

Similar Threads

  1. Option Value manager problem
    By staycu in forum Customization from the Admin
    Replies: 1
    Last Post: 17 Jun 2011, 11:54 AM
  2. Attributes Controller - Increasing rows displayed for Option Name and Option Value?
    By ThisSideOfTheCross in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 23 Apr 2010, 05:13 AM
  3. Attributes - Align Option Name with Option Value?
    By dropbop in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 28 Sep 2009, 07:54 PM
  4. Attributes controller issue: option Name and Value List empty
    By phillip.darley in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 20 Aug 2009, 10:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR