Banner manager

[CreoleMoon]

I was trying to "change" an old banner out that I had displayed at the bottom of my site and in doing so erased a "key" component under the "banner manager" section that one clicks on in the administration box...I hope that's clear? anyhoot, this is what reads now when I click on the banner manager section within the administration box:

 

 

Banner Manager

 

Banners Groups Displays / Clicks Status 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 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 -10, 10

 

 

what does that mean? and, how can I bring the coding/configuration back in order to utalize this feature? The same thing happened in my newsletter section. In fact that section has never worked..it reads the same when I click on it:

 

Newsletter Manager

 

Newsletters Size Module Sent Status 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 newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -10, 10

 

 

any insight would be greatly appreciated.

[♥geoffreywalton]

I seem to remember a problem like this in the patches for php 5.

 

The link in my sig block for solutions to common problems could point you in the right direction (limit -20, 20).

 

G

[CreoleMoon]

I seem to remember a problem like this in the patches for php 5.

 

The link in my sig block for solutions to common problems could point you in the right direction (limit -20, 20).

 

G

 

 

hey cher, na..that didn't work? <_<