By Marko on Sunday, 26 June 2016
Posted in Technical Issues
Likes 0
Views 336
Votes 0
Hello, I created a menue with menue type "(Posts) Frontpage" and set it default.
If I start the website or use the menue entry then coms the Error.
Whas is the issue?

As work around I use the menue type "(Posts) Featured Posts"

Best regards, MArko

Unknown column 'intern' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `#__easyblog_post` AS a LEFT JOIN `#__easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`frontpage` = '1' AND (1 <= (select count(1) from `#__easyblog_post_category` AS acp INNER JOIN `#__easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` AND cat.`id` IN (6,5) AND cat.`id` != intern and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (62 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `#__easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (8)) > 0 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `#__easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `#__easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (8) ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `#__easyblog_team_users` as srcteamuser where srcteamuser.`team_id` = srcteam.`id` and srcteamuser.`user_id` = 62 ) > 0) OR (srcteam.`access` = 1 and (select count(1) from `#__easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (8) ) > 0))))) ORDER BY f.`created` DESC , a.`created` desc LIMIT 0,20
Hey Marko,

I found out the issue, it seems like you put category name instead of the category id, by the way, it should work fine now.
·
Monday, 27 June 2016 11:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

Can you provide us with your FTP access as well?

And assign your user account to have superadmin privileges so that I can view Easyblog configuration page.
·
Sunday, 26 June 2016 12:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,
thank you for your support.
1st: enjoy your weekend with your family or your friends
2nd: enjoy your weekend with your family or your friends

FTP-Access:
added at the primary post

The user role is super user now.

Best regards, Marko
·
Sunday, 26 June 2016 19:43
·
0 Likes
·
0 Votes
·
0 Comments
·
thank you, works fine.

Best regards, Marko
·
Monday, 27 June 2016 20:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
·
Monday, 27 June 2016 22:55
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post