Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2005, 09:51 AM
VBUsers's Avatar
VBUsers VBUsers is offline
 
Join Date: Aug 2004
Posts: 830
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default sql error when i uninstalled last online hack

i tried to uninstall the last online from my forum and it didnt even start it gave me an error for sql

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT userid FROM smora_usersonline WHERE userid=1
mysql error: Table 'smoralo_forum.smora_usersonline' doesn't exist

mysql error number: 1146

Date: Saturday 19th of February 2005 06:47:44 AM
Script: http://www.lowandloud.com/phpbb2/index1.php?
Referer:

i went to phpmyadmin and looked for useronline and its not there. what can i do to get my board back up. it all went down cause of this. it was a simple uninstall. and this happened. i didnt save a back up casue i wasnt doing major hacks or anything. please help can i run the queries for that table and put it in manually and if so what do i use. ? thanks in advance for helping
Reply With Quote
  #2  
Old 02-19-2005, 10:05 AM
Tony G's Avatar
Tony G Tony G is offline
 
Join Date: Nov 2001
Location: Melbourne, Australia
Posts: 8,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you touch the database when you installed or uninstalled this mod?
Reply With Quote
  #3  
Old 02-19-2005, 10:26 AM
Deaths Deaths is offline
 
Join Date: Oct 2004
Location: Europe, Belgium
Posts: 679
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You must've ran the uninstall script, but didn't remove the file edits.
Quote:
I went to phpmyadmin and looked for useronline and its not there. what can i do to get my board back up. it all went down cause of this. it was a simple uninstall. and this happened. i didnt save a back up casue i wasnt doing major hacks or anything. please help can i run the queries for that table and put it in manually and if so what do i use. ? thanks in advance for helping
Ofcourse you can't find it, the error says it doesn't exist.
Reply With Quote
  #4  
Old 02-19-2005, 10:28 AM
VBUsers's Avatar
VBUsers VBUsers is offline
 
Join Date: Aug 2004
Posts: 830
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yeah thats what i did i tried to cut a corner. so i fixed it. i created a test forum installed the hack on it and ran the queries from the online table to the one that was missing and it fixed it. thanks for the help you guys
Reply With Quote
  #5  
Old 02-19-2005, 10:34 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by lowandloudinc
yeah thats what i did i tried to cut a corner. so i fixed it. i created a test forum installed the hack on it and ran the queries from the online table to the one that was missing and it fixed it. thanks for the help you guys
Now it sounds like you still have it, if you want the hack removed you need to remove the file edits at the very least.
Reply With Quote
  #6  
Old 02-19-2005, 10:37 AM
VBUsers's Avatar
VBUsers VBUsers is offline
 
Join Date: Aug 2004
Posts: 830
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well i didnt want to uninstall it i wanted to install it to a new template i have. but the only way to do it is to go thru the install casue of the the way its set up theres no text doc to read from its all in the app. and i dont have the edits for the template. i know the php files have been edited but the template needs to be edited. if you have it can you post it

Hack Who was online last X Hours par Mtor

d'apr?s le Hack vb2 de CXII et Svaliotti

Test? sur vb 3.0.0

Copyright www.vbulletindev.net 2004


is the maker. thanks
Reply With Quote
Reply


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 06:51 PM.


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.03929 seconds
  • Memory Usage 2,209KB
  • 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
  • (2)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_postinfo_query
  • fetch_postinfo
  • 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