SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/MYacZzhc' (Errcode: 28 - No space left on device)Array
(
    [sql] => SELECT *, `a`.`post_title` as `name`, a.doctor_condition as 'condition', `a`.`doctor_description` as `descr`, `a`.`doctor_education` as `education`, `a`.`doctor_experience` as `experience`, `a`.`doctor_location` as `location`, `a`.`doctor_organization` as `organization`, `a`.`doctor_specialty` as `specialty`, `a`.`doctor_year_experience` as `exp`, `a`.`doctor_phone` as `phone`, a.doctor_address as 'add', `a`.`doctor_gender` as `gender`, ( SELECT `name`
FROM `categories`
WHERE `page_type` = 'doctor_category'
AND `id` = `a`.`doctor_category`
 LIMIT 1 ) as title, ( SELECT `name`
FROM `categories`
WHERE `page_type` = 'specialization_category'
AND `id` = `a`.`doctor_condition`
 LIMIT 1 ) as treatment, ( SELECT `full_path`
FROM `uploads` `upl`
WHERE id IN ( SELECT `meta_value`
FROM `postmeta`
WHERE `post_id` = `a`.`post_id`
AND `meta_key` = 'post_thumbnail' )
 LIMIT 1 ) as upload_url, ( SELECT `name`
FROM `ap_user` `user`
WHERE `id` = `a`.`post_author`
 LIMIT 1 ) as post_author_name, `a`.`doctor_description` as `category_name`, `post_modified` as `last_update`
FROM ( SELECT *, `p`.`id` as `post_id`, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_condition' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_condition, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_description' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_description, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_education' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_education, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_experience' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_experience, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_location' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_location, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_organization' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_organization, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_specialty' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_specialty, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_year_experience' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_year_experience, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_phone' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_phone, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_address' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_address, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_gender' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_gender, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_hospitals' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_hospitals, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_category' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_category, (
                    SELECT MAX(CASE WHEN meta_key='custom_fields_doctor_specialization' THEN meta_value END) 
                    FROM postmeta WHERE post_id=p.id GROUP BY post_id 
                ) as doctor_specialization
FROM `posts` `p`
WHERE `post_type` = 'doctor'
AND  
            p.id IN (
                SELECT post_id 
                FROM postmeta
                    WHERE meta_key='custom_fields_doctor_specialization' 
                    AND meta_value LIKE(
                        SELECT CONCAT('%', `id`, '%')  
                        FROM categories
                            WHERE page_type='specialization_category'
                            AND slug=:specialization
                        ) 
            )
AND `p`.`post_status` = 'publish' ) a
ORDER BY `name` ASC
 LIMIT 490, 10
    [params] => Array
        (
            [specialization] => bedah-kanker-2
        )

)
Array
(
    [0] => Array
        (
            [file] => /var/www/html/adminpanel/helpers/doctor_helper.php
            [line] => 118
            [function] => selectIt
            [class] => BaseModel
            [type] => ->
        )

    [1] => Array
        (
            [file] => /var/www/html/adminpanel/libraries/PageRender/DoctorRenderer.php
            [line] => 44
            [function] => searchPost
        )

    [2] => Array
        (
            [file] => /var/www/html/adminpanel/libraries/PageRender/PageRenderer.php
            [line] => 19
            [function] => processIt
            [class] => DoctorRenderer
            [type] => ->
        )

    [3] => Array
        (
            [file] => /var/www/html/adminpanel/helpers/page_helper.php
            [line] => 30
            [function] => handleIt
            [class] => PageRenderer
            [type] => ->
        )

    [4] => Array
        (
            [file] => /var/www/html/frontpage/controllers/Page.php
            [line] => 20
            [function] => renderPage
        )

    [5] => Array
        (
            [file] => /var/www/html/frontpage/controllers/Page.php
            [line] => 6
            [function] => handlePost
            [class] => Page
            [type] => ->
        )

    [6] => Array
        (
            [file] => /var/www/html/frameworks/codeIgniter/version-3.1.3/system/core/CodeIgniter.php
            [line] => 532
            [function] => index
            [class] => Page
            [type] => ->
        )

    [7] => Array
        (
            [file] => /var/www/html/index.php
            [line] => 326
            [args] => Array
                (
                    [0] => /var/www/html/frameworks/codeIgniter/version-3.1.3/system/core/CodeIgniter.php
                )

            [function] => require_once
        )

)