Notice: Error: Unknown column 'p.image' in 'field list'
Error No: 1054
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_user` a ON p.author_id = a.user_id WHERE pd.language_id = 2 AND p.status = 1 GROUP BY p.post_id ORDER BY p.date_created DESC LIMIT 0,8 in /home/ftfhk/domains/ftf.hk/public_html/system/database/mysql.php on line 50