|
Joined: Jan 2007
Posts: 5
stranger
|
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
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Jan 2007
Posts: 5
stranger
|
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?
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
.
|
|
|
|
Joined: Jan 2007
Posts: 5
stranger
|
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.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Yes, and Windows will show that write error in the event viewer (at least it should)
|
|
|
|
Joined: Jan 2007
Posts: 5
stranger
|
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.
|
|
|
|
Joined: Jan 2007
Posts: 5
stranger
|
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.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
ok - keep us updated & if you need further help just ask
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
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...
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
0 members (),
802
guests, and
186
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|