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-24 03:08:55' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-24 03:08:55' ) AND ( ((LOWER(a.title) LIKE '%friends%') OR (LOWER(a.introtext) LIKE '%friends%') OR (LOWER(a.`fulltext`) LIKE '%friends%') OR (LOWER(a.metakey) LIKE '%friends%') OR (LOWER(a.metadesc) LIKE '%friends%')) OR ((LOWER(a.title) LIKE '%create%') OR (LOWER(a.introtext) LIKE '%create%') OR (LOWER(a.`fulltext`) LIKE '%create%') OR (LOWER(a.metakey) LIKE '%create%') OR (LOWER(a.metadesc) LIKE '%create%')) OR ((LOWER(a.title) LIKE '%zip{linkr%') OR (LOWER(a.introtext) LIKE '%zip{linkr%') OR (LOWER(a.`fulltext`) LIKE '%zip{linkr%') OR (LOWER(a.metakey) LIKE '%zip{linkr%') OR (LOWER(a.metadesc) LIKE '%zip{linkr%')) OR ((LOWER(a.title) LIKE '%component%') OR (LOWER(a.introtext) LIKE '%component%') OR (LOWER(a.`fulltext`) LIKE '%component%') OR (LOWER(a.metakey) LIKE '%component%') OR (LOWER(a.metadesc) LIKE '%component%')) OR ((LOWER(a.title) LIKE '%Twitter®%') OR (LOWER(a.introtext) LIKE '%Twitter®%') OR (LOWER(a.`fulltext`) LIKE '%Twitter®%') OR (LOWER(a.metakey) LIKE '%Twitter®%') OR (LOWER(a.metadesc) LIKE '%Twitter®%')) OR ((LOWER(a.title) LIKE '%built-in%') OR (LOWER(a.introtext) LIKE '%built-in%') OR (LOWER(a.`fulltext`) LIKE '%built-in%') OR (LOWER(a.metakey) LIKE '%built-in%') OR (LOWER(a.metadesc) LIKE '%built-in%')) OR ((LOWER(a.title) LIKE '%albums\n*%') OR (LOWER(a.introtext) LIKE '%albums\n*%') OR (LOWER(a.`fulltext`) LIKE '%albums\n*%') OR (LOWER(a.metakey) LIKE '%albums\n*%') OR (LOWER(a.metadesc) LIKE '%albums\n*%')) OR ((LOWER(a.title) LIKE '%multiple%') OR (LOWER(a.introtext) LIKE '%multiple%') OR (LOWER(a.`fulltext`) LIKE '%multiple%') OR (LOWER(a.metakey) LIKE '%multiple%') OR (LOWER(a.metadesc) LIKE '%multiple%')) OR ((LOWER(a.title) LIKE '%system\n*%') OR (LOWER(a.introtext) LIKE '%system\n*%') OR (LOWER(a.`fulltext`) LIKE '%system\n*%') OR (LOWER(a.metakey) LIKE '%system\n*%') OR (LOWER(a.metadesc) LIKE '%system\n*%')) OR ((LOWER(a.title) LIKE '%groups\n*%') OR (LOWER(a.introtext) LIKE '%groups\n*%') OR (LOWER(a.`fulltext`) LIKE '%groups\n*%') OR (LOWER(a.metakey) LIKE '%groups\n*%') OR (LOWER(a.metadesc) LIKE '%groups\n*%')) OR ((LOWER(a.title) LIKE '%Quote%') OR (LOWER(a.introtext) LIKE '%Quote%') OR (LOWER(a.`fulltext`) LIKE '%Quote%') OR (LOWER(a.metakey) LIKE '%Quote%') OR (LOWER(a.metadesc) LIKE '%Quote%')) OR ((LOWER(a.title) LIKE '%widgets%') OR (LOWER(a.introtext) LIKE '%widgets%') OR (LOWER(a.`fulltext`) LIKE '%widgets%') OR (LOWER(a.metakey) LIKE '%widgets%') OR (LOWER(a.metadesc) LIKE '%widgets%')) OR ((LOWER(a.title) LIKE '%support%') OR (LOWER(a.introtext) LIKE '%support%') OR (LOWER(a.`fulltext`) LIKE '%support%') OR (LOWER(a.metakey) LIKE '%support%') OR (LOWER(a.metadesc) LIKE '%support%')) OR ((LOWER(a.title) LIKE '%There\'s%') OR (LOWER(a.introtext) LIKE '%There\'s%') OR (LOWER(a.`fulltext`) LIKE '%There\'s%') OR (LOWER(a.metakey) LIKE '%There\'s%') OR (LOWER(a.metadesc) LIKE '%There\'s%')) OR ((LOWER(a.title) LIKE '%private%') OR (LOWER(a.introtext) LIKE '%private%') OR (LOWER(a.`fulltext`) LIKE '%private%') OR (LOWER(a.metakey) LIKE '%private%') OR (LOWER(a.metadesc) LIKE '%private%')) ) AND a.id NOT IN (1279) AND a.sectionid = 6 ORDER BY rand() LIMIT 0, 5
|
Joomla -
Joomla Extensions
|
|
Geschrieben von: DSAdmin
|
|
Mittwoch, den 16. Dezember 2009 um 10:49 Uhr |
|
JomSocial allows your users to:
* create, join and participate in groups
* connect with each other via buddy/friends system
* find out what friends have been doing...in real-time
* update them with your Twitter® posts
* communicate with new & old friends via private messages
* create multiple photo albums
* and so much more! There's also built-in support for widgets and applications with our robust API for 3rd party component integration!
Quote:
http://rapidshare.com/files/188504801/JomSocial_1.0.128.zip
 |
