1253 - COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' SQL=SELECT distinct i.*, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN special_price ELSE price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email FROM #__djc2_items as i INNER JOIN (SELECT ic.item_id FROM #__djc2_items_categories AS ic INNER JOIN #__djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND ic.category_id IN (0,1,2)) as category_filter ON i.id = category_filter.item_id LEFT JOIN #__djc2_categories AS c ON c.id = i.cat_id LEFT JOIN #__djc2_producers AS p ON p.id = i.producer_id LEFT JOIN #__users AS ua ON ua.id = i.created_by WHERE ( LOWER(i.name) LIKE 'm%' COLLATE utf8_bin OR UPPER(i.name) LIKE 'm%' COLLATE utf8_bin ) AND i.published = 1 ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc LIMIT 8

You may not be able to visit this page because of:

  1. an out-of-date bookmark/favourite
  2. a search engine that has an out-of-date listing for this site
  3. a mistyped address
  4. you have no access to this page
  5. The requested resource was not found.
  6. An error has occurred while processing your request.

Please try one of the following pages:

If difficulties persist, please contact the System Administrator of this site and report the error below.

COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' SQL=SELECT distinct i.*, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN special_price ELSE price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email FROM #__djc2_items as i INNER JOIN (SELECT ic.item_id FROM #__djc2_items_categories AS ic INNER JOIN #__djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND ic.category_id IN (0,1,2)) as category_filter ON i.id = category_filter.item_id LEFT JOIN #__djc2_categories AS c ON c.id = i.cat_id LEFT JOIN #__djc2_producers AS p ON p.id = i.producer_id LEFT JOIN #__users AS ua ON ua.id = i.created_by WHERE ( LOWER(i.name) LIKE 'm%' COLLATE utf8_bin OR UPPER(i.name) LIKE 'm%' COLLATE utf8_bin ) AND i.published = 1 ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc LIMIT 8