Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2008, 12:19 AM
kstone kstone is offline
 
Join Date: Jan 2008
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Huge problem after database error

I got a problem on my forum. My host got som big problems on the server that runs my forum. They had to move it to the last backup of my forum. When i tired to login as a admin, it diden't work. Now it does, but i still got a huge problem. When i try to make a new topic in a forum, it won't do that. The new topic turns into a reply the topic last posted.

I tried to delete all my forums and making them over again. But the same thing keeps happening. When i deleted all my forums shoulden't all my members got 0 posts? Well, they don't. They get the same number they got earlier, before the database error.

The database error ruined most of my forum. They had to take it back til the last backup, which was in earlie may. That meens i lost to months of posts. Any way to get that back i don't think, very sad

I need help with the questions above. please!
Reply With Quote
  #2  
Old 07-13-2008, 06:17 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable any modifications running.
Reply With Quote
  #3  
Old 07-13-2008, 07:18 AM
kstone kstone is offline
 
Join Date: Jan 2008
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have done that now, but i got the same problem making a topic. It just turns in to a reply on an old topic.
Reply With Quote
  #4  
Old 07-13-2008, 07:58 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Create a New Style with Parent Style. Does your issue persist?

(Note: If you manually delete posts/threads you have to run the update the post/thread counters to reset the correct count for users)
Reply With Quote
  #5  
Old 07-13-2008, 08:39 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is the database error you are getting.
Reply With Quote
  #6  
Old 07-13-2008, 12:45 PM
kstone kstone is offline
 
Join Date: Jan 2008
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It all started after my MySQL06 vent down, according to my host. After that we got the same database error.



The error just says this:
Database error
The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.fotballprat.net home page, then try to open another page.
* Click the Back button to try another link.

The www.fotballprat.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Reply With Quote
  #7  
Old 07-13-2008, 12:57 PM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you getting any errors now? If you are, can you point us to the page that has it?
Reply With Quote
  #8  
Old 07-13-2008, 01:08 PM
kstone kstone is offline
 
Join Date: Jan 2008
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The issues still accur after i tried to create a parent style

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

Quote:
Originally Posted by Dismounted View Post
Are you getting any errors now? If you are, can you point us to the page that has it?
I get the database error a lot. I just have to reload page, but still a pain in the ass. The errors i get is the same. I try to create new topics, but they just turn into replys to old topics. In my forum board i only see one empty forum, but still new topic turns into replys to old topics. Is it possible to fix this by deleting all posts in my forum? How can i do this?
Reply With Quote
  #9  
Old 07-13-2008, 02:03 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kstone View Post
It all started after my MySQL06 vent down, according to my host. After that we got the same database error.



The error just says this:
Database error
The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.fotballprat.net home page, then try to open another page.
* Click the Back button to try another link.

The www.fotballprat.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Right click on the page, and view the source, you will find the real error embedded in the page.
Reply With Quote
  #10  
Old 07-13-2008, 08:49 PM
kstone kstone is offline
 
Join Date: Jan 2008
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is the database error i get

Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:
DELETE FROM vbulletin2_post WHERE postid IN (19232,18691,18673,18685,19249,19250,18683,19241,1 9267,23983,23984,0);

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Sunday, July 13th 2008 @ 11:47:55 PM
Script : http://www.fotballprat.net/inlinemod...threadids=1548
Referrer : http://www.fotballprat.net/inlinemod.php?forumid=61
IP Address : 84.49.166.73
Username : Mourinho
Classname : vB_Database
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 01:01 PM.


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.04217 seconds
  • Memory Usage 2,256KB
  • 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
  • (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
  • (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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete