problem

[ff92k]

Well, another f'ing msql database problem, i am getting extremely fed up with this, and i hear UBB calling me, cause i get this alot.

This time:

Members cant view any threads posted. Any idea what the f*** is going on?or any way of fixing it, before i give up and go to UBB. Thanks

[RobAC]

How is anyone supposed to be able to help you if you don't post what the MySQL error message is?

[Steve Machol]

Can you provide us with a bit more information, like vB version, PHP and mySQL versions, and a URL where the problem is occuring?

Also please update your profile with your license info.

[ff92k]

i closed the forums, because i was getting alot of those freaking e-mails, the URL is

http://lindblum.futureff.com


the error e-mail is ::


Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM
post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>996099150)
WHERE
post.postid IN (0,3484,3500)
ORDER BY dateline

mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Wednesday 25th of July 2001 06:27:30 PM
Script: /showthread.php?threadid=265
Referer: http://lindblum.futureff.com/forumdisplay.php?forumid=2



the version is 2.0.0

PHP / MSQL version 5 (i think)

thats about it...

[tubedogg]

Error 28 means the partition is out of space.

Are you on a shared host or a dedicated server?

[ff92k]

shared

does this mean i cant fix it?

[tubedogg]

You should contact your host and ask them how much space is left in the MySQL partition, and tell them you are receiving that error and ask them if they could look into it.

Other than that, no there's nothing you can really do.

[Steve Machol]

It means you need to talk to your host. They're the only ones that can fix this. Good luck!

And don't forget to add your license info to your profile.

[RobAC]

Who is your hosting provider?

[ff92k]

what do u mean with the sig thing?

And i'm with hostrocket

[RobAC]

Read my new post in this Forum about receiving database errors.

[ff92k]

yea, i read that. Thank you does that mean they should be able to fix it soon?

[RobAC]

I don't know. This is all I was able to find on their support forums:

"This will hopefully be a temporary thing but we have had many reports of intermittant apache outages which are being caused by errors related to mod_gzip so until were certain it wont continue to do this we are disabling it. Its better to have the pages get there using a little more bandwidth than not at all. "