HELP with Mysql Database Error

Many of the uploaded Video's, sounds have TAGS with apostrophe's & I get the following error because of the ' in the tag:

Mysql error: 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 're+Welcome'' at line 1

Mysql can't read the TAG with the apostrophe properly & returns a database query error. Does anyone know how to fix that issue? Thanks much..

Quote · 19 Feb 2012

Dolphin should be escaping the quote by adding a "\" before the apostrophe so the database accepts it. Php would handle it if magic quotes was turned on but Dolphin wants it to be turned off so it can handle the db prep itself.

 

The fact that Dolphin ISN'T escaping the quote is a security hole... I think a ticket is in order.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 19 Feb 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.