Wha?

[Cedric.C]

I am having some more mySQL problems.I was deleting a useless plugin (it was userpages,and I was not using it).Then my forum got into an ERROR.Now I keep getting these E-mails saying:
Invalid SQL:
SELECT * FROM userpage WHERE userid=4;

MySQL Error : Table 'toonstin_tonstinvb.userpage' doesn't exist
Error Number : 1146
Date : Sunday, February 19th 2006 @ 03:59:41 PM
Script : http://www.toonstin.com/vb/index.php
Referrer :
IP Address : 68.161.167.92
Username : mpd
Classname : vb_database
----------------------------------
Can someone please help!!
PS:my forum link is http://www.toonstin.com/vb/

[Marco van Herwaarden]

Well then you didn't completly remove the Modification, there is some code left that still try to query the userpage table.

Make sure it is completly removed, or ask the author of the Modification for help.

[Cedric.C]

Well then you didn't completly remove the Modification, there is some code left that still try to query the userpage table.

Make sure it is completly removed, or ask the author of the Modification for help.

So I have to delete the XML product in the CP?

[Marco van Herwaarden]

Completly remove would mean:
- Undo any changes to the database
- Undo any Template & Phrase changes
- Undo Any file modifications
- Remove any uploaded files
- ..and whatever this hack installed.

What you must do to remove, i can not answer, you will need to ask the author of the hack.

[Cedric.C]

Ok,I removed all the userpage stuff,it fixed it a little now all's you can see on the forum home is:
There seems to have been a problem with the Toonstin Forums-Toontown online fansite database.
Please try again by clicking the Refresh button in your web browser.
An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
We apologise for any inconvenience

So that did help
But I still ned a bit more help..

[Marco van Herwaarden]

You are getting the following error:

<!--
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT * FROM userpage WHERE userid=0;
MySQL Error  : Table 'toonstin_tonstinvb.userpage' doesn't exist
Error Number : 1146
Date         : Monday, February 20th 2006 @ 04:06:59 AM
Script       : http://www.toonstin.com/vb/forumdisplay.php
Referrer     : http://www.vbulletin.com/forum/showt...63#post1078063
IP Address   : 83.84.56.163
Username     : Unregistered
Classname    : vb_database
-->

Like i said before, contact the author of this userpage modification and ask for help uninstalling.

Here at vbulletin.com we can not support Modifications or Modificted boards.

[Cedric.C]

You are getting the following error:

<!--
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT * FROM userpage WHERE userid=0;
MySQL Error  : Table 'toonstin_tonstinvb.userpage' doesn't exist
Error Number : 1146
Date         : Monday, February 20th 2006 @ 04:06:59 AM
Script       : http://www.toonstin.com/vb/forumdisplay.php
Referrer     : http://www.vbulletin.com/forum/showt...63#post1078063
IP Address   : 83.84.56.163
Username     : Unregistered
Classname    : vb_database
-->

Like i said before, contact the author of this userpage modification and ask for help uninstalling.

Here at vbulletin.com we can not support Modifications or Modificted boards.

After I uninstalled the XML it went away.Still the users cannot get on.

[Marco van Herwaarden]

If you go to http://www.toonstin.com/vb/forumdisplay.php you still get that same message, so removing the XML did not fix it.

Like i said before, contact the author of this userpage modification and ask for help uninstalling.

Here at vbulletin.com we can not support Modifications or Modificated boards.

[bradg]

I think the word you're looking for is "Modified", Marco.

[Marco van Herwaarden]

I think the word you're looking for is "Modified", Marco.

Yeah sure, go make fun of my speling erors in englis.

(Would like to see you write Dutch all day )

[bradg]

Yeah sure, go make fun of my speling erors in englis.

(Would like to see you write Dutch all day )

haha! If only I were smart enought to speak two languages!!