help need urgently ive killed my forum
 

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

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 !?

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 !?

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

Did you make that backup of your files prior to installing this hack? And did you make any changes afterwards?

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

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.

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.

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.

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