vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   ERROR: 1030??? What's Wrong? (https://vborg.vbsupport.ru/showthread.php?t=57829)

ZiRu$ 10-13-2003 12:24 AM

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

ZiRu$ 10-13-2003 06:13 PM

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?

Lesane 10-13-2003 06:39 PM

Run this query:

[sql]
REPAIR TABLE post
[/sql]

ZiRu$ 10-13-2003 08:53 PM

God Loves You LESANE!!!!!

Thanks so much bro.....what's up man...long time!

ZiRu$ 10-13-2003 08:55 PM

^^^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

Lesane 10-14-2003 06:17 AM

"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.

ZiRu$ 10-15-2003 01:16 AM

^^^Thanks Lesane.....worked perfect!


All times are GMT. The time now is 10:46 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
  • Page Generation 0.01044 seconds
  • Memory Usage 1,724KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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