After upgrading from 5.0.17 to 5.0.20 and when trying to access the SEO tab (where metas are configured) I get the following error:
----------------
1060 [*] Duplicate column name 'title' SQL=SELECT * FROM ( (SELECT m.*, p.title AS title FROM `xxxxx_easyblog_meta` AS m INNER JOIN `xxxxx_easyblog_post` AS p ON m.content_id = p.id AND p.`published`!='9' WHERE m.`type` = 'post') UNION (SELECT m.*, p.title AS title FROM `xxxxx_easyblog_meta` AS m LEFT JOIN `xxxxx_easyblog_team` AS p ON m.content_id = p.id WHERE m.`type` = 'team') UNION (SELECT m.*, p.name AS title FROM `xxxxx_easyblog_meta` AS m LEFT JOIN `xxxxx_users` AS p ON m.content_id = p.id WHERE m.`type` = 'blogger') UNION (SELECT m.*, '' AS title FROM `xxxxx_easyblog_meta` AS m WHERE m.`type` = 'view') UNION (SELECT m.*, p.title AS title FROM `xxxxx_easyblog_meta` AS m LEFT JOIN `xxxxx_easyblog_category` AS p ON m.content_id = p.id WHERE m.`type` = 'category')) AS x LIMIT 0, 20
-----------------
FYI - I did notice that from 5.0.17 to 5.0.20 a new column - "title" had been created in the _easyblog_meta table. When I compared the db schema before and after the upgrade that was the only table with schema changes.
This is not an issue for me as we don't use that functionality yet. Thought you would like the feedback.
btw - upgrade went otherwise smoothly. Really like the improvements to how images are handled and the changes to the Layout section. ie being able to select the image size for the post cover in the different view independently.
----------------
1060 [*] Duplicate column name 'title' SQL=SELECT * FROM ( (SELECT m.*, p.title AS title FROM `xxxxx_easyblog_meta` AS m INNER JOIN `xxxxx_easyblog_post` AS p ON m.content_id = p.id AND p.`published`!='9' WHERE m.`type` = 'post') UNION (SELECT m.*, p.title AS title FROM `xxxxx_easyblog_meta` AS m LEFT JOIN `xxxxx_easyblog_team` AS p ON m.content_id = p.id WHERE m.`type` = 'team') UNION (SELECT m.*, p.name AS title FROM `xxxxx_easyblog_meta` AS m LEFT JOIN `xxxxx_users` AS p ON m.content_id = p.id WHERE m.`type` = 'blogger') UNION (SELECT m.*, '' AS title FROM `xxxxx_easyblog_meta` AS m WHERE m.`type` = 'view') UNION (SELECT m.*, p.title AS title FROM `xxxxx_easyblog_meta` AS m LEFT JOIN `xxxxx_easyblog_category` AS p ON m.content_id = p.id WHERE m.`type` = 'category')) AS x LIMIT 0, 20
-----------------
FYI - I did notice that from 5.0.17 to 5.0.20 a new column - "title" had been created in the _easyblog_meta table. When I compared the db schema before and after the upgrade that was the only table with schema changes.
This is not an issue for me as we don't use that functionality yet. Thought you would like the feedback.
btw - upgrade went otherwise smoothly. Really like the improvements to how images are handled and the changes to the Layout section. ie being able to select the image size for the post cover in the different view independently.