My Advertisements has experienced an internal SQL error and cannot continue.

[Mhz]

Good Morning

Just encountered an error when attempting to delete and advertisement or announcement with the plugin

My Advertisements.

I have deleted a few already but the last one give me a SQL error and the message will not leave the header on forums page. And its not in the adminCP anymore.

Error message is below. I am hoping this is something I can edit in my control panel on my server





MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
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 'LIMIT 1' at line 2
Query:
UPDATE mybb_myadvertisements_zones SET ads=ads-1 WHERE zid= LIMIT 1

[Lennart Sauter]

Looks like a zone is missing.

[Mhz]

Looks like a zone is missing.

I see to inputs in the SQL ... find attached a screenshot

---

Alright I can explore the source page and find the bam accouncement... So my question is since it wont remove the advert via the program ... where in the template would this be so I could delete it manually.

Its laying above the forums but I cannot find it in the template index or header etc.. And i do not see a search button for templates lol...

I would love to remove this then go try some of the sub mybbaddons at your forum.

---

Found this in the read me of the plugin..

* 1.5
Fixed SQL error in delete advertisement action.

---

SOLVED

I rebuilt/repair my database and it decided to work..

All zones are in order