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 offline
Our team is away during the weekend. Some answers may already be available on our documentation

Rest assured that we will get back to your posts as soon as the week starts!
  Support is offline

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