<b>Warning</b>: mysqli::query(): (HY000/1021): Disk full (/tmp/#sql_2cd1_0.MAI); waiting for someone to free some space... (errno: 28 &quot;No space left on device&quot;) in <b>/home/tchandle/public_html/needtshirtsnow.com/system/library/db/mysqli.php</b> on line <b>21</b><br />
<b>Fatal error</b>:  Uncaught exception 'Exception' with message 'Error: Disk full (/tmp/#sql_2cd1_0.MAI); waiting for someone to free some space... (errno: 28 &quot;No space left on device&quot;)&lt;br /&gt;Error No: 1021&lt;br /&gt;
            SELECT
                p.post_id,
                p.image,
                p.date_created as date,
                pd.name,
                pd.description,
                a.username,
                a.firstname,
                a.lastname,
                a.email,
                (
                    SELECT count(*)
                    FROM `oc_journal2_blog_comments` bc
                    WHERE bc.post_id = p.post_id AND bc.status = 1 AND bc.parent_id = 0
                ) as comments
            FROM `oc_journal2_blog_post` p
            
            LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
            LEFT JOIN `oc_journal2_blog_post_to_store` p2s ON p.post_id = p2s.post_id
            LEFT JOIN `oc_user` a ON p.author_id = a.user_id
            WHE in <b>/home/tchandle/public_html/needtshirtsnow.com/system/library/db/mysqli.php</b> on line <b>43</b><br />