vb.org Archive - What is this SQL Error??

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

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

- - What is this SQL Error?? (https://vborg.vbsupport.ru/showthread.php?t=51637)

kmfdm_kid2000

04-15-2003 05:39 AM

What is this SQL Error??

This happened all of the sudden, I wasn't even NEAR the new Database (FRESH one, since I didn't receive help fixing the old one from anyone but Filburt, sadly, I was not able to recover yet...)

Anyway, why am I and my users getting this:

Quote:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT threadid,lastpost
FROM thread
WHERE forumid = 224
AND visible=1
AND sticky=1

mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Tuesday 15th of April 2003 06:28:06 AM
Script: http://www.gqforums.com/forumdisplay.php?forumid=224
Referer:

Happens when trying to connect to almost ANY PHP file in the root, Forumdisplay, usercp.php, private.php, etc...I was working on COLORS and BUTTONS, not even on the server, so I KNOW it wasn't due to me doing something, so what gives??

Erwin

04-15-2003 05:53 AM

Upload repair.php and run it. You have a damaged thread table.

This has happened to filburt1 recently.

kmfdm_kid2000

04-15-2003 06:13 AM

Erwin, did I ever tell you you're the BEST?? I belive I did in an E-Mail long ago...That did the trick...Now, if I could only import the 154,000 posts from my other Database, I'd be set...:(

filburt1

04-15-2003 10:12 AM

Quote:

Today at 03:07 AM kmfdm_kid2000 said this in Post #3
Erwin, did I ever tell you you're the BEST?? I belive I did in an E-Mail long ago...That did the trick...Now, if I could only import the 154,000 posts from my other Database, I'd be set...:(

Also remember to back up daily.

Look in my profile for a hack that automatically repairs this type of database error.

All times are GMT. The time now is 05:14 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00982 seconds Memory Usage 1,718KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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: