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

[Watson]

Originally Posted by Kerry-Anne

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

[sql]CREATE TABLE userpage (somefield varchar(10) NOT NULL default 'stuff');[/sql]

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.

Originally Posted by 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.

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 [DATE]1212256833[/DATE] at [TIME]1212256833[/TIME] ---------------

Originally Posted by Kerry-Anne

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

[sql]CREATE TABLE userpage (somefield varchar(10) NOT NULL default 'stuff');[/sql]

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