Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2005, 09:16 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default help need urgently ive killed my forum

hi all i'm in a real pickle here,i had a online user hack installed as detailed:::::Hack Who was online last 24H by CXII & svaliotti adapted by Mtor

final version (vBulletin 3 rc2)

but when i hit the uninstaller above it killed my forum this is the error i get;;;;;
-----------------------------------------------------------------------
Database error in vBulletin 3.0.3:

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

mysql error number: 1146

Date: Wednesday 26th of October 2005 06:04:51 AM
Script: http://www.sats-general.com/forum/index.php?

the reason i wanted to uninstall is i wanted to use this hack,,,,Paul Marsden - Simple hack to display members who have visited the forum today.Please can someone help me,i should have just left things alone
Reply With Quote
  #2  
Old 10-26-2005, 09:33 AM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like you need to unload the plugin that's creating the problem.

Click here
Reply With Quote
  #3  
Old 10-26-2005, 09:52 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

that is for 3.5 i'm using 3.0.3
Reply With Quote
  #4  
Old 10-26-2005, 10:09 AM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Rickie3
that is for 3.5 i'm using 3.0.3
ok, ok .. sorry .. wasn't paying attention to details .. caffeine not kicked in yet

'Invalid SQL' is almost always due to modified code. The first thing I recommend is that you reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

If you have many hacks installed, you obviously can't upload all original files or you will lose all your hacks. I trust you made a backup of the original php file(s) that were edited to install the hack that is now causing the problem !?
Reply With Quote
  #5  
Old 10-26-2005, 10:43 AM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i made a back-up of all hacked files that are on the server a few weeks ago plus mysql database,but i'm at a loss as to what to do i may have to pay for someone to have a look for me
Reply With Quote
  #6  
Old 10-26-2005, 11:14 AM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Rickie3
i made a back-up of all hacked files that are on the server a few weeks ago plus mysql database,but i'm at a loss as to what to do i may have to pay for someone to have a look for me
You want to PM me with a few more details and I'll take a look !?
Reply With Quote
  #7  
Old 10-26-2005, 01:09 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To me it sounds like you have uninstalled the database modifications made by the hack, but are still using modified php-files. Undo the changes to your php-files done by this hack.
Reply With Quote
  #8  
Old 10-26-2005, 01:14 PM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarcoH64
To me it sounds like you have uninstalled the database modifications made by the hack, but are still using modified php-files. Undo the changes to your php-files done by this hack.
i dont know which php files it modified :ermm: thanx,i backed up all my files a few weeks ago would it be advisable ftp the whole lot back to the server???also in phpmyadmin this table is not showing _usersonline
Reply With Quote
  #9  
Old 10-26-2005, 01:27 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you make that backup of your files prior to installing this hack? And did you make any changes afterwards?
Reply With Quote
  #10  
Old 10-26-2005, 01:33 PM
Rickie3's Avatar
Rickie3 Rickie3 is offline
 
Join Date: Nov 2004
Location: Australia/Tasmania
Posts: 770
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the hack was working fine so i made a back up a few weeks after installing it,this is the hack i tried to uninstall tonight and it killed everything,i uploaded to admincp,then hit uninstall,i'm not 100% if this is the one i had installed
Attached Files
File Type: php whowasonline24h_rc2.php (9.5 KB, 6 views)
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 05:02 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04798 seconds
  • Memory Usage 2,269KB
  • Queries Executed 14 (?)
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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)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
  • postbit_attachment
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete