![]() |
Ran an SQL query, killed the forum
Hey there,
Before I start I would like to say that I used digitalpoint's vB Optimizing guide right here and I am aware that it clearly states that anything can break at any moment when applying these changes, but it was actually a mistake on my part. The thing is that I ran the following query: PHP Code:
So I ran it a second time with the appropriate prefix, and it worked... until a few hours ago. I am now getting e-mails from the vBulletin Database Error System similar to this; Code:
Database error in vBulletin 4.0.3: I was hoping somebody here experienced enough in MySQL would be able to help me. Appreciate the help and much success, Thanks a lot! |
restore your backup database. You did back it up first didnt you?
|
Of course he has backups. Everyone that runs a forum backs up their db daily.
|
Quote:
|
First check, with a tool like phpMyAdmin if the table "post" and/or "prefix_post" dop exist in your database.
Next step is to check your ./includes/config.php, does it still have the prefix set correctly? If that is all correct, did you recently install a new modification or such that might not work with prefixes? @post #3 & #4 How are you helping with such useless posts? |
I think that you have may have the post_table since that query can't delete it, just check the DB tables and look if is there. If you haven't phpMyAdmin access you can grab a tool for handle your DB externally (a php script).
Now I don't think that this is caused by a mod but can be a reason so, remember wich mods do you have installed, also add this line in the config.php to disable all the hooks: Code:
define('DISABLE_HOOKS', 1); |
Hey there guys, thanks for the help but since it was an Internal Server Error (which I forgot to mention at the very beginning of this post), I had it fixed by my webhost who also said that it was a mistake on their part. :)
However, for some reason, I still cannot explain the origin of this MySQL error because the post table never existed, it was actually forums_post but oh well, if it works, it works! :D |
Quote:
Just so we can say "nyah nyah" to Marco, can we be assured that you are making daily db backups? |
Quote:
Had to learn the hard way, like many others, I am pretty sure! :) Thanks for the help everybody, I truly appreciate it, I wish you all true success in all of your projects, MadK |
All times are GMT. The time now is 10:29 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|