By Bob Rynkiewicz on Friday, 29 January 2016
Posted in Technical Issues
Replies 3
Likes 0
Views 691
Votes 0
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
Hi Bob,

i've try to access you backend joomla admin but it redirect to you home page.

have try http://allaboutactors.net/mask still can't go to joomla administrator.

im also hitting this error rot you page error 303 and "NetworkError: 404 View not found [name...ticle, jpg, contentView - http://allaboutactors.net/two.jpg"

please consult with you server provider to check any file that related to joomla administrator.
·
Friday, 29 January 2016 15:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Jasni,

Thank You for helping me. I removed the hidden admin access so you should be able to access now via the standard Joomla URL.

bob
·
Friday, 29 January 2016 22:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Bob,

After hours checking your site it seems like the problem is because you have set an invalid category id in the category exclusion as you can see here, http://screencast.com/t/Q7WFJ10kAIx . I have removed this and it works fine now
·
Saturday, 30 January 2016 12:51
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post