Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Jun 2010, 02:40
MadK's Avatar
MadK MadK is offline
 
Join Date: Feb 2008
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

And although my database uses a prefix, the query still ran somehow.

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;


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

My forums now point to a non-existent table and I cannot come up with a solution.

I was hoping somebody here experienced enough in MySQL would be able to help me.

Appreciate the help and much success,
Thanks a lot!
Reply With Quote
  #2  
Old 12 Jun 2010, 18:42
robert garrett robert garrett is offline
 
Join Date: Mar 2010
restore your backup database. You did back it up first didnt you?
Reply With Quote
  #3  
Old 14 Jun 2010, 02:44
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Of course he has backups. Everyone that runs a forum backs up their db daily.
Reply With Quote
  #4  
Old 14 Jun 2010, 04:51
Rafa-el's Avatar
Rafa-el Rafa-el is offline
 
Join Date: Feb 2010
Location: Nicaragua
Real name: Rafael Benard
Originally Posted by Videx View Post
Of course he has backups. Everyone that runs a forum backs up their db daily.
Are you sure? I bet that most of the forum owners never make backups before do something on it.
Reply With Quote
  #5  
Old 14 Jun 2010, 05:24
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #6  
Old 16 Jun 2010, 05:36
Rafa-el's Avatar
Rafa-el Rafa-el is offline
 
Join Date: Feb 2010
Location: Nicaragua
Real name: Rafael Benard
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Just simple tips that can help you.
Reply With Quote
  #7  
Old 17 Jun 2010, 02:03
MadK's Avatar
MadK MadK is offline
 
Join Date: Feb 2008
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!
Reply With Quote
  #8  
Old 17 Jun 2010, 02:39
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Originally Posted by MadK View Post
I had it fixed by my webhost who also said that it was a mistake on their part.
Glad to hear you recovered it.

Just so we can say "nyah nyah" to Marco, can we be assured that you are making daily db backups?
Reply With Quote
  #9  
Old 18 Jun 2010, 21:11
MadK's Avatar
MadK MadK is offline
 
Join Date: Feb 2008
Originally Posted by Videx View Post
Glad to hear you recovered it.

Just so we can say "nyah nyah" to Marco, can we be assured that you are making daily db backups?
Concerning the last few posts, I'll be honest with you! Before last year, I did not have the habit of making daily backups or even backups before I would modify the system. Ever since I lost my database because of you could say, ''reckless administration'' I make daily backups!

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
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 04:34.

Layout Options | Width: Wide Color: