UPDATES EasyBlog 6.0.14 Released! Joomla 5.x and PHP 8.x compatible now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is online
Our support specialists is available now. We will attend to you as soon as we can.
  Support is online

SEO reports error

Thomas Thrane · ·
2:04 AM Tuesday, 28 June 2016
None
Hi

I have requested a domainchange since I have gone live, so I hope you can help here.
(from new.provinsprovence.dk to provinsprovence.dk)

But my issue is that when I clisk SEO in Easyblog menu I get this error:



1271 Illegal mix of collations for operation 'UNION' 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 `#__easyblog_meta` AS m INNER JOIN `#__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 `#__easyblog_meta` AS m LEFT JOIN `#__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 != '', m.title, p.name) AS title FROM `#__easyblog_meta` AS m LEFT JOIN `#__users` AS p ON m.content_id = p.id WHERE m.`type` = 'blogger') UNION (SELECT m.id, m.type, m.content_id, m.keywords, m.description, m.indexing, m.title FROM `#__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 `#__easyblog_meta` AS m LEFT JOIN `#__easyblog_category` AS p ON m.content_id = p.id WHERE m.`type` = 'category')) AS x LIMIT 0, 20


What to do?

Regards
Thomas
The replies under this section are restricted to logged in users or users with an active subscription with us