View Full Version : help need urgently ive killed my forum
Rickie3
10-26-2005, 09:16 AM
hi all i'm in a real pickle here,i had a online user hack installed as detailed:::::Hack Who was online last 24H by CXII & svaliotti adapted by Mtor
final version (vBulletin 3 rc2)
but when i hit the uninstaller above it killed my forum this is the error i get;;;;;
-----------------------------------------------------------------------
Database error in vBulletin 3.0.3:
Invalid SQL: SELECT userid FROM sg_usersonline WHERE userid=1
mysql error: Table 'satsfge_.sg_usersonline' doesn't exist
mysql error number: 1146
Date: Wednesday 26th of October 2005 06:04:51 AM
Script: http://www.sats-general.com/forum/index.php?
the reason i wanted to uninstall is i wanted to use this hack,,,,Paul Marsden - Simple hack to display members who have visited the forum today.Please can someone help me,i should have just left things alone
Looks like you need to unload the plugin that's creating the problem.
Click here (http://www.vbulletin.com/forum/showthread.php?t=148082&highlight=unplug)
Rickie3
10-26-2005, 09:52 AM
that is for 3.5 i'm using 3.0.3
that is for 3.5 i'm using 3.0.3
ok, ok .. sorry .. wasn't paying attention to details .. caffeine not kicked in yet :)
'Invalid SQL' is almost always due to modified code. The first thing I recommend is that you reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
If you have many hacks installed, you obviously can't upload all original files or you will lose all your hacks. I trust you made a backup of the original php file(s) that were edited to install the hack that is now causing the problem !?
Rickie3
10-26-2005, 10:43 AM
i made a back-up of all hacked files that are on the server a few weeks ago plus mysql database,but i'm at a loss as to what to do i may have to pay for someone to have a look for me
i made a back-up of all hacked files that are on the server a few weeks ago plus mysql database,but i'm at a loss as to what to do i may have to pay for someone to have a look for me
You want to PM me with a few more details and I'll take a look !?
Marco van Herwaarden
10-26-2005, 01:09 PM
To me it sounds like you have uninstalled the database modifications made by the hack, but are still using modified php-files. Undo the changes to your php-files done by this hack.
Rickie3
10-26-2005, 01:14 PM
To me it sounds like you have uninstalled the database modifications made by the hack, but are still using modified php-files. Undo the changes to your php-files done by this hack.
i dont know which php files it modified :ermm: thanx,i backed up all my files a few weeks ago would it be advisable ftp the whole lot back to the server???also in phpmyadmin this table is not showing _usersonline
Marco van Herwaarden
10-26-2005, 01:27 PM
Did you make that backup of your files prior to installing this hack? And did you make any changes afterwards?
Rickie3
10-26-2005, 01:33 PM
the hack was working fine so i made a back up a few weeks after installing it,this is the hack i tried to uninstall tonight and it killed everything,i uploaded to admincp,then hit uninstall,i'm not 100% if this is the one i had installed
cecdah
10-26-2005, 03:27 PM
If you can find the install.txt file for the hack, you can manually revert all the phpfiles you altered when installing, just reverse the process.
First I would concentrate on :
index.php
includes/sessions.php
Template: forumhome
Try to find: SELECT userid FROM sg_usersonline WHERE userid=1 in index.php and delete the phrase.
tnguy3n
10-26-2005, 04:05 PM
hi all i'm in a real pickle here,i had a online user hack installed as detailed:::::Hack Who was online last 24H by CXII & svaliotti adapted by Mtor
final version (vBulletin 3 rc2)
but when i hit the uninstaller above it killed my forum this is the error i get;;;;;
-----------------------------------------------------------------------
Database error in vBulletin 3.0.3:
Invalid SQL: SELECT userid FROM sg_usersonline WHERE userid=1
mysql error: Table 'satsfge_.sg_usersonline' doesn't exist
mysql error number: 1146
Date: Wednesday 26th of October 2005 06:04:51 AM
Script: http://www.sats-general.com/forum/index.php?
the reason i wanted to uninstall is i wanted to use this hack,,,,Paul Marsden - Simple hack to display members who have visited the forum today.Please can someone help me,i should have just left things alone
From the error warning, the script gets data from usersonline table which doesn't exists.
Try to open your /forumroot/index.php, search for usersonline and remove that query.
Paul M
10-26-2005, 04:06 PM
The error tells you which file is at fault ;
Script: http://www.sats-general.com/forum/index.php?
Remove the original hack code from this, or upload the proper non hacked version supplied by Jelsoft.
Rickie3
10-26-2005, 11:02 PM
i'm not having any luck,will upgrading to 3.0.5 fix things i understand i will lose all hacks
i would like to thank all that helped i finally sorted out what the prob was,it was my session.php file all good now
cheers
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.