I keep getting this error showing up in my security tracker. It's an sql error in header.php. any ideas?

Date              Time         IP                        Message
---------[SQL Error]------------------------------------------------------------------------------------------------------------
  - [15 May 2015 - 09:16:58] -
User: ******
IP: ******
URL: /index.php

File: /home/aahqcom/public_html/header.php
Line: 187
Message:
Code:
Query: UPDATE nuke_session SET uname="*******", time="1431699418", guest="0", module="", url="/index.php" WHERE host_addr="********"

Also, people are getting some kind of file compression error.  Could this be related??

delete that table in your database and re submit the query for that table in your sql.

Open:
header.php

On or around line 170
FIND:


 
Replace With:

 
That possibly should fix that error.

— coRpSE wrote

Open:
header.php

On or around line 170
FIND:

PHP:  [ Select all ]

       $result = $db->sql_query('UPDATE '.$prefix.'_session SET uname="'.$uname.'", time="'.$ctime.'", guest="'.$guest.'", module="'.$custom_title.'", url="'.$url.'" WHERE host_addr="'.$ip.'"'); 

 
Replace With:

PHP:  [ Select all ]

       $result = $db->sql_query('UPDATE '.$prefix.'_session SET time="'.$ctime.'", guest="'.$guest.'", module="'.$custom_title.'", url="'.$url.'" WHERE uname="'.$uname.'" OR host_addr="'.$ip.'"'); 

 
That possibly should fix that error.

TY sir, will give it a go!