database error in site name

I got this database error in site name when someone try to invite me or i try to invite someone (Only in French Language) :

Database error in

Query:

                    SELECT 
                        IF(`sys_friend_list`.`ID` = 1, 
                            `sys_friend_list`.`Profile`, `sys_friend_list`.`ID`) AS `iMemberID`, 

                        IF(`sys_friend_list`.`ID` = 1, 'Demande d'amis', 'Le membre vous invite a devenir amis') 
                            AS `sType`, 

                        DATE_FORMAT(`sys_friend_list`.`When`, '%d.%m.%Y %H:%i') AS `sDate`

                    FROM
                        `sys_friend_list`
                    LEFT JOIN 
                        `Profiles`
                    ON
                        `Profiles`.`ID` = IF(`sys_friend_list`.`ID` = 1, 
                            `sys_friend_list`.`Profile`, `sys_friend_list`.`ID`)
                    WHERE
                        `sys_friend_list`.`ID` = 1
                         AND `sys_friend_list`.`Check` = 0  
                    ORDER BY
                       `sys_friend_list`.`When` DESC
                       LIMIT 0, 10

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 'amis', 'Le membre vous invite a devenir amis') AS ' at line 5

Found error in the file '/home/xxxxx/public_html/inc/classes/BxDolCommunicator.php' at line 168.
Called 'db_res' function with erroneous argument #0.

Thanks for your help :

Eli

The error is a result of the ' used between words.  When inserting into the sql the sql table reads it as a phrase and doesn't parse correctly.  I thought they implemented a escape apostrophe routine somewhere which is what you need when you use words like d'amis.

So please where do i have to looke for the problem and corrected ...

Thanks.

Eli

Hello, it's really a bug, ticket was added : http://www.boonex.com/trac/dolphin/ticket/1526#preview

En attendant la modification du script, tu peux remplacer "Demande d'amis" par, par exemple, "Ajouter aux amis" ou "Devenir amis", etc..., l'essentiel étant de ne pas utiliser cette apostrophe qui génère cette erreur ;-)

Fixed: http://www.boonex.com/trac/dolphin/changeset/13317

Merci bc Michel c est bien notee et le problem et resolu grace a toi :)

Eli