Warning: mysqli::query(): (HY000/1021): Disk full (/tmp/#sql-temptable-41e-3b16f-4adb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /home/medhomeo/public_html/system/library/db/mysqli.php on line 18
Fatal error: Uncaught Exception: Error: Disk full (/tmp/#sql-temptable-41e-3b16f-4adb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />
SELECT
p.post_id,
p.image,
p.date_created as date,
p.views,
pd.name,
pd.description,
a.username,
a.firstname,
a.lastname,
(
SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE bc.post_id = p.post_id AND bc.status = 1 AND bc.parent_id = 0
) as comments
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_to_product` p2p ON p.post_id = p2p.post_id
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE
pd.language_id = '1'
in /home/medhomeo/public_html/system/library/db/mysqli.php on line 40