I have teh following error message which appears when I try to post a message in the guestbook (CB ProfileBook) :
[code:1]pbSave SQL error: DB function failed with error number 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 'est du tonnerre ! B«»)', postervote=5, posterip='someip',posterid='6' at line 1 SQL=INSERT INTO ce_comprofiler_plug_profilebook SET postername='admin', posteremail='somemail', posterlocation='Montpellier', postercomment='CB, c'est du tonnerre ! B«»)', postervote=5, posterip='someip',posterid='62',userid='64',published='1',date=NOW(),posterurl='somewebsite'
SQL =
INSERT INTO ce_comprofiler_plug_profilebook SET postername='admin', posteremail='somemail', posterlocation='Montpellier', postercomment='CB, c'est du tonnerre ! B«»)', postervote=5, posterip='someip',posterid='62',userid='64',published='1',date=NOW(),posterurl='somewebsite'[/code:1]
Could someone tell me what's wrong ?
I'm using PHP 5.2.1 znd MySQL 4.1.21 and lastest versions of CB and the plugin. Joomla 1.0.13
Post edited by: Epsylon, at: 2007/11/08 17:30