mySQL probs - Got error 28 from table handler

[mariannet]

Hi there

For the first time ever I have run into mySQL problems and are really at a loss at what can be doing it.

Whenever a user is trying to get into the "user controlpanel" it states:

************************
Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=1 ORDER BY title
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Thursday 09th of October 2003 09:45:09 AM
Script: http://cgi.dullernes-univers.dk/ms/ms/usercp.php?s=
************************

I also wonder why the path is:
http://cgi.dullernes-univers.dk/ms/ms/usercp.php?s=

When the real path is:
http://cgi.dullernes-univers.dk/ms/usercp.php?s=

Can anyone please help a Danish Lady in distress?

[Xenon]

upload repair.php from the vb-zip archive and run it, normally that helps

[mariannet]

Originally Posted by Xenon

upload repair.php from the vb-zip archive and run it, normally that helps

I have tried that but it doesn't fix it.
I have full access to all the functions in the controlpanel if I go in there by the way of ex. inbox.

Only the controlpanel ("http://cgi.dullernes-univers.dk/ms/usercp.php?s=") gets the mySQL error.

[Xenon]

retry it, sometimes it needs more than one try.
if that doesn't help, you ahve to contact your host, as it'S a DB error, not a vbulletin one

[mariannet]

Hahaha

Here is what to do...

Go nuts and then leave it for a couple of days.
Sit down at the PC and say that you are not going to leave until it's working.
Open up the forum and...

It's working again.

Maybe my mySQL is in a timewarp or something, I don't know, but hey... who cares ;0)

[Xenon]

i think the host may have fixed it

[Steve Machol]

<i>Error code 28: No space left on device</i>

One or more partitions on your server is out of space. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

[mariannet]

I'm on a dedicated server with 30GB diskspace so I can't be out of space. Will check tomorrow if they have set a max on my mySQL.

Having a few problems with it this weekend, tables that excist dosn't and so on....

Thanks!

[Steve Machol]

Originally Posted by mariannet

I'm on a dedicated server with 30GB diskspace so I can't be out of space. Will check tomorrow if they have set a max on my mySQL.

Having a few problems with it this weekend, tables that excist dosn't and so on....

Thanks!

Sorry but error 28 is very clear - you have an out-of-sopace condition somewhere on your server. Most likely this is either in the MySQL partition or the partition with the 'tmp' folder. It could have been a temprary problem due to some temp files. Nonetheless the issue is very real and lack of space is the cause for this error.

[mariannet]

Originally Posted by Steve Machol

Error code 28: No space left on device

One or more partitions on your server is out of space. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

Hey Steve

You were so right. Something had generated a tmp file of 450MB and filled up the /tmp partition ;0)

Another problem solved. Having moved to dedicated server the phpAdmin were pointing to the old mySQL, so everyting I did actually didn't take place. Wasted a weekend trying to solve loads of mySQL table problems... I can see the table but vbulletin can't.. hohoho

Well, now I can start from again setting up the hacks that didn't work.

Thanks all!