I accidentally put a ticket in EasySocial sorry!
I upgrade website and followed instructions
after the upgrade the easyblog frontpage has this error
I upgraded Easyblog following the instructions on your site. After the install completed with no errors, the frontpage crashed.
I created a new menu item that is a joomla featured article so that the frontpage will show.
http://allaboutactors.net
Please "click" on easyblog menu item
Error: 1054
Unknown column 'archive' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `vbgak_easyblog_post` AS a LEFT JOIN `vbgak_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`frontpage` = '1' AND (1 <= (select count(1) from `vbgak_easyblog_post_category` AS acp INNER JOIN `vbgak_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` != archive and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `vbgak_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') ) AND a.`id` NOT IN ('35') ORDER BY a.`created` desc LIMIT 0,3
can you assist?
Thank You
Bob Rynkiewicz
I upgrade website and followed instructions
after the upgrade the easyblog frontpage has this error
I upgraded Easyblog following the instructions on your site. After the install completed with no errors, the frontpage crashed.
I created a new menu item that is a joomla featured article so that the frontpage will show.
http://allaboutactors.net
Please "click" on easyblog menu item
Error: 1054
Unknown column 'archive' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `vbgak_easyblog_post` AS a LEFT JOIN `vbgak_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`frontpage` = '1' AND (1 <= (select count(1) from `vbgak_easyblog_post_category` AS acp INNER JOIN `vbgak_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` != archive and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `vbgak_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') ) AND a.`id` NOT IN ('35') ORDER BY a.`created` desc LIMIT 0,3
can you assist?
Thank You
Bob Rynkiewicz