|
|
|
|
Joined: May 2003
Posts: 5
Lurker
|
|
Lurker
Joined: May 2003
Posts: 5 |
I need help... what does this mean?
SQL ERROR: Thu, Jul 10 2003 01:30:42 +0000 Unable to do_query: SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description FROM w3t_Category WHERE Cat_Type = 'forum' ORDER BY Cat_Number
Can't create/write to file '/var/tmp/#sql564b_50_1.MYI' (Errcode: 2)
I have been running 6.2.3 for 2 months without a problem...
This afternoon I started getting this error everytime I try going into "Main Index"... Everything else works...
What could cause this? No changes have been made to anything... How do I go about fixing it?
|
|
|
|
|
Joined: Feb 2002
Posts: 1,759
Addict
|
|
Addict
Joined: Feb 2002
Posts: 1,759 |
can't create or write to file... check to be sure your /var partition isn't full.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Yeah, beyond that, you could try this SQL Query.
REPAIR TABLE w3t_Category
|
|
|
|
|
Joined: May 2003
Posts: 5
Lurker
|
|
Lurker
Joined: May 2003
Posts: 5 |
Jeremy & Josh,
Thanks for the feed back!
I tried repairing the table, no help...
Not sure about the "full partition" thing, I will have to contact my web host...
One curious thing I have discovered though... I do not have the problem if I have all of my forums in the "General Discussion" category... But when I add an additional category I get the same error... without even moving a forum into the new category... don't know if this is a "clue" or not...
I have even deleted and recreated the category table... same problem...
Any ideas?
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
There may be more advanced corruption in the Category table. There are some more advaanced repair options that your host could try running from the command line.
|
|
|
|
|
Joined: May 2003
Posts: 5
Lurker
|
|
Lurker
Joined: May 2003
Posts: 5 |
Thanks again Josh!  The problem has now disappeared as mysteriously as it appeared to begin with...  Although they deny any knowledge of it, I think the problem was with my web host somewhere... Like they would admit to it...  Mark
|
|
|
|
|
Joined: Jun 2003
Posts: 1,025
Junior Member
|
|
Junior Member
Joined: Jun 2003
Posts: 1,025 |
My web host always tells me whats going on. Sometimes it is an upgrade they did, sometimes it is a datacenter issue. I've had about 3 minor problems, all fixed within a couple of hours. Imediate response. Honesty and imediate response earns big bonus points with me. 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 87
Joined: December 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
