Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 10-13-2003, 12:24 AM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default ERROR: 1030??? What's Wrong?

Warning: mysql_query(): Unable to save result set in /home/virtual/site21/fst/var/www/html/forum/admin/db_mysql.php on line 86


Database error in vBulletin 2.2.8:

Invalid SQL: SELECT count(*) AS posts FROM post WHERE dateline > '1066004683'
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of October 2003 08:29:12 PM
Script: http://www.XXXXXXXX.com/forum/forum/index.php?s=
Referer: http://www.XXXXXXXX.com/forum/forumd...?s=&forumid=18




ANY IDEA WHATS WRONG? I GET THIS WHEN I GO TO MY BOARD
Reply With Quote
  #2  
Old 10-13-2003, 06:13 PM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Now I'm getting a DIFFERENT Mysql error error when i go on my board.

It says

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
mysql error: Can't open file: 'post.MYD'. (errno: 145)

mysql error number: 1016

PLEASE CAN SOMEONE HELP?
Reply With Quote
  #3  
Old 10-13-2003, 06:39 PM
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Location: The Netherlands
Posts: 1,149
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run this query:

[sql]
REPAIR TABLE post
[/sql]
Reply With Quote
  #4  
Old 10-13-2003, 08:53 PM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

God Loves You LESANE!!!!!

Thanks so much bro.....what's up man...long time!
Reply With Quote
  #5  
Old 10-13-2003, 08:55 PM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^^^um lesane now when i go to post I get this message

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('color=0a3870','test','/color')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016
Reply With Quote
  #6  
Old 10-14-2003, 06:17 AM
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Location: The Netherlands
Posts: 1,149
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

"mysql error: Can't open file: 'word.MYD'. (errno: 145)" indicates that a table is corrupted/damaged.

You can keep fixing them manually by doing the query:

PHP Code:
REPAIR TABLE tablename 
So when it says word.MYD then the table word is corrupted/damaged so the query would be:

PHP Code:
REPAIR TABLE word 
But, i suggest you to install this hack from Filburt:
https://vborg.vbsupport.ru/showthrea...threadid=51560

It mostly fix those errors automaticilly so you don't have to do it manually and your forum keeps being online, but it's not good if you get these errors often. Notice your host about it.
Reply With Quote
  #7  
Old 10-15-2003, 01:16 AM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^^^Thanks Lesane.....worked perfect!
Reply With Quote
Reply

Thread Tools
Display Modes

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

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05452 seconds
  • Memory Usage 2,213KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete