database error

HI all

Can anyone point me in the right direct of how to stop this error

Query:

SELECT `p`.*, `f`.`ID`, 
				if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
				UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' 	FROM (
				SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
				UNION
				SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
			) AS `f`
			INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
			
            WHERE 1  AND (p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE))
			ORDER BY p.`DateLastNav` DESC
			

Mysql error: Got error 28 from storage engine

Found error in the file '/home/xxxxxxx/public_html/inc/profiles.inc.php' at line 397.
Called 'db_res' function with erroneous argument #0.

line 397 states     $vProfiles = db_res($sqlQuery);

Im using 7.07 btw

Thanks in advance

Jim

SELECT `p`.*, `f`.`ID`, 
				if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
				UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' 	FROM (
				SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
				UNION
				SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
			) AS `f`
			INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`

            WHERE 1  AND (p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE))
			ORDER BY p.`DateLastNav` DESC

 you file is fine no worry about that.

error 28 means No space left on device
Even if there is a lot of space left, the query you are executing may need to create temporary tables and such during it's execution, which will obviously require extra space

AKA: You need to contact your hosting provider.

Also, I moved this into the proper forum. This is a hosting-related issue, not a bug.

and while waiting for your host for an answer     you can try this  in phpmyadmin  repair/optimize the db it's a temp..solution.

Many thanks Prolaznick.

Im on the case with the hosting company now.

Regards

Jim

Well despite 3 days of to and fro with Arvixe and being told its a server error, then its not a server error and being told i must upgrade (havent heard this from them about 20+ times) because im using to much resources i finally had enough and am leaving them. Anybody recommend another decent hoster?

Ive spent soooooo many hours in chat with these people and get told different things all the time and often get left for ages and ages without reply. Spent almost half an hour the other night for support to reply with. Admin are looking into it for you. Ive been given so many different stories and not so long ago, after many many storage errors and 500 server errors i was faced with a message telling me that the resources limit was reached and i could not access site. There was a total of me and one user online. Anyway enough is enough from these people and i told support that as well. I informed them that i couldnt take anymore and was going elsewhere.

So back to my question. Decent hosting recommendations please. Please bear in mind Im unemployed and do not charge anything to use my site wotsoever.Im grateful that i get some users now and then.lol

Thanks in advance

Jim

So back to my question. Decent hosting recommendations please. Please bear in mind Im unemployed and do not charge anything to use my site wotsoever.Im grateful that i get some users now and then.lol That is surely annoying. Dolphin does require resources that most times exceed what is available on a shared environment. With that said, though we discontinued shared hosting fir dolphin with the release of version 7 considering your circumstances we may be able to work something out. Contact us

Hi DosDawg

Thnak you for your kind offer its VERY much appreciated. Ive already setup with another hostor and transfered my site yesterday and all seems to be well atm.

I will keep your offer in mind if this one doesnt work out.

Regards

Jim