PDA

View Full Version : Huge problem after database error


kstone
13 Jul 2008, 01:19
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!

Dismounted
13 Jul 2008, 07:17
Disable any modifications running.

kstone
13 Jul 2008, 08:18
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.

Opserty
13 Jul 2008, 08:58
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)

Marco van Herwaarden
13 Jul 2008, 09:39
What is the database error you are getting.

kstone
13 Jul 2008, 13:45
It all started after my MySQL06 vent down, according to my host. After that we got the same database error.

https://www.vbulletin.org/forum/external/2008/07/1.jpeg

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.

Dismounted
13 Jul 2008, 13:57
Are you getting any errors now? If you are, can you point us to the page that has it?

kstone
13 Jul 2008, 14:08
The issues still accur after i tried to create a parent style

--------------- Added 1215959301 at 1215959301 ---------------

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?

Paul M
13 Jul 2008, 15:03
It all started after my MySQL06 vent down, according to my host. After that we got the same database error.

https://www.vbulletin.org/forum/external/2008/07/1.jpeg

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.

kstone
13 Jul 2008, 21:49
This is the database error i get :(

Database error in vBulletin 3.6.8:

Invalid SQL:
DELETE FROM vbulletin2_post WHERE postid IN (19232,18691,18673,18685,19249,19250,18683,19241,19267,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.php?do=dodeletethreads&threadids=1548
Referrer : http://www.fotballprat.net/inlinemod.php?forumid=61
IP Address : 84.49.166.73
Username : Mourinho
Classname : vB_Database

Dismounted
14 Jul 2008, 06:30
Have a look at the manual's page (http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway).

kstone
14 Jul 2008, 08:17
Could this problem be solved by deleting all the posts in my forum? I that case, how can i do that?

--------------- Added 1216034378 at 1216034378 ---------------

I got this error just now:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT template
FROM vbulletin2_template
WHERE templateid = 1672;

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Monday, July 14th 2008 @ 01:07:05 PM
Script : http://www.fotballprat.net/newthread.php?do=postthread&f=64
Referrer : http://www.fotballprat.net/newthread.php?do=newthread&f=64
IP Address : 89.8.144.13
Username : Mourinho
Classname : vB_Database

--------------- Added 1216038338 at 1216038338 ---------------

Can someone help?

rowlandc
14 Jul 2008, 12:33
Could this problem be solved by deleting all the posts in my forum? I that case, how can i do that?

--------------- Added 1216034378 at 1216034378 ---------------

I got this error just now:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT template
FROM vbulletin2_template
WHERE templateid = 1672;

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Monday, July 14th 2008 @ 01:07:05 PM
Script : http://www.fotballprat.net/newthread.php?do=postthread&f=64
Referrer : http://www.fotballprat.net/newthread.php?do=newthread&f=64
IP Address : 89.8.144.13
Username : Mourinho
Classname : vB_Database

--------------- Added 1216038338 at 1216038338 ---------------

Can someone help?


If your going to delete your posts why don't you just do a fresh install?

That would solve the issue.

Marco van Herwaarden
14 Jul 2008, 12:41
See the manual: Lost connection to MySQL server during query (http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway)

PS Deleting posts or start with a fresh forum will most likely NOT solve this problem.

kstone
14 Jul 2008, 13:01
Hmm.. i see.... I don't know much about mysql, and I find it difficult to fix too :(

Got a new databaserror now:
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT post.postid, post.visible, post.userid
FROM vbulletin2_post AS post

WHERE post.threadid = 1803
AND post.visible IN (1
,2
,0
)

ORDER BY post.dateline;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Monday, July 14th 2008 @ 02:59:37 PM
Script : http://www.fotballprat.net/showthread.php?p=24243
Referrer : http://www.fotballprat.net/newthread.php?do=newthread&f=66
IP Address : 89.8.144.13
Username : Mourinho
Classname : vB_Database

--------------- Added 1216040670 at 1216040670 ---------------

Is this something my webhost can fix for me?

Dismounted
14 Jul 2008, 13:08
Again, see the page Marco has linked to. You should also ask your host as well, say that you are getting "Lost connection to MySQL server during query" errors.