Exception Object ( [message:protected] => Database error: Invalid SQL: SELECT M.*, QC.qcat_title, (CASE ques_user_type WHEN 'User' THEN CONCAT_WS(' ',U.user_first_name,U.user_last_name) WHEN 'Developer' THEN CONCAT_WS(' ',D.pdev_first_name,D.pdev_last_name) END) AS owner_name, (CASE ques_user_type WHEN 'User' THEN U.user_speciality WHEN 'Developer' THEN D.pdev_speciality END) AS owner_speciality, (CASE ques_user_type WHEN 'User' THEN U.user_photo WHEN 'Developer' THEN D.pdev_photo END) AS owner_photo, (SELECT COUNT(ans_id) FROM qa_answer_master WHERE ans_ques_id = M.ques_id AND ans_status = 'Approved') AS total_answer,(SELECT SUM( vote_type ) FROM qa_vote_master AS VT WHERE VT.vote_qa_id = M.ques_id AND VT.vote_qa_type = 'Question' AND ques_user_id = M.ques_user_id AND ques_user_type = M.ques_user_type ) AS total_votes FROM qa_question_master AS M LEFT JOIN qa_category_master AS QC ON QC.qcat_id = M.ques_cat_id LEFT JOIN user_master AS U ON U.user_id = M.ques_user_id AND ques_user_type = 'User' LEFT JOIN project_developer AS D ON D.pdev_id = M.ques_user_id AND ques_user_type = 'Developer' WHERE 1 AND ques_status = 'Approved' AND ques_user_id = '9999' AND ques_user_type = 'User' GROUP BY M.ques_id ORDER BY ques_datetime DESC
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bc_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"))
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 665 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/estatebl/public_html/libs/mysql5i.php [line] => 514 [function] => halt [class] => DB_Sql [type] => -> [args] => Array ( [0] => Invalid SQL: SELECT M.*, QC.qcat_title, (CASE ques_user_type WHEN 'User' THEN CONCAT_WS(' ',U.user_first_name,U.user_last_name) WHEN 'Developer' THEN CONCAT_WS(' ',D.pdev_first_name,D.pdev_last_name) END) AS owner_name, (CASE ques_user_type WHEN 'User' THEN U.user_speciality WHEN 'Developer' THEN D.pdev_speciality END) AS owner_speciality, (CASE ques_user_type WHEN 'User' THEN U.user_photo WHEN 'Developer' THEN D.pdev_photo END) AS owner_photo, (SELECT COUNT(ans_id) FROM qa_answer_master WHERE ans_ques_id = M.ques_id AND ans_status = 'Approved') AS total_answer,(SELECT SUM( vote_type ) FROM qa_vote_master AS VT WHERE VT.vote_qa_id = M.ques_id AND VT.vote_qa_type = 'Question' AND ques_user_id = M.ques_user_id AND ques_user_type = M.ques_user_type ) AS total_votes FROM qa_question_master AS M LEFT JOIN qa_category_master AS QC ON QC.qcat_id = M.ques_cat_id LEFT JOIN user_master AS U ON U.user_id = M.ques_user_id AND ques_user_type = 'User' LEFT JOIN project_developer AS D ON D.pdev_id = M.ques_user_id AND ques_user_type = 'Developer' WHERE 1 AND ques_status = 'Approved' AND ques_user_id = '9999' AND ques_user_type = 'User' GROUP BY M.ques_id ORDER BY ques_datetime DESC ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/QAMaster.php [line] => 410 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => SELECT M.*, QC.qcat_title, (CASE ques_user_type WHEN 'User' THEN CONCAT_WS(' ',U.user_first_name,U.user_last_name) WHEN 'Developer' THEN CONCAT_WS(' ',D.pdev_first_name,D.pdev_last_name) END) AS owner_name, (CASE ques_user_type WHEN 'User' THEN U.user_speciality WHEN 'Developer' THEN D.pdev_speciality END) AS owner_speciality, (CASE ques_user_type WHEN 'User' THEN U.user_photo WHEN 'Developer' THEN D.pdev_photo END) AS owner_photo, (SELECT COUNT(ans_id) FROM qa_answer_master WHERE ans_ques_id = M.ques_id AND ans_status = 'Approved') AS total_answer,(SELECT SUM( vote_type ) FROM qa_vote_master AS VT WHERE VT.vote_qa_id = M.ques_id AND VT.vote_qa_type = 'Question' AND ques_user_id = M.ques_user_id AND ques_user_type = M.ques_user_type ) AS total_votes FROM qa_question_master AS M LEFT JOIN qa_category_master AS QC ON QC.qcat_id = M.ques_cat_id LEFT JOIN user_master AS U ON U.user_id = M.ques_user_id AND ques_user_type = 'User' LEFT JOIN project_developer AS D ON D.pdev_id = M.ques_user_id AND ques_user_type = 'Developer' WHERE 1 AND ques_status = 'Approved' AND ques_user_id = '9999' AND ques_user_type = 'User' GROUP BY M.ques_id ORDER BY ques_datetime DESC ) ) [2] => Array ( [file] => /home/estatebl/public_html/user-profile.php [line] => 40 [function] => ViewAllQuestions [class] => QAMaster [type] => -> [args] => Array ( [0] => Array ( [all_record] => 1 [ques_user_id] => 9999 [ques_user_type] => User ) ) ) ) [previous:Exception:private] => )