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

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2013, 08:50 PM
Kiran-E-Sehar Kiran-E-Sehar is offline
 
Join Date: Jan 2011
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Required Tables

Hello,
I am so tired of fixing the issues my forum have,
so i backed up the database table wise and save them and then just deleted my forum's database and re upload the original files from upload folder and then installed new forum.
now i don't want to restore my entire database i want only necessery tables like users, posts, threads
so could anyone tell me which tables i must have to restore so my previous data will work fine, i don't want to restore old settings i will manage settings again now with new installation
Reply With Quote
  #2  
Old 11-24-2013, 10:06 PM
pityocamptes's Avatar
pityocamptes pityocamptes is offline
 
Join Date: Apr 2010
Posts: 595
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Whats wrong with the other tables?

--------------- Added [DATE]1385334461[/DATE] at [TIME]1385334461[/TIME] ---------------

I wonder if the IMPEX installer would just pull what is needed? I merged over from phpbb and used the impex importer and did not seem to have too many issues...
Reply With Quote
  #3  
Old 11-24-2013, 11:15 PM
Kiran-E-Sehar Kiran-E-Sehar is offline
 
Join Date: Jan 2011
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i really don't know what is the main issue,
i reinstalled forum more than 10 times tried to upgrade , disabled all of my plugins but still there were too many issues, like problem with login, problem with password recovery problem with redirect,
i checked the settings tried to change settings with many options but still i am getting many database errors
Reply With Quote
  #4  
Old 11-25-2013, 01:41 AM
tbworld tbworld is offline
 
Join Date: Oct 2008
Posts: 2,126
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My recommendations:

You need to rollback to the backup of your database before you started altering it. Hopefully, you have a backup of your entire system from that point in time.

Tables are interlinked in the database via indexes, IDs and fields. What you have now is a database, with no known state, and most likely is not repairable. Yes, you can alter tables, but you must know the interaction of that table before you alter it.

If your forum data is valuable and you need to put your board back online, then I recommend you hire someone. Unless your database was damaged on a key table, your original problems were probably minor.
Reply With Quote
2 благодарности(ей) от:
CAG CheechDogg, ozzy47
  #5  
Old 11-27-2013, 08:17 PM
Kiran-E-Sehar Kiran-E-Sehar is offline
 
Join Date: Jan 2011
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well i have done,
but after upgrading i have 1 issue my Remember me option is not working, if i dont use forum 900 seconds i must have to re login even i always selecting remember me
Reply With Quote
  #6  
Old 11-27-2013, 09:14 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Then your cookies are being set correctly.
Reply With Quote
  #7  
Old 11-29-2013, 09:45 PM
Kiran-E-Sehar Kiran-E-Sehar is offline
 
Join Date: Jan 2011
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Lynne i tried to fix cookies, but i could not find the solution,

actually there are 2 problems,
if i open my forum with www user can not login , when they login to forum and click on submit its redirects to home as logged off.

and if i use forum without www login works fine, but its cant keep users logged in, after inactive session ids get logged off :/
please help me to solve this
Reply With Quote
  #8  
Old 11-29-2013, 09:47 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Since you allow users to login to your site via both http://www.yoursite.com and just yoursite.com, then you MUST have your cookie domain (AdminCP > Settings > Options > Cookies and HTTP Header Options > Cookie Domain) set to ".yoursite.com" (no quotes, but note the period at the beginning) or your users will have problems.
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 02:20 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.04197 seconds
  • Memory Usage 2,225KB
  • Queries Executed 11 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (2)post_thanks_box_bit
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete