osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

1064 - You have an error in your SQL syntax;

This is a discussion on 1064 - You have an error in your SQL syntax; within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Hi, Recent oscMAX version. MySQL 5 PHP 5 From Admin/Customers page, I click on Orders button and get this message. ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 07-28-2007, 08:00 PM
Active Member
 
Join Date: Nov 2002
Location: Sydney
Posts: 129
Thanks: 12
Thanked 0 Times in 0 Posts
Rep Power: 7
ozstar is on a distinguished road
Default 1064 - You have an error in your SQL syntax;

Hi,

Recent oscMAX version.

MySQL 5 PHP 5

From Admin/Customers page, I click on Orders button and get this message.

Any ideas please?

I only noticed as I got a PayPal notification without an order. I saw the customer had registered but when trying to find his order this happened.

When I go straight to Orders from side panel, there is no order there.


Thanks

oz


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

select o.orders_id, o.customers_name, o.customers_id, 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.customers_id = '188' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -50, 50
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
  #2  
Old 07-30-2007, 08:34 AM
Member
 
Join Date: Feb 2007
Posts: 31
Thanks: 2
Thanked 2 Times in 2 Posts
Rep Power: 0
Autoegocrat is on a distinguished road
Default Re: 1064 - You have an error in your SQL syntax;

Try this thread:
1064 - You have an error in your SQL syntax - osCommerce Community Support Forums

If that doesn't work, try disabling SEO Urls.

Auto
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
Reply

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
1064 - error in your SQL syntax admin customer search webwolfe osCMax v1.7 Discussion 0 11-10-2006 07:13 AM
1064 - You have an error in your SQL syntax. jamie74 osCommerce 2.2 Modification Help 0 10-20-2004 12:45 PM
1064 error when creating new account CTapia osCommerce 2.2 Installation Help 2 10-01-2004 03:20 AM
1064 - You have an error in your SQL syntax. j0ly osCommerce 2.2 Installation Help 1 08-24-2004 04:13 PM
1064 - You have an error in your SQL syntax Anonymous osCMax v1.7 Installation 3 05-10-2004 11:48 AM


All times are GMT -8. The time now is 09:48 PM.


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