we need to add addslashes on the email systems, when we translate the email template, with ' (apostrophe) inside the email we got a bunch of database error: like this one :
INSERT INTO `sys_sbs_queue`(`email`, `subject`, `body`) VALUES('patetkim@xxxxx.com', 'Match Notification', '
<html> <head> </ head> <body style="margin: 12px Verdana; color:#000000">
<p> <b> Bonjour patetkim(2) </ b>, </ p>
<p> Nous sommes heureux de vous informer que le profil a été ajouté ou modifié....
<br /> automatique d'e-mail, s'il vous plaît, ne répondez pas !!!</ p> </ body> </ html>')
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
'e-mail, s'il vous plaît, ne répondez pas !!! ')' at line
1
Found error in the file
'/var/www/vhosts/xxx/httpdocs/v2/inc/classes/BxDolAlertsResponceMatch.php'
at line 82.
Called 'query' function with erroneous argument
#0.
need to check this....
