By shahryarjb on Saturday, 29 August 2015
Posted in General Issues
Replies 1
Likes 0
Views 595
Votes 0
hi
site in the localhost !!
 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 `h4sa6_easyblog_meta` AS m INNER JOIN `h4sa6_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 `h4sa6_easyblog_meta` AS m LEFT JOIN `h4sa6_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 `h4sa6_easyblog_meta` AS m LEFT JOIN `h4sa6_users` AS p ON m.content_id = p.id WHERE m.`type` = 'blogger') UNION (SELECT m.* FROM `h4sa6_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 `h4sa6_easyblog_meta` AS m LEFT JOIN `h4sa6_easyblog_category` AS p ON m.content_id = p.id WHERE m.`type` = 'category')) AS x LIMIT 0, 20
Hello,

Regarding your issue, can you run the below SQL statement from your phpMyAdmin?


ALTER TABLE `jos_easyblog_meta` ADD `title` TEXT NOT NULL AFTER `content_id`;


Replace the 'jos_' to your Joomla DB table prefix. This should fix your issue

Hope this help and have a nice day!
Sam
·
Saturday, 29 August 2015 19:42
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post