Previous Thread
Next Thread
Print Thread
Hop To
#170046 12/09/2006 10:13 PM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
I am receiving the following error message:

Quote
Script: /home/virtual/site5/fst/var/www/html/forums/scripts/dosearch.inc.php
Line#: 565
SQL Error: Can't open file: 'ubbt_POSTS.MYD'. (errno: 145)
SQL Error #: 1016
Query: SELECT t1.POST_ID FROM ubbt_POSTS as t1, ubbt_TOPICS as t2 WHERE t1.POST_IS_APPROVED = '1' AND t2.TOPIC_STATUS <> 'M' AND t2.FORUM_ID IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','102','103','104','105','106','107','108','109','110','111','112') AND t1.TOPIC_ID = t2.TOPIC_ID AND t1.POST_IS_TOPIC='1' AND t2.TOPIC_LAST_REPLY_TIME > '1165120270' ORDER BY t2.TOPIC_LAST_REPLY_TIME DESC LIMIT 250

I am still presently on 7.0.0

How can I fix this one?

Will repairing that table work?

Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
I am also receiving the following error when initially logging into the Control Panel:

Quote
SELECT COUNT(t1.POST_ID) FROM ubbt_POSTS as t1, ubbt_TOPICS as t2 WHERE t1.POST_IS_APPROVED = '0' and t1.TOPIC_ID = t2.TOPIC_ID

Can't open file: 'ubbt_POSTS.MYD'. (errno: 145)

Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
My server provider is presently repairing all of the tables, which he says will take a while to complete.

Will his doing this correct the error?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Yes, a repair should work. Unless you're getting it on multiple tables, it looks like only the ubbt_POSTS table needs repair.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
1 members (1 invisible), 939 guests, and 146 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)