No valid database connection Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SQL=SELECT a.id, a.title, a.alias, a.introtext, a.catid, a.sectionid, a.publish_up AS date, a.created_by_alias, c.title AS category, u.id AS uid, u.name AS author, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.state = 1 AND a.access <= 0 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-18 23:39:21' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-18 23:39:21' ) AND ( ((LOWER(a.title) LIKE '% %') OR (LOWER(a.introtext) LIKE '% %') OR (LOWER(a.`fulltext`) LIKE '% %') OR (LOWER(a.metakey) LIKE '% %') OR (LOWER(a.metadesc) LIKE '% %')) OR ((LOWER(a.title) LIKE '%stuff%') OR (LOWER(a.introtext) LIKE '%stuff%') OR (LOWER(a.`fulltext`) LIKE '%stuff%') OR (LOWER(a.metakey) LIKE '%stuff%') OR (LOWER(a.metadesc) LIKE '%stuff%')) ) AND a.id NOT IN (1) AND a.sectionid = 0 ORDER BY rand() LIMIT 0, 10
A lot of good stuff !!!
Â