vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help with .userpage' doesn't exist error - Stumped! (https://vborg.vbsupport.ru/showthread.php?t=181033)

Watson 05-30-2008 05:15 PM
Help with .userpage' doesn't exist error - Stumped!
 
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.

Code:
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 05-30-2008 05:53 PM
"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 05-30-2008 09:41 PM
I get the same error mate, it just comes up after I try and uninstall the plugin

peterska2 05-31-2008 12:25 AM
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.

Marco van Herwaarden 05-31-2008 08:21 AM
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 05-31-2008 11:48 AM
Quote:
Originally Posted by Kerry-Anne (Post 1536684)
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

Code:
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.

Quote:
Originally Posted by Marco van Herwaarden (Post 1536875)
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] ---------------

Quote:
Originally Posted by Kerry-Anne (Post 1536684)
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.

Code:
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 :(


All times are GMT. The time now is 08:51 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01010 seconds
  • Memory Usage 1,737KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete