Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 04-08-2011, 08:56 AM
Katebekett Katebekett is offline
 
Join Date: Mar 2011
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problems after crash

Trying to resolve an issue. The person who originally setup the forum (and had access to the Host's cPanel) left because of creative differences. But not before he ran a script to make everyone - all 554 members, administrators (user group 6). We shut the board down in short order.

We have a reliable backup that we restored successfully after a re-organization of the board on the 4th of April 2011. but the backup does weird things to Vbulletin now.

Steps Followed:
  1. Created New Database
  2. Added new user
  3. added user to database
  4. installed vbulletin 4.1.2
  5. restored the database backup via cPanel > MyPHPAdmin > import database
  6. database gets populated, users, styles and all other associated stuff comes along

The input area worked fine before the database restore.

Here's the problem: login input area (id/password) does not work as normal, after the database restore. the "user name" text does not disappear when typing the member name, and the password is shown in clear TEXT, it even shows up as hint, instead of the usual dots.

where is it going wrong, and how do I fix it? . as this is a fresh install, I expected no corruption issues.
Attached Images
File Type: png problem.png (5.9 KB, 0 views)
Reply With Quote
  #2  
Old 04-08-2011, 03:36 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't understand why you have both step 2 and 3. 2 should have added the user to the database.

Also, after importing a database, you may need to run the upgrade.php script.

Create a new style with no parent:
  • Styles & Templates > Style Manager > Add New Style
  • Parent Style: No Parent Style
  • Title: Default vBulletin
  • Allow User Selection: Yes
  • Save
Then browse the site using that totally default vbulletin style - do you still have the same problem?

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

PHP Code:
define('DISABLE_HOOKS'true); 
Reply With Quote
  #3  
Old 04-08-2011, 09:03 PM
Katebekett Katebekett is offline
 
Join Date: Mar 2011
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the advice Lynne,

Since I had no idea How MySql works, I went about it the long way around. I started with a clean test install in another directory. Then I started restoring 1 table at a time to the damaged directory. I found that when I restored the "datastore" table, it fixed the problem but also got rid of all the threads and posts. So I re-restored the damaged table, and the problem + Threads came back. So I expanded the Datastore table and found that If I just restored the "options" part of the table from the clean install, that worked too.

Then I also stumbled across that, if I went to my clean install, and did a forum settings xml backup, I could open this in a text editor, and fix the forum URL to point to the damaged forum, I can import this XML back via the damaged forum's ACP, and fix the issue. Then go back in and re-apply any customizations and VBH Tabs.

I know this sounds really low-tech, but I am a real n00b, when it comes to mysql. It's difficult to concentrate when there's over 500 members yelling blue murder, to have the forum back (and it's only a fan site )

I sincerely appreciate your assistance. Thanks!
Reply With Quote
  #4  
Old 04-08-2011, 10:14 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The datastore table is actually created from other information in your database. If you make a change to your options, then the options row in database is changed (as you saw). Same if you change something in the Forum Manager or Usergroup Manager or Plugin Manager, etc. It's kinda a cache for a bunch of often used information.
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 01:05 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.03756 seconds
  • Memory Usage 2,205KB
  • 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
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (1)postbit_attachment
  • (4)postbit_onlinestatus
  • (4)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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete