Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Banners deleted, getting error 1064


khouryby

Recommended Posts

Posted

Hi,

 

I deleted all the banners that came with oscommerce, and now I am getting this error when I go to 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 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

 

Not sure what to do. I guess if there was a way to upload the banners to where they should reside, that will solve the issue. Does anyone know where were these banners are stored and how to access them.

 

BTW, I am not getting the add banner in banner manager.

 

Thanks

Archived

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

×
×
  • Create New...