osCmax v2.5 User Manual
Results 1 to 3 of 3

Admin Report syntax Error

This is a discussion on Admin Report syntax Error within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; Hi Everyone, I am redesigning my website on my local machine using OSCMax 1.7. I am almost ready to uploaded ...

      
  1. #1
    Active Member
    Join Date
    May 2003
    Posts
    185
    Rep Power
    10


    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

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default RE: Admin Report syntax Error

    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Active Member
    Join Date
    May 2003
    Posts
    185
    Rep Power
    10


    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, 06: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, 01:56 PM
  5. SQL syntax error
    By americamba in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 01-05-2004, 08:34 AM

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
  •