Results 1 to 3 of 3

Hybrid View

  1. #1
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default SQL Error in admin product attributes areas

    admin to go to any of these
    /options_name_manager.php
    /options_values_manager.php
    /attributes_controller.php
    /option_name.php
    /option_values.php

    Zen cart v1.5.1
    upgraded from 1.3.9
    upgraded by hand using procedures
    plugins: bluepay_an, freecharger, ups, usps
    Installed via FTP/zc_install
    PHP 5.3.29
    MYSQL 5.5.39-MariaDB
    Started - not sure, only found it today
    Code:
    [08-Oct-2014 10:32:30 America/New_York] PHP Fatal error:  1064:You have  an error in your SQL syntax; check the manual that corresponds to your  MariaDB server version for the right syntax to use near  'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT  INTO products_options_values (products_options_values_id, language_id,  products_options_values_name) VALUES  ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /redacted/includes/classes/db/mysql/query_factory.php  on line 120

    Store's been live for years. I am looking at raw sql files, there's nothing in products_attributes table so the problem might always have been here.

    Customizations:
    removed .html from seo urls
    added google analytics javascript
    changed credit card info so admin can delete info from store database
    added "tax exempt customer"
    added ultimate seo urls
    added facebook ad tracking pixel
    added perfectaudience ad tracking pixel
    upgrade favicon image link statements
    added master admin login (customer's user name, admin's password)

    b-naturals.com

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: SQL Error in admin product attributes areas

    You might look at this post on how to repair that:
    http://www.zen-cart.com/showthread.p...29-with-v1-5-1

    This often occurs when installing an add-on that is not correctly written ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Apr 2007
    Location
    Manchester, NH
    Posts
    52
    Plugin Contributions
    0

    Default Re: SQL Error in admin product attributes areas

    I was just going to post this thread with the zip file thank you :)
    http://www.zen-cart.com/showthread.p...25#post1154025

 

 

Similar Threads

  1. Replies: 2
    Last Post: 27 Sep 2013, 02:59 AM
  2. Replies: 4
    Last Post: 26 Aug 2010, 05:20 PM
  3. Replies: 2
    Last Post: 13 Sep 2009, 04:33 PM
  4. SQL error+admin panel
    By characterdriven in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 19 Dec 2006, 03:34 AM

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