You have an error in your SQL syntax; Logging failed Options

[evbeej]

Hello,

I have received the following error on two of our sites (that are on the same server)

Logging failedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'get = '[]', session='[]', ip = '81.138.223.98', pageLevel = '', userLevel = '', ' at line 1

the following is where i think it is saying the problem is...:

$sessionCookieExpireTime=8*60*60;

session_set_cookie_params($sessionCookieExpireTime);

if (!$_SESSION) { session_start(); }

if ($_GET['a'] == "logout" || $logout == "logout") { session_destroy(); }

require_once("ugs/class_ugs_client.php");

$ugs = new UGS;

$ugs->addLog(json_encode($_POST),json_encode($_GET),json_encode($_SESSION),$_SERVER['REMOTE_ADDR'],$page_level,json_encode($_SERVER));

any help would really be appreciated.

[evbeej]

Ok, it looks like the following function is what is causing the error... :

function addLog($post,$get,$sess,$ip,$pageLevel=0,$server=0) {

mysql_query("INSERT INTO logs SET post='".mysql_real_escape_string($post)."', get = '".mysql_real_escape_string($get)."', session='".mysql_real_escape_string ($sess)."', ip = '{$ip}', pageLevel = '{$pageLevel}', userLevel = '{$_SESSION['role']}', userid = '{$_SESSION['uuid']}', sessionid = '".session_id()."', url = '".mysql_real_escape_string($_SERVER['REQUEST_URI'])."', server='".mysql_real_escape_string($server)."'",$this->db) or die("Logging failed".mysql_error());
}

So i am going to investigate this a bit further. As it was not where i thought it was at all.