osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Syntax error for specials page

This is a discussion on Syntax error for specials page within the osCMax v2 Features Discussion forums, part of the osCMax v2.0 Forums category; I am a novice. When I click on the specials, I get an error message(1064 for '-10,10' at line 1). ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Features Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 11-13-2005, 08:13 AM
Lurker
 
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
amandabuild
Default Syntax error for specials page

I am a novice. When I click on the specials, I get an error message(1064 for '-10,10' at line 1). Can someone help me, I'm flailing!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 11-15-2005, 12:44 AM
Lurker
 
Join Date: Nov 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
soupy
Default RE: Syntax error for specials page

I too am getting similar errors all over the place.

For example:

Customers Search:

Last Name First Name Account Created Action
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 c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit -10, 10
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 11-15-2005, 06:04 AM
Lurker
 
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
amandabuild
Default Recent updates?

Recent updates may have caused your error. My webman contacted me offline and told me this- "It was an old code bug that only shows up on new versions of SQL " Sounds like the answer is somewhere on the forum. Hope this helps!
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
SQL syntax error barnkin osCommerce 2.2 Installation Help 1 09-14-2004 09:13 PM
1064 - You have an error in your SQL syntax. j0ly osCommerce 2.2 Installation Help 1 08-24-2004 03:13 PM
bts 1.2a SQL syntax error nfmg osCMax v1.7 Discussion 1 08-21-2004 01:43 PM
1064 - You have an error in your SQL syntax Anonymous osCMax v1.7 Installation 3 05-10-2004 10:48 AM
SQL syntax error americamba osCommerce 2.2 Installation Help 1 01-05-2004 08:34 AM


All times are GMT -8. The time now is 02:33 PM.


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