Categoris Link Giving Page Not Found
By Sam Ray on Sunday, 23 April 2017
Posted in General
Likes 0
Views 216
Votes 0
1. Open the front page blog at
http://www.z1naz.org/index.php/en/coming-up/news
2. Click 'Categories' under the search bar, which should take you to page
http://www.z1naz.org/index.php/en/coming-up/news/categories
3. Instead, I get the below error message:

Error: 1054 - Unknown column 'a.author_alias' in 'where clause' SQL=SELECT COUNT(1) FROM `#__easyblog_post` AS a WHERE a.`created_by`='578' AND a.`published`='1' AND a.`state`='0' AND (a.`author_alias` IS NULL OR a.`author_alias` = '')
Hey there,

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

It seems like you missing this `author_alias` columns from #__easyblog_post table, I already run this following sql query, it should work fine now.


ALTER TABLE `tbt0c_easyblog_post` ADD `author_alias` VARCHAR(255) NULL;
Arlex Wong
·
Sunday, 23 April 2017 11:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, it is working as expected now.

Thank you very much for the fix!
Sam Ray
·
Sunday, 23 April 2017 11:16
·
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.
Arlex Wong
·
Sunday, 23 April 2017 11:34
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post