osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

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 ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v1.7 Forums > osCMax v1.7 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 07-10-2004, 03:19 PM
Active Member
 
Join Date: May 2004
Location: worcester ma
Posts: 162
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
fridgemags
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 07-10-2004, 03:21 PM
Active Member
 
Join Date: May 2004
Location: worcester ma
Posts: 162
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
fridgemags
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 07-12-2004, 07:34 AM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,665
Thanks: 2
Thanked 93 Times in 79 Posts
Rep Power: 12
jpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of light
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
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 12:29 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax