Database Error Tags special characters.

Hello,

How to fix database error when the tag contain special characters like % ' ...

for example:


SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `Profiles` ON
`Profiles`.`ID`=`RayVideoFiles`.`Owner` left JOIN `sys_albums_objects`
ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN
`sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album`
WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND
CONCAT(`RayVideoFiles`.`Tags`) LIKE ('%'movie'%') AND
`sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'
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 'movie'%') AND `sys_albums`.`Status` ='active' AND
`sys_albums`.`Type` ='bx_video' at line 1

Quote · 16 Sep 2010
 
 
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.