Database error in vBulletin 4.2.3:

Invalid SQL:

	(
		SELECT
			visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress, visitormessage.userid AS profileuserid
			
			,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
			
		FROM visitormessage AS visitormessage
		LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
		
		WHERE visitormessage.userid = 14521 AND visitormessage.postuserid = 23262 AND visitormessage.state IN ('visible')
		
	)
	UNION
	(
		SELECT
			visitormessage.*, visitormessage.dateline AS pmdateline, user.*, visitormessage.ipaddress AS messageipaddress, visitormessage.userid AS profileuserid
			
			,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
			
		FROM visitormessage AS visitormessage
		LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
		
		WHERE visitormessage.userid = 23262 AND visitormessage.postuserid = 14521 AND visitormessage.state IN ('visible')
		
	)
	ORDER BY pmdateline DESC
	LIMIT 0, 10;

MySQL Error   : Disk full (/var/tmp/#sql_4551_16.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Error Number  : 1021
Request Date  : Monday, October 13th 2025 @ 09:46:09 PM
Error Date    : Monday, October 13th 2025 @ 09:46:09 PM
Script        : http://www.forumklassika.ru/converse.php?u=14521&u2=23262
Referrer      : 
IP Address    : 216.73.216.30
Username      : Незарегистрированный
Classname     : vB_Database_MySQLi
MySQL Version :