Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
5 registered members (GliderCENTRAL, Gizmo, isaac, RyuLion, Ruben), 75 guests, and 215 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Steve M
Steve M
MO, USA
Posts: 71
Joined: July 2011
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
SteveS 8
isaac 7
Morgan 5
Ruben 4
jorb 4
JPG 1
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) #173218
01/12/07 01:31 PM
01/12/07 01:31 PM
L
LYK  Offline OP
stranger
Joined: Jan 2007
Posts: 5
*SQL Error:* Can't open file: 'ubbt_topics.MYI'. (errno: 145)
*SQL Error #:* 1016
*Query:* select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT, t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES, t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID, t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL from ubbt_TOPICS as t1 left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID where t1.FORUM_ID = 35 and t1.TOPIC_IS_STICKY = '0' ORDER BY t1.TOPIC_LAST_REPLY_TIME DESC LIMIT 30 /


Anyone know why? Our forum is running in a dedicated Windows server

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173229
01/12/07 03:06 PM
01/12/07 03:06 PM
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
It looks like one or more of your index files are corrupted. If you have access to SSH or Remote Desktop then you should run some repair checks on your database. If you don't have direct access then your Control Panel (from your host provider) should have a method to run checks on it as well.


.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173230
01/12/07 03:07 PM
01/12/07 03:07 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
It appears you have a corrupt ubbt_TOPICS table. You can try running the following SQL command to repair it:

REPAIR TABLE ubbt_TOPICS

You should close your forum before running the command to prevent further corruption.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: Rick] #173236
01/12/07 04:18 PM
01/12/07 04:18 PM
L
LYK  Offline OP
stranger
Joined: Jan 2007
Posts: 5
Yes, we did the MySQL fixes everyday. Anyone know why it always happen to our forum? What causing this problem?

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173239
01/12/07 04:36 PM
01/12/07 04:36 PM
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
What version of MySQL and what version of UBBT ?

Is this a Windows host account or a VSP or dedicated ?

It could also be hardware related with cache write issues. Modern software/hardware should rarely see these types of errors on MySQL.

.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: ntdoc] #173249
01/12/07 06:41 PM
01/12/07 06:41 PM
L
LYK  Offline OP
stranger
Joined: Jan 2007
Posts: 5
PHP Version 4.4.4
It is the latest UBB version.
The forum is running in our Windows dedicated server.

Please suggest as we can not afford so many MySQL errors each day.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173252
01/12/07 06:50 PM
01/12/07 06:50 PM
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
Hi Lyk don't mean to be a pain but "latest" is not a version and many times when someone says it's "latest" they are wrong.

If you hover your mouse over the "Powered by UBB.threads™" at the bottom of the board it will tell you the version, here it is 7.1b4

You can also go into your control panel and check the version.


If you're running 7.02 then I would have to bet that something is going on hardware wise or you have an extremely busy board.

If you have ROOT access via SSH or Remote Desktop then check in Event Viewer under Administrator Tools and it should show if there are errors in the hardware.

You can run task manager to get a general idea of how much resources are being used. If CPU/RAM is being exhausted then you may have to run some other tests to determine why.

I think there was an older version of UBBT that Rick fixed a caching issue that "might" cause this but need more details to determine.

Thanks.

.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: ntdoc] #173256
01/12/07 06:56 PM
01/12/07 06:56 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Table corruption basically happens when MySQL tries to write to disk and it gets messed up in the process. Common causes of this are MySQL crashing in the middle of a write. Normally this is more apt to happen on very busy tables. You'll see this happened quite often for the Online table before being converted to a memory table. The topics table does see a fair amount of writes, but nothing extensive.

Slow hard drives can also make the tables more prone to corruption. Basically it's just a corrupted file. Though MySQL is a database, it still stores everything in files, and if the file can't be written cleanly you'll get the corruption.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: Rick] #173258
01/12/07 06:57 PM
01/12/07 06:57 PM
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
Yes, and Windows will show that write error in the event viewer (at least it should)

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: Rick] #173260
01/12/07 07:09 PM
01/12/07 07:09 PM
L
LYK  Offline OP
stranger
Joined: Jan 2007
Posts: 5
Sorry. The board is running verion 7.0.1.

Event Viewer is not showing hardware errors. The CPU/RAM is not being exhausted less than 20%CPU used and 600MB RAM free out of 1GB total.

The board is quite busy but should not be overly taxing on the server. It is a Windows 2003 server as the platform OS.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173261
01/12/07 07:11 PM
01/12/07 07:11 PM
L
LYK  Offline OP
stranger
Joined: Jan 2007
Posts: 5
Thanks for the help so far. We are looking at this from a slow HDD perspective. We are running an IDE hot swap RAID 1 chassis on the server and it may be the bottleneck.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173262
01/12/07 07:12 PM
01/12/07 07:12 PM
I
Ian  Offline

Carpal Tunnel
Joined: Jun 2006
Posts: 4,374
Essex, UK
ok - keep us updated & if you need further help just ask smile

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: LYK] #173267
01/12/07 07:51 PM
01/12/07 07:51 PM
ntdoc  Offline
Carpal Tunnel
Joined: Nov 2006
Posts: 3,390
You could also try running this:

chkdsk c: /f /r /v
chkdsk d: /f /r /v

Use your drive letters and it will run a full check on each volume, then once it's back up you can also run a Defrag of the system.

Clean out your temp files. Actually go in and make sure PHP isn't creating a ton of them. Mine was doing that at one time too because I had a setting wrong in the php.ini file. It should create and then auto delete them on it's own.
I had over 65,000 temp files from that issue and it did slow the box down and cause errors.

.

Re: Always received this error from time to time: Can't open file: 'ubbt_topics.MYI'. (errno: 145) [Re: ntdoc] #173318
01/12/07 11:51 PM
01/12/07 11:51 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,012
Portland, OR; USA
Originally Posted by ntdoc
I had over 65,000 temp files from that issue and it did slow the box down and cause errors.
That was a fun error to find though... wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Cannot contact support
by . 12/11/18 06:43 PM
errors importing a database
by andrewjs18. 12/11/18 03:51 AM
Private Message, Opt out of conversation
by jorb. 12/04/18 10:11 PM
Disable IP display in Who's Online?
by Baldeagle. 11/29/18 09:05 PM
Permissions problem
by Baldeagle. 11/25/18 09:44 PM
Forum Statistics
Forums36
Topics35,174
Posts191,649
Members12,119
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2