Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 SQL Error in admin tools / Banner Manager


daywalker28

Recommended Posts

I am getting an SQL error (see below) when I go to the banner manager from the admin tools area.

 

I have backed up, restored and uploaded a change of OSC template in the past. So maybe something was misconfigured in the process or perhaps it has to do with the version.

 

 

Error I'm getting is:

 

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 banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_title, banners_group limit -20, 20

 

[TEP STOP]

Blake Paris

www.mythicstyle.net

"A Style for Every Story"

You on MySpace? Hit Me Up at www.myspace.com/mythicstyle

Link to comment
Share on other sites

You could follow the patches link in my signature block ......

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...