Database query error

When I click on a profile I get the following error:

 

Database error in Heathen Places

Query:

SELECT `Profiles`.* FROM `FriendList`

LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `FriendList`.`Profile` AND `FriendList`.`ID` = '70' OR `Profiles`.`ID` = `FriendList`.`ID` AND `FriendList`.`Profile` = '70')

WHERE (`FriendList`.`Profile` = '70' OR `FriendList`.`ID` = '70') AND `FriendList`.`Check` = '1' ORDER BY `Profiles`.`Picture` DESC LIMIT 12

 

Mysql error:

Can't create/write to file '/tmp/#sql_2377_0.MYI' (Errcode: 30)

 

Found error in file /home/heathen2/public_html/inc/profiles.inc.php

at line 94. Called db_res function

with erroneous argument #0

 

Debug backtrace:

Array

(

[1] => Array

(

[file] => /home/heathen2/public_html/inc/profiles.inc.php

[line] => 94

[function] => db_res

[args] => Array

(

[0] => SELECT `Profiles`.* FROM `FriendList`

LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `FriendList`.`Profile` AND `FriendList`.`ID` = '70' OR `Profiles`.`ID` = `FriendList`.`ID` AND `FriendList`.`Profile` = '70')

WHERE (`FriendList`.`Profile` = '70' OR `FriendList`.`ID` = '70') AND `FriendList`.`Check` = '1' ORDER BY `Profiles`.`Picture` DESC LIMIT 12

)

 

)

Quote · 17 Nov 2008

I forgot to say, that is only the first part of the error. It is too long to post all of it here.

Quote · 17 Nov 2008

I solved the problem. The SQL tmp folder had changed its permissions to read only.

Quote · 18 Nov 2008
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.