Rapports traduction 1.8 fr - Version imprimable

Code :

MyBB has experienced an internal SQL error and cannot continue.



SQL Error:

    1064 - 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 'activation', `stars`=0, `starimage`='images/star.png', `image`='', `disporder`=0' at line 2

Query:

    UPDATE mybb_usergroups SET `gid`=5, `type`=1, `title`='Awaiting Activation', `description`='Utilisateurs n’ayant pas validés leur adresse mail.', `namestyle`='{username}', `usertitle`='Compte en attente d'activation', `stars`=0, `starimage`='images/star.png', `image`='', `disporder`=0, `isbannedgroup`=0, `canview`=1, `canviewthreads`=1, `canviewprofiles`=0, `candlattachments`=0, `canviewboardclosed`=0, `canpostthreads`=0, `canpostreplys`=0, `canpostattachments`=0, `canratethreads`=0, `modposts`=0, `modthreads`=0, `mod_edit_posts`=0, `modattachments`=0, `caneditposts`=0, `candeleteposts`=0, `candeletethreads`=0, `caneditattachments`=0, `canpostpolls`=0, `canvotepolls`=0, `canundovotes`=0, `canusepms`=0, `cansendpms`=0, `cantrackpms`=0, `candenypmreceipts`=0, `pmquota`=2, `maxpmrecipients`=1, `cansendemail`=0, `maxemails`=1, `emailfloodtime`=5, `canviewmemberlist`=1, `canviewcalendar`=1, `canaddevents`=0, `canbypasseventmod`=0, `canmoderateevents`=0, `canviewonline`=1, `canviewwolinvis`=0, `canviewonlineips`=0, `cancp`=0, `issupermod`=0, `cansearch`=1, `canusercp`=1, `canuploadavatars`=0, `canratemembers`=0, `canchangename`=0, `canbereported`=1, `canchangewebsite`=0, `showforumteam`=0, `usereputationsystem`=0, `cangivereputations`=0, `reputationpower`=0, `maxreputationsday`=0, `maxreputationsperuser`=0, `maxreputationsperthread`=0, `candisplaygroup`=1, `attachquota`=0, `cancustomtitle`=0, `canwarnusers`=0, `canreceivewarnings`=1, `maxwarningsday`=0, `canmodcp`=0, `showinbirthdaylist`=1, `canoverridepm`=0, `canusesig`=0, `canusesigxposts`=0, `signofollow`=1, `cansendemailoverride`=0, `edittimelimit`=0, `maxposts`=0, `showmemberlist`=1, `canmanageannounce`=0, `canmanagemodqueue`=0, `canmanagereportedcontent`=0, `canviewmodlogs`=0, `caneditprofiles`=0, `canbanusers`=0, `canviewwarnlogs`=0, `canuseipsearch`=0 WHERE title = 'Awaiting Activation'

Code PHP :

$query = $db->query("SELECT * FROM ".TABLE_PREFIX."usergroups");
if($db->num_rows($query)) 
    while ($usergroup = $db->fetch_array($query)) {
        $old_title= $db->escape_string($usergroup['title']);
        $usergroup['title'] = str_replace("'", "’", $usergroup['title']);
        $usergroup['description'] = str_replace("'", "’", $usergroup['description']);
        $db->update_query("usergroups", $usergroup, "title = '".$old_title."'");
    }