Error

Database query error

Query:
SELECT DISTINCT `SDatingEvents`.`ID`, `Title`, `EntryUri`, `Description`, `StatusMessage`, `Country`, `City`, `Place`, `PhotoFilename`, `Tags`, `EventStart`, UNIX_TIMESTAMP(`EventStart`) AS 'EventStart_UTS', (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`EventStart`)) AS `sec`, `ResponsibleID`, (NOW() > `EventEnd` AND NOW() < DATE_ADD(`EventEnd`, INTERVAL `ChoosePeriod` DAY)) AS `ChooseActive`, `AllowViewParticipants`, (`SDatingParticipants`.`ID` IS NOT NULL) AS `IsParticipant` FROM `SDatingEvents` LEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent` = `SDatingEvents`.`ID` AND `SDatingParticipants`.`IDMember` = 0 WHERE `SDatingEvents`.`Status` = 'Active' ORDER BY `SDatingEvents`.`EventStart` DESC LIMIT 0, 10

Mysql error:
Can't create/write to file '/tmp/#sql_685e_0.MYI' (Errcode: 28)

Found error in file /home/expertin/public_html/inc/classes/BxDolEvents.php
at line 555. Called db_res function with erroneous argument #0

Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/expertin/public_html/inc/classes/BxDolEvents.php
            [line] => 555
            [function] => db_res
            [args] => Array
                (
                    [0] => 
					SELECT
						DISTINCT `SDatingEvents`.`ID`, `Title`, `EntryUri`, `Description`, `StatusMessage`, `Country`, `City`, `Place`, `PhotoFilename`, `Tags`, `EventStart`, UNIX_TIMESTAMP(`EventStart`) AS 'EventStart_UTS', (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`EventStart`)) AS `sec`, `ResponsibleID`, (NOW() > `EventEnd` AND NOW() < DATE_ADD(`EventEnd`, INTERVAL `ChoosePeriod` DAY)) AS `ChooseActive`, `AllowViewParticipants`, (`SDatingParticipants`.`ID` IS NOT NULL) AS `IsParticipant` 
					FROM `SDatingEvents`
					LEFT JOIN `SDatingParticipants` ON `SDatingParticipants`.`IDEvent` = `SDatingEvents`.`ID` AND `SDatingParticipants`.`IDMember` = 0
					WHERE
						`SDatingEvents`.`Status` = 'Active'
						
					ORDER BY `SDatingEvents`.`EventStart` DESC 
				LIMIT 0, 10
                )

        )

    [2] => Array
        (
            [file] => /home/expertin/public_html/events.php
            [line] => 60
            [function] => PageSDatingShowEvents
            [class] => BxDolEvents
            [type] => ->
            [object] => BxDolEvents Object
                (
                    [iEventsPerPage] => 10
                    [iIconSize] => 45
                    [iThumbSize] => 110
                    [iImgSize] => 340
                    [bAdminMode] => 
                    [sPicNotAvail] => images/icons/group_no_pic.gif
                    [sSpacerPath] => http://www.expertinn.com/templates/base/images/icons/spacer.gif
                    [iLastInsertedID] => -1
                    [bUseFriendlyLinks] => 
                )

            [args] => Array
                (
                )

        )

    [3] => Array
        (
            [file] => /home/expertin/public_html/events.php
            [line] => 49
            [function] => PageCompPageMainCode
            [args] => Array
                (
                )

        )

)

Called script: /events.php
Request parameters:

Array
(
    [show_events] => all
    [action] => show
    [idAff] => 31998
)