Banners.php datbase query error

Try to go and edit my banners in the admin panel and all I get is an "error database query error"  .. any ideas?

Tussery did you resolve this issue? (or anyone else got a solution?)

The same thing has just started to happen on my site, and only reference I can find to similar error is your post.

Many thanks

You should get the details of the error in your bug report email. Post it here so others can help. Ensure that you post only the section of the message that shows the actual SQL error.

Thanks, we weren't getting bug report emails (old email address). Updated that and then instantly could see our sys_banners_shows table was corrupted. Ran a mysql repair on it and eveything is good now.

Many thanks!!