QUERY: SELECT M.displayName,M.icon,MV.extraText,M.isModal,IFNULL(M.back_image,"") as back_image,MV.menuName,IFNULL(IFNULL(M.custom_link,MV.customLink),CONCAT("//",CL.domain,"/",L.langcode,"/",IFNULL(PV.permalinkVersion,P.permalink))) as link,M.ID as menuID,P.permalink, CASE WHEN P.permalink = 'suite-room' THEN 1 ELSE 0 END AS current FROM tblCompanyLocation CL INNER JOIN tblMenu M ON M.companyLocationID = CL.ID INNER JOIN tblCompanySetting CS ON CS.locationID = CL.ID LEFT JOIN tblPage P ON P.menuID = M.ID AND P.companyLocationID = CL.ID LEFT JOIN tblPageVersion PV ON PV.pageID = P.id AND PV.lang_id = IFNULL((SELECT ID FROM tblLanguages WHERE langcode = 'en'),CS.defaultLangID) INNER JOIN tblLanguages L ON L.ID = IFNULL((SELECT ID FROM tblLanguages WHERE langcode = 'en'),CS.defaultLangID) LEFT JOIN tblMenuVersion MV ON MV.menuID= M.ID AND MV.langID = IFNULL((SELECT ID FROM tblLanguages WHERE langcode = 'en'),CS.defaultLangID) INNER JOIN tblTemplateMenuPositions TMP ON TMP.position = 'Main-Menu' AND M.pos_id = TMP.id WHERE CL.ID = 463 AND M.isVisible = 1 AND M.isActive = 1 AND M.pageID IS NULL AND M.parentID = -1 AND (M.custom_link IS NOT NULL OR MV.customLink IS NOT NULL OR P.permalink IS NOT NULL) ORDER BY M.sOrder ASC
ERROR: Disk full (/var/tmp/#sql_6d6_0); waiting for someone to free some space...

Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/booklogic/domains/cms.booklogic.net/tmp) in Unknown on line 0