PDA

View Full Version : help need urgently ive killed my forum


Rickie3
26 Oct 2005, 10:16
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

TTG
26 Oct 2005, 10:33
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
26 Oct 2005, 10:52
that is for 3.5 i'm using 3.0.3

TTG
26 Oct 2005, 11:09
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
26 Oct 2005, 11:43
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

TTG
26 Oct 2005, 12:14
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
26 Oct 2005, 14:09
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
26 Oct 2005, 14:14
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
26 Oct 2005, 14:27
Did you make that backup of your files prior to installing this hack? And did you make any changes afterwards?

Rickie3
26 Oct 2005, 14:33
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
26 Oct 2005, 16:27
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
26 Oct 2005, 17:05
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
26 Oct 2005, 17:06
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
27 Oct 2005, 00:02
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