Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    5
    Plugin Contributions
    0

    Default problem with sql

    Hi

    I am having a problem with sql. There is happening this error:

    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 '000000 where products_id = '141'' at line 1

    Everything was fine until I decided to install MZMT and removing the discount coupons.

    I made a backup of the database and imported it sucessfully but the problem remains...

    Any ideas?

    Zen Cart 1.2.6
    Database Patch Level: 1.2.6
    PHP Version 4.4.1
    MySQL 4.0.27-standard

    Yes I know I have to update very urgently but for the time being I just want the store functioning again.

  2. #2
    Join Date
    Apr 2006
    Posts
    5
    Plugin Contributions
    0

    Default Re: problem with sql

    Solved there was a minor change in the english.php that originated the error.

    Just had to erase 2 lines of codes that were previously added.

 

 

Similar Threads

  1. Problem with SQL import
    By tragosina in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 18 Dec 2011, 03:19 PM
  2. SQL problem with filter by attributes addon
    By daparky in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 6 Jan 2010, 10:16 PM
  3. problem with sql export
    By metalball in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 11 Aug 2009, 10:47 PM
  4. problem with finding SQL Patches option?
    By katie929 in forum General Questions
    Replies: 1
    Last Post: 28 Jul 2007, 07:16 PM

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