UPDATES EasyBlog 6.0.11 Released! Update to the latest version 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

DB Error When Accessing 'SEO' Settings

Brandon Scivolette · ·
4:20 AM Friday, 08 April 2016
None
Good Afternoon,

I'm new to EasyBlog and, so far, everything is working well except one error. When attempting to access the 'SEO' menu (standalone, not under 'General' settings) I receive a DB error. The URL I am trying to access is: /administrator/index.php?option=com_easyblog&view=metas

The error doesn't appear to affect the component or any other configuration.

I've copied the full error message below and also attached a screenshot.

## Error Message ##
1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull' 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 != '', ifnull(m.title, p.name), 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.* 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

NOTE: Post edited to include FTP and domain details for the test server.
The replies under this section are restricted to logged in users or users with an active subscription with us