Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 02-03-2009, 09:31 AM
PinkLiquorice PinkLiquorice is offline
 
Join Date: Jun 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Posts/Boards Missing after mistake by Hosting

Hi,

We had a problem with our hosting in which our site was down for around a day and a half, anyway when we got it back some boards were missing including the messages, I asked but they said that we could not get them back even from a back up so we started the boards again, anyway I was searching for something today and some of the missing messages appeared, however they dont seem to be in a forum anywhere? I have put a screen print below, it says when I click on them I do not have permission to view them, and I cannot move them anyway as I tried. Anyone know how I can get them back as some of them were very important to the members of our site?



To be honest the hosting was shocking and as it was their fault in the first place I think their customer service was terrible so they didnt really help at all.

Thank you
Reply With Quote
  #2  
Old 02-03-2009, 09:36 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What you are describing sounds like your host restored a partial backup. Your post table doesn't match your forum table (ie. posts/threads exist in forums that have no entry in the forum table).

Real solution would be to restore a complete backup.

If this is not possible, you could try to recreate forums, and update the forumid in the posts/threads with the new id. But i would test this first on a test board.
Reply With Quote
  #3  
Old 02-03-2009, 09:51 AM
PinkLiquorice PinkLiquorice is offline
 
Join Date: Jun 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<font size="2">I asked about a full restore and they said

Your site is using InnoDB tables, the backup servers do not support InnoDB tables, so the restore would not work unfortunately.

So I dont know whether that means that if they mess up again we would lose everything and I need to change hostings as well?

Anyway how would I update the forum ID?

Thank you your help is most appreciated</font>
Reply With Quote
  #4  
Old 02-03-2009, 09:54 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by sw1 View Post
[SIZE="2"]Your site is using InnoDB tables, the backup servers do not support InnoDB tables, so the restore would not work unfortunately.
vBulletin does not use InnoDB. It uses MyISAM and HEAP.
Reply With Quote
  #5  
Old 02-03-2009, 09:56 AM
PinkLiquorice PinkLiquorice is offline
 
Join Date: Jun 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
vBulletin does not use InnoDB. It uses MyISAM and HEAP.

Oh well I dont know what their problem is then! They havent been very helpful at all and they are well known x
Reply With Quote
  #6  
Old 02-03-2009, 10:00 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Depending on your settings vB can also use (partially) InnoDB.

But seriously if your host tells you they can not backup your data, then the time to go search for a new host has already passed some time ago.
Reply With Quote
  #7  
Old 02-03-2009, 10:01 AM
PinkLiquorice PinkLiquorice is offline
 
Join Date: Jun 2007
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I havent changed too long ago and went off the recommendations of people on here they are really well known and Im quite annoyed that they are unable or seem unwilling to help, but will be looking for another again. Thanks very much.

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

Quote:
Originally Posted by sw1 View Post
Anyway how would I update the forum ID?

Thank you your help is most appreciated
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 10:42 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.05015 seconds
  • Memory Usage 2,213KB
  • 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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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