Cannot delete exhibitions - apostrophe bug

[cferrero]

When I try to delete an exhibition, I get the following MySQL error:

Exhibit Engine MySQL error!
ERROR FROM QUERY move_it_lang in page 'exhibition_delete':

------------------------------
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 's Birthday', ee_exhibition_eng.ee_exhibition_description =
------------------------------

I think the problem lies in the fact that the exhibition name has an apostrophe in it (as you can see in the error message above, the exhibition name has been truncated from "Ju's Birthday" to "'s Birthday"). The problem looks similar to those discussed here:
http://photography-on-the.net/forum/showthread.php?t=37434

The obvious workaround would be to rename the exhibition...but I can't see how to do this! :oops:

Any ideas?

[cferrero]

To follow on from this...

I renamed the problem exibition to "Test". The reason I couldn't do this before is because in the "edit exhibition data" page, the "Header" box was empty for this exhibition. In fact, it should contain the name of the exhibition, but the apostrophe bug prevents this.

With the exhibition renamed, I then go to "delete exhibitions". When I try to delete this exhibition, I get the following error:

ACTION CANCELED: language exhibition id's are not in sync. Can not proceeed. Future versions will have a tool to correct this anomaly (cause unknown so far). Contact EE author for help. EXITING....
press your browser's back button to return to editor.

Which isn't much of an improvement.