Warning: mysqli::query(): (HY000/1021): Disk full (/tmp/#sql-temptable-3de2bd-2ef79d-9b338.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/autoalivedresscom/system/library/db/mysqli.php on line 19Notice: Error: Disk full (/tmp/#sql-temptable-3de2bd-2ef79d-9b338.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Error No: 1021
SELECT
p.post_id,
p.image,
p.date_created as date,
pd.name,
pd.description,
a.username,
a.firstname,
a.lastname,
(
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
WHERE pd.language_id = 1 AND p2s.store_id = 0
AND p.status = 1 GROUP BY p.post_id ORDER BY p.date_created DESC LIMIT 0,15 in /var/www/autoalivedresscom/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/autoalivedresscom/catalog/model/journal2/blog.php on line 271Warning: Invalid argument supplied for foreach() in /var/www/autoalivedresscom/catalog/controller/journal2/blog.php on line 153Autoalivedress Blog