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

Need help with sql errors showing up in admin

This is a discussion on Need help with sql errors showing up in admin within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version ...

      
  1. #1
    Active Member
    Join Date
    May 2004
    Location
    worcester ma
    Posts
    162
    Rep Power
    0


    Default Need help with sql errors showing up in admin

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

    select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -15, 15

    I dont know what file or code it is referring to. My hosting company just upgraded the MySql database and now am getting these errors in the admin.

    Any ideas?

    Thanx in advance for any and all help

  2. #2
    Active Member
    Join Date
    May 2004
    Location
    worcester ma
    Posts
    162
    Rep Power
    0


    Default

    I just did phpinfo on my server and apparently my host is using a beta version on my site. WTF, Sorry.

    Here is the version: MySQL 4.1.3-beta-standard

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


    Default

    Ask them to change it back (or move you) - they should NOT be using a MySQL BETA on a production machine.

    More than likly it is a BETA bug/change....
    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. new server, now getting no modules in admin and errors.
    By red_fraggle in forum osCommerce 2.2 Installation Help
    Replies: 4
    Last Post: 01-19-2005, 09:09 AM
  2. Fatal Errors in Admin......
    By Anonymous in forum osCMax v1.7 Installation
    Replies: 2
    Last Post: 12-23-2003, 05:50 AM
  3. Errors in admin/includes/application_top.php Please Help!
    By ckiel in forum osCommerce 2.2 Installation Help
    Replies: 0
    Last Post: 08-26-2003, 08:08 PM
  4. Admin module errors
    By Ozi in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 02-25-2003, 04:43 AM
  5. Errors when running admin package
    By Anonymous in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 11-27-2002, 12:47 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
  •