Help with .userpage' doesn't exist error - Stumped!

[Watson]

Ello All,

I installed a userpage hack from here ages ago, and I have recently put my forums up from an old backup. I have overwritten everything, however I am now getting the following error.

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT * FROM userpage WHERE userid=1;

MySQL Error : Table 'bootleg_bootleg.userpage' doesn't exist
Error Number : 1146
Request Date : Friday, May 30th 2008 @ 03:48:48 PM
Error Date : Friday, May 30th 2008 @ 03:48:48 PM
Script : http://bootleg.org.uk/forums/index.php
Referrer : http://bootleg.org.uk/forums/admincp/index.php?do=head
IP Address : 81.xxxxxxxxx
Username : Watson
Classname : vb_database
MySQL Version : 4.1.22-standard

I have disabled the hack, and tried to uninstall it, but it doesn't work. I can get my forums to work if I disable all addons/hooks via the config.php code. However I don't want this.

I have had a look through the hack and I can find no easy way of getting rid of this. Even if I was able to install it again, and delete it. I just can't get it to work. The only solution I did find was someone posted about setting up more test forums, and running stuff on them and copying stuff over, which all looked a bit complicated.

Any help or guidance would be much appreciated. My forums have been offline for over a year, and I am eagre to get them back on. I did try over at VB.com, but obviously due to it being a hack, no joy. Which is understandable of course.

Cheers

Watson

[Opserty]

"Tried to uninstall it" - How did this "not" work exactly? Does it give you errors if you uninstall it?

Delete the Plugins via. the Plugin manager (AdminCP > Plugins & Products > Plugin Manager). Also make sure you have undone/overwritten any file edits you may have made in the past.

[Watson]

I get the same error mate, it just comes up after I try and uninstall the plugin

[peterska2]

Run this query then uninstall the product in the product manager.

Back up your database first as this is untested as I don't have the code handy and therefore don't know exactly what it is trying to do during the uninstall process

CREATE TABLE userpage (somefield varchar(10) NOT NULL default 'stuff');

This will just create a table with the right table name and stick a random field in it. As I imagine that the uninstall code will simply drop the table this should do the trick.

[Marco van Herwaarden]

If you have questions/problems with a modification or style, then please post in the thread (or support forum/board) about that modification/style. Best chance to receive a reply from either the author or another member using the same modification/style.

[Watson]

Run this query then uninstall the product in the product manager.

Back up your database first as this is untested as I don't have the code handy and therefore don't know exactly what it is trying to do during the uninstall process

CREATE TABLE userpage (somefield varchar(10) NOT NULL default 'stuff');

This will just create a table with the right table name and stick a random field in it. As I imagine that the uninstall code will simply drop the table this should do the trick.

Thanks for this, , however when I run the query, it asked me to supply the following

You have to choose at least one column to display

I had a wee look on google to see if I could find something to put in the query, but I wasn't sure what I was doing if I am honest.

If you have questions/problems with a modification or style, then please post in the thread (or support forum/board) about that modification/style. Best chance to receive a reply from either the author or another member using the same modification/style.

Yeah thanks Marco, but I had already searched the thread, and before my forums went down over a year ago, I seemed to have had the same problem, which I already posted in the forums. Never got any reply though. Seems quite a few people had same problem

--------------- Added 1212256833 at 1212256833 ---------------

Run this query then uninstall the product in the product manager.

Back up your database first as this is untested as I don't have the code handy and therefore don't know exactly what it is trying to do during the uninstall process

CREATE TABLE userpage (somefield varchar(10) NOT NULL default 'stuff');

This will just create a table with the right table name and stick a random field in it. As I imagine that the uninstall code will simply drop the table this should do the trick.

I actually managed to run this query, and I dont it for 2 other tables that were there, which looked as if it was working, however i now get this error.


Database error in vBulletin 3.7.1:

Invalid SQL:
ALTER TABLE usergroup DROP userpagepermissions;

MySQL Error : Can't DROP 'userpagepermissions'; check that column/key exists
Error Number : 1091
Request Date : Saturday, May 31st 2008 @ 05:56:04 PM
Error Date : Saturday, May 31st 2008 @ 05:56:04 PM
Script : http://www.bootleg.org.uk/forums/admincp/plugin.php?do=productkill
Referrer : http://www.bootleg.org.uk/forums/admincp/plugin.php?do=productdelete&productid=userpages&s=
IP Address : 81.151.85.204
Username : Watson
Classname : vb_database
MySQL Version : 4.1.22-standard


I think creating the tables was working, as I never got this message before, so it must be actually uninstalling them. However still a problem :(