Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 05-30-2008, 05:15 PM
Watson's Avatar
Watson Watson is offline
 
Join Date: May 2004
Location: Scotland
Posts: 220
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 05-30-2008, 05:53 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

"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.
Reply With Quote
  #3  
Old 05-30-2008, 09:41 PM
Watson's Avatar
Watson Watson is offline
 
Join Date: May 2004
Location: Scotland
Posts: 220
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get the same error mate, it just comes up after I try and uninstall the plugin
Reply With Quote
  #4  
Old 05-31-2008, 12:25 AM
peterska2 peterska2 is offline
 
Join Date: Oct 2003
Location: Manchester, UK
Posts: 6,504
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 05-31-2008, 08:21 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 05-31-2008, 11:48 AM
Watson's Avatar
Watson Watson is offline
 
Join Date: May 2004
Location: Scotland
Posts: 220
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Kerry-Anne View Post
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 View Post
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 View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:25 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.03497 seconds
  • Memory Usage 2,207KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete