● Error in header.php

Fri May 15, 2015 8:33 am
NOOB!!!
37 Posts
Reputation: 256.6
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??
Fri May 15, 2015 11:02 am
NOOB!!!
28 Posts
Reputation: 196.5
delete that table in your database and re submit the query for that table in your sql.
Fri May 15, 2015 11:39 am
Clan Leader
Top Dog
Nuke Dev / Coder
3015 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 77.7hrs.
Total Played: 195hrs.


  
There is life outside of the game.
Reputation: 7317.9
votes: 7
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.


Expand
Fri May 15, 2015 2:22 pm
Original Poster
NOOB!!!
37 Posts
Reputation: 256.6
— 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!


 
Forums ©