Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
6 registered (Ruben, Gizmo, Bert, Mike L, Yarpâ„¢, driv), 18 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 14904
Top Posters (30 Days)
Ruben 66
SD 57
Gizmo 48
gliderdad 33
Dunny 21
driv 18
Iann128 16
dbremer 16
Stan 15
Mark S 13
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Topic Options
#170368 - 12/16/06 05:02 AM How do I fix this SQL Error?
marks Offline
stranger
Registered: 08/21/06
Posts: 7
When accessing any topics I get the following. I also get a similar error in Control Panel.

*******
Script: /usr/local/apache/htdocs/fmbwww/forums/scripts/showflat.inc.php
Line#: 231
SQL Error: Can't open file: 'ubbt_POSTS.MYI' (errno: 145)
SQL Error #: 1016
Query: SELECT t1.TOPIC_ID,t1.FORUM_ID,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_IS_STICKY,t1.POST_ID FROM ubbt_TOPICS as t1, ubbt_POSTS as t2 WHERE t2.POST_ID = 44604 AND t1.TOPIC_ID = t2.TOPIC_ID
*******

I run repair table ubbt_POSTS and I get this:

+---------------------+--------+----------+----------------------
| Table | Op | Msg_type | MsgTxt |
+---------------------+--------+----------+
| fmforums.ubbt_POSTS | repair | error | 28 when writing to datafile |
| fmforums.ubbt_POSTS | repair | error | 28 when writing to datafile |
| fmforums.ubbt_POSTS | repair | status | Operation failed |
+---------------------+--------+----------+

Any help would be a godsend at 5:00 AM EST! *lol*
Top
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."
#170369 - 12/16/06 06:16 AM Re: How do I fix this SQL Error? [Re: marks]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14904
Loc: Portland, OR; USA
Error 28 generally means you're out of diskspace (either you're at your MySQL space limit or the disk itself). I suggest you close down your forums and check your diskspace usage and if you're not at your quota, ask your webhost if there is a mysql space limit.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Edit Post
by Bert
01:19 PM
A positive note
by SteveS
09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Forum Stats
10213 Members
36 Forums
33667 Topics
180917 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image