By Sandra Lamb on Sunday, 23 August 2015
Posted in Technical Issues
Replies 1
Likes 0
Views 533
Votes 0
When I go to component/Easyblog/SEO I get this error page :
An error has occurred.

1054 Unknown column 'm.title' in 'field list' SQL=SELECT * FROM ( (SELECT m.id, m.type, m.content_id, m.keywords, m.description, m.indexing, if(m.title != '', ifnull(m.title, p.title), p.title) AS title FROM `cyfnb_easyblog_meta` AS m INNER JOIN `cyfnb_easyblog_post` AS p ON m.content_id = p.id AND p.`published`!='9' WHERE m.`type` = 'post') UNION (SELECT m.id, m.type, m.content_id, m.keywords, m.description, m.indexing, if(m.title != '', ifnull(m.title, p.title), p.title) AS title FROM `cyfnb_easyblog_meta` AS m LEFT JOIN `cyfnb_easyblog_team` AS p ON m.content_id = p.id WHERE m.`type` = 'team') UNION (SELECT m.id, m.type, m.content_id, m.keywords, m.description, m.indexing, if(m.title != '', ifnull(m.title, p.name), p.name) AS title FROM `cyfnb_easyblog_meta` AS m LEFT JOIN `cyfnb_users` AS p ON m.content_id = p.id WHERE m.`type` = 'blogger') UNION (SELECT m.* FROM `cyfnb_easyblog_meta` AS m WHERE m.`type` = 'view') UNION (SELECT m.id, m.type, m.content_id, m.keywords, m.description, m.indexing, if(m.title != '', ifnull(m.title, p.title), p.title) AS title FROM `cyfnb_easyblog_meta` AS m LEFT JOIN `cyfnb_easyblog_category` AS p ON m.content_id = p.id WHERE m.`type` = 'category')) AS x LIMIT 0, 20

Obviously something is wrong with database. This is a new installation of easyblog and I have not transferred anything to the database.

The site is http://goo.gl/vGH7SS
If you need backend access send PM details - thank you.
Hi Sandra,

Regarding your issue, look like there is a missing column in your EasyBlog. I have manually added the missing column and now you no longer hit this error message Below is the sql statement i've executed.


ALTER TABLE `#__easyblog_meta` ADD `title` TEXT NOT NULL AFTER `content_id`;


Replace #__ with your Joomla table prefix.

Hope this help and have a nice day!
Sam
·
Monday, 24 August 2015 11:07
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post