vb.org Archive - Ran an SQL query, killed the forum

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Ran an SQL query, killed the forum (https://vborg.vbsupport.ru/showthread.php?t=244439)

MadK	06-12-2010 12:40 AM

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:


		
			
ALTER TABLE post DROP INDEX userid, ADD INDEX userid (userid, parentid)

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;

Code:

Database error in vBulletin 4.0.3:



Invalid SQL:

SELECT userid from post where threadid='222'  AND userid=12;



MySQL Error   : Table 'forums.post' doesn't exist

Error Number  : 1146

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!

robert garrett

06-12-2010 04:42 PM

restore your backup database. You did back it up first didnt you?

Videx

06-14-2010 12:44 AM

Of course he has backups. Everyone that runs a forum backs up their db daily.

Rafa-el

06-14-2010 02:51 AM

Quote:

Originally Posted by Videx (Post 2053197)

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.

Marco van Herwaarden

06-14-2010 03:24 AM

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?

Rafa-el

06-16-2010 03:36 AM

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);

Just simple tips that can help you.

MadK	06-17-2010 12:03 AM

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

Videx

06-17-2010 12:39 AM

Quote:

Originally Posted by MadK (Post 2054757)

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?

MadK	06-18-2010 07:11 PM

Quote:

Originally Posted by Videx (Post 2054782)

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! :D 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

All times are GMT. The time now is 10:29 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01132 seconds Memory Usage 1,733KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: