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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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 |
| Sponsored Links | ||
| ||
| |
|
#2
| |||
| |||
| 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
| ||||
| ||||
| 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 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! |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| new server, now getting no modules in admin and errors. | red_fraggle | osCommerce 2.2 Installation Help | 4 | 01-19-2005 09:09 AM |
| Fatal Errors in Admin...... | Anonymous | osCMax v1.7 Installation | 2 | 12-23-2003 05:50 AM |
| Errors in admin/includes/application_top.php Please Help! | ckiel | osCommerce 2.2 Installation Help | 0 | 08-26-2003 08:08 PM |
| Admin module errors | Ozi | osCommerce 2.2 Modification Help | 0 | 02-25-2003 04:43 AM |
| Errors when running admin package | Anonymous | osCommerce 2.2 Installation Help | 1 | 11-27-2002 12:47 PM |