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

Any help?

That would be a bug. The % sign has special meaning for MYSQL. Thus it should be filtered to prevent it use, or escaped with a \

You should repost this in the bug reports forum.

Ok i will :)