Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 3 of 3

Thread: Admin Report syntax Error

  1. #1
    judoka
    Guest


    Default Admin Report syntax Error

    Hi Everyone,
    I am redesigning my website on my local machine using OSCMax 1.7. I am almost ready to uploaded it my live site and while setting up my admin. I notice the follow error message when I click on numerous sections in the admin. such as in the Report or tools section:

    "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 '-10, 10' at line 1

    select p.products_id, pd.products_name, pd.products_viewed, l.name from products p, products_description pd, languages l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC limit -10, 10"

    I try to figure this one out on my own but have had no success. Does any one know what this message means and how to fix it? As always any and all help would be appreciated.

    Thanks,
    Jose

  2. #2
    osCMax Developer


    Admin Report syntax Error


    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,134
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    597


    Default RE: Admin Report syntax Error


  3. #3
    judoka
    Guest


    Default Re: RE: Admin Report syntax Error

    Thanks Mike I believe that fix the problem.

Similar Threads

  1. 1064 - error in your SQL syntax admin customer search
    By webwolfe in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 11-10-2006, 07:13 AM
  2. SQL syntax error
    By barnkin in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 09-14-2004, 09:13 PM
  3. bts 1.2a SQL syntax error
    By nfmg in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 08-21-2004, 01:43 PM
  4. A syntax error in meta_tags?
    By DMG in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 01-22-2004, 02:56 PM
  5. SQL syntax error
    By americamba in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 01-05-2004, 09:34 AM

Bookmarks

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
  •