Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

You Have An Error In Your Sql Syntax


ktiss

Recommended Posts

hello

Having the following problem on:

 

Banner Manager

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

 

select * from affiliate_banners order by affiliate_banners_title, affiliate_banners_group limit -20, 20

 

Affiliate Manager]

 

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

 

select * from affiliate_affiliate order by affiliate_lastname limit -20, 20

 

This Happened after our server was hacked a few months back.

Everything else works

Link to comment
Share on other sites

Download the latest oscommerce package (above menu, Solutions->Downlaods) and look at the update doc for split_page_result for the fix.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...