By Thomas Thrane on Tuesday, 28 June 2016
Posted in Technical Issues
Likes 0
Views 652
Votes 0
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
Sorry, have been on holiday! :-)

Just installed the latest version, all good now, thanks!
·
Tuesday, 09 August 2016 00:02
·
0 Likes
·
0 Votes
·
0 Comments
·
I am sorry for the delay of this reply,

I've tried to access in your Joomla backend, but this is what I hitting :
Not Found

The requested URL /administrator was not found on this server.

Apache Server at xxx.xxxx.xxx Port 80


By the way, may i know is it you already using Easyblog latest version?
·
Tuesday, 28 June 2016 13:18
·
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.
·
Tuesday, 09 August 2016 10:09
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post