Results 1 to 2 of 2

SQL Backup Error

This is a discussion on SQL Backup Error within the osCMax v2 Features Discussion forums, part of the osCmax v2.0 Forums category; When I try to backup my db I get the following error: 1064 - You have an error in your ...

      
  1. #1
    Member
    Join Date
    Nov 2005
    Location
    Central Texas
    Posts
    38
    Rep Power
    0


    Default SQL Backup Error

    When I try to backup my db I get the following 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 'Desc,Weight,Price from Products' at line 1

    select Prod Id,Desc,Weight,Price from Products

    [TEP STOP]


    Any thoughts on this? This happens on secure, not secure, save server side and direct, compression, no compression.

  2. #2
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,688
    Rep Power
    22


    Default RE: SQL Backup Error

    I have mentioned this to MIKE and gave him a fix for it a while ago but he has not included it in the core as he can't replicate the error... I think it was a duplicate feild....not sure....
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

Similar Threads

  1. Backup Compression Problems
    By zonzo_1 in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 01-31-2006, 10:19 AM
  2. Weird Backup..
    By xinete in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 01-12-2005, 08:52 AM
  3. BackUp OSC from Cpanel
    By peter in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 12-27-2004, 07:05 AM
  4. Backup restore problems
    By hamnebo in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 11-30-2004, 11:38 AM
  5. Syntax error when restoring backup database file
    By Anonymous in forum osCMax v1.7 Installation
    Replies: 0
    Last Post: 07-09-2004, 10:40 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
  •