Latest Announcemnent
New thread
Status
Not open for further replies.
P

pspuser007

Active Member
161
2008
0
0
Hello all.


I was hacked yesterday.
When I am trying to access any thread at my forum i see this:
Code: 
Warning: Division by zero in [path]/global.php(400) : eval()'d code on line 158

Warning: Division by zero in [path]/global.php(400) : eval()'d code on line 164

Warning: Division by zero in [path]/global.php(400) : eval()'d code on line 168
Database Error     Database error
The NuclearWarez::The Radioactive Warez database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the www.nuclearwarez.com home page, then try to open another page.
    * Click the Back button to try another link.

The www.nuclearwarez.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.
Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT COUNT(*) AS num FROM post AS post LEFT JOIN thread AS thread on post.threadid=thread.threadid LEFT JOIN forum AS forum on thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=2)AND(post.dateline>=);

MySQL Error   : 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 ')' at line 1
Error Number  : 1064
Request Date  : Friday, February 27th 2009 @ 06:30:11 AM
Error Date    : Friday, February 27th 2009 @ 06:30:12 AM
Script        : http://www.mydomain.com/forumdir/showthread.php?p=6371
Referrer      : http://www.mydomain.com/forumdir/
IP Address    : *****
Username      : myusername
Classname     : mydatabase
MySQL Version : 5.0.67-community


The mods are not working!

What can I do?

I am trying to restore a backup but i can't manage to do it...


Please help me!


Thank you for your time!
 
20 comments
try to repair and optomize your database in phpmyadmin.
try to login in to admin panel and fix unique indexes and optimize table under the maintainece tabs.

if everything fails to restore your previous db.

have a good day :)
 
Thank you for your reply!

Tried both of these...
I am trying to restore the database.
i tried through Cpanel and when i clicked the button upload it said after a while "Restoring Database" and then nothing.
I tried through phpmyadmin to import the backup(it had this extension .sql )
And I have now extracted the SQL file and I am trying to import it through phpmyadmin.But the file is 28MB in size.
EDIT:Now i got this : "Script timeout passed, if you want to finish import, please resubmit same file and import will resume."

What can I do guys?:(
 
use bigdump for importing large databases
and once you do that edit your config.php file like this

at the top of the file right after <?php line.

PHP: 
define('DISABLE_HOOKS', true);

make sure its rite at the top
this will disable all plugins until you find the problems
 
When i do it again i see this
"Premature end of script headers: php: Please check / usr / local / cpanel / logs / error_log for the exact error."

What can i do?
 
Thank you for the reply my friend!
I am using now bigdump but i got this error:
Code: 
Processing file: filename.sql.gz
 Starting from line: 3001
 
Error at the line 3021: SET character_set_client = @saved_cs_client;
 Query: SET character_set_client = @saved_cs_client;

 MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
 Stopped on error"

What can I do?
 
pspuser007 said:
Thank you for the reply my friend!
I am using now bigdump but i got this error:
Code: 
Processing file: filename.sql.gz
 Starting from line: 3001
 
Error at the line 3021: SET character_set_client = @saved_cs_client;
 Query: SET character_set_client = @saved_cs_client;

 MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
 Stopped on error"
What can I do?
Click to expand...
I have had that problem before, open the dump file (Use UltraEdit or some large file editor if needed) and remove that line.
 
pspuser007 said:
I have extracted the SQL file and edited it trough ultra edit.
Now what?

Thank you for the reply!
Click to expand...
dont remove that line
instead install xampp in ur pc copy the forum files in htdocs folder (make a new folder in htdocs name "forum")
go to http://localhost/security/xamppsecurity.php
change PhpMyAdmin authentification: to http and create a password for the root.

now go to http://localhost/phpmyadmin/
and create a database table.
restore your whataver big db is in the phpmyadmin.
it wont create any problem

edit the config.php according to the settings of phpmyadmin

go to localhost/forum/admincp/ and do a database backup through maintanience tab
if needed do repair optimize table and run fix unique indexes

now restore that db through bigdump

remember the process may be long but the result is effective.

i face the exactly same problem same error fewtimes but the above trick always work for me.
deleting lines from db is not a solution.

now rest depend on you whether u apply it or not.

have a nice day,
regards pirateaccess
 
Read this!

In most cases if 1 sql injection failed the whole proccess fails.
try mysql dumper >> www.mysqldumper.de/en

make sure after u set it up, to gto options and disable something that makes it stop incase restore failed. it is important, in this way u can restore ur database and if any query failed for any reason it will pass over it and simply ignore.
u can either restore the .sql or the compressed file.
 
OK i managed to save the backup from Admin Cp.
Now the only thing i have to do is use bigdump to upload it in example at the new server?
 
Status
Not open for further replies.
Back
Top