Problems

[amsch]

I am almost bald after this week worth of problems. My server moved me to a new server (without my knowledge :() and I have nothing but a mess. I finally upgraded to 2.2.4 and it still has not resolved some of my problems. My members are not finally able to post attachments but we are having this error over and over again.

Database error in vBulletin 2.2.4:


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


mysql error number: 1030

Then my second problem is post replies. It like winning the lottery to a get a post to go through. One time it does and one time it doesn't. When it doesn't go through, we get new thread specified or 404 error. I am running the newest version of PHP. I have been on these boards for hours trying one thing or another. Does anyone else have any suggestions?
Thank you!

[eva2000]

Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space, you need to

1. close your forum to prevent further posting or writing to the database
2. contact your web host

[amsch]

Thank you so much for the response! I was begining to think that it was no longer my fault! Could that also be the cause of the posting problem? Thank you so much Eva! I knew I was not loosing it!!!!!!!!

[eva2000]

Originally posted by amsch
Thank you so much for the response! I was begining to think that it was no longer my fault! Could that also be the cause of the posting problem? Thank you so much Eva! I knew I was not loosing it!!!!!!!! writing to the database while there is a lack of mysql disk space can corrupt your databases if you have telnet access you can type at shell prompt df

shell> df

to see your server's disk partition sizes and usage

[amsch]

[root@ns7 /root]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda4 16G 4.0G 11G 27% /
/dev/hda2 44M 20M 21M 49% /boot
/dev/hda3 88M 4.0M 79M 5% /tmp
[root@ns7 /root]# cd /usr/local/mysql/var
[root@ns7 var]# du -h
73k ./mysql
1.0k ./twentyishvbul
401M ./twentyishvbul-rebuilt
402M .


Ok does that make anysense?

[eva2000]

Originally posted by amsch
Filesystem Size Used Avail Use% Mounted on
/dev/hda4 16G 4.0G 11G 27% / i'd do the above 2 steps and contact your web host ;)

[amsch]

He just had me copy the information and says that I am not out of space according to what I just gave. Please forgive my lack on knowledge on this part.

[amsch]

that I am running not sure if that helps any?
mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)

[Chris Schreiber]

What OS (type and version) are you running? Can you do "perror 28" from the shell and let me know what it prints out?