Phoca Forum

Phoca Gallery 3.2.3 on the Joomla 2.5 does not work :х

Category Rating:

500 - Обнаружена ошибка.

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_votes` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_votes` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_votes` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc

Phoca Gallery 3.2.3 on the Joomla 2.5 does not work

Image Rating:

500 - Обнаружена ошибка.

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_img_votes` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery AS i ON i.id = a.imgid LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_img_votes` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery AS i ON i.id = a.imgid LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_img_votes` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery AS i ON i.id = a.imgid LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc

Phoca Gallery 3.2.3 on the Joomla 2.5 does not work

Category Comments:

500 - Обнаружена ошибка.

JDatabaseMySQLi::query: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_comments` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Вернуться в Панель управления
Call stack
# Function Location
1 JAdministrator->dispatch() /home/u853454683/public_html/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/u853454683/public_html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/u853454683/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /home/u853454683/public_html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/u853454683/public_html/administrator/components/com_phocagallery/phocagallery.php:39
6 PhocaGalleryCpController->display() /home/u853454683/public_html/libraries/joomla/application/component/controller.php:761
7 JController->display() /home/u853454683/public_html/administrator/components/com_phocagallery/controller.php:48
8 PhocaGalleryCpViewPhocaGalleryCos->display() /home/u853454683/public_html/libraries/joomla/application/component/controller.php:722
9 JView->get() /home/u853454683/public_html/administrator/components/com_phocagallery/views/phocagallerycos/view.html.php:23
10 JModelList->getItems() /home/u853454683/public_html/libraries/joomla/application/component/view.php:386
11 JModelList->getStart() /home/u853454683/public_html/libraries/joomla/application/component/modellist.php:128
12 JModelList->getTotal() /home/u853454683/public_html/libraries/joomla/application/component/modellist.php:265
13 JModel->_getListCount() /home/u853454683/public_html/libraries/joomla/application/component/modellist.php:231
14 JDatabaseMySQLi->execute() /home/u853454683/public_html/libraries/joomla/application/component/model.php:318
15 JError::raiseError() /home/u853454683/public_html/libraries/joomla/database/database/mysqli.php:396
16 JError::raise() /home/u853454683/public_html/libraries/joomla/error/error.php:251

Phoca Gallery 3.2.3 on the Joomla 2.5 does not work

Image Comments:

500 - Обнаружена ошибка.

JDatabaseMySQLi::query: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `hdr5j_phocagallery_img_comments` AS a LEFT JOIN `hdr5j_languages` AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN hdr5j_phocagallery AS i ON i.id = a.imgid LEFT JOIN hdr5j_phocagallery_categories AS c ON c.id = i.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Вернуться в Панель управления
Call stack
# Function Location
1 JAdministrator->dispatch() /home/u853454683/public_html/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/u853454683/public_html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/u853454683/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /home/u853454683/public_html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/u853454683/public_html/administrator/components/com_phocagallery/phocagallery.php:39
6 PhocaGalleryCpController->display() /home/u853454683/public_html/libraries/joomla/application/component/controller.php:761
7 JController->display() /home/u853454683/public_html/administrator/components/com_phocagallery/controller.php:48
8 PhocaGalleryCpViewPhocaGalleryCoImgs->display() /home/u853454683/public_html/libraries/joomla/application/component/controller.php:722
9 JView->get() /home/u853454683/public_html/administrator/components/com_phocagallery/views/phocagallerycoimgs/view.html.php:23
10 JModelList->getItems() /home/u853454683/public_html/libraries/joomla/application/component/view.php:386
11 JModelList->getStart() /home/u853454683/public_html/libraries/joomla/application/component/modellist.php:128
12 JModelList->getTotal() /home/u853454683/public_html/libraries/joomla/application/component/modellist.php:265
13 JModel->_getListCount() /home/u853454683/public_html/libraries/joomla/application/component/modellist.php:231
14 JDatabaseMySQLi->execute() /home/u853454683/public_html/libraries/joomla/application/component/model.php:318
15 JError::raiseError() /home/u853454683/public_html/libraries/joomla/database/database/mysqli.php:396
16 JError::raise() /home/u853454683/public_html/libraries/joomla/error/error.php:251

Users:

500 - Обнаружена ошибка.

JDatabaseMySQLi::query: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM hdr5j_phocagallery_user AS a LEFT JOIN hdr5j_languages AS l ON l.lang_code = a.language LEFT JOIN hdr5j_users AS ua ON ua.id=a.userid LEFT JOIN hdr5j_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM hdr5j_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM hdr5j_phocagallery AS i LEFT JOIN hdr5j_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN hdr5j_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc

Hi, try to check your Joomla! installation, Phoca Gallery does not set collations All this is set in Joomla! - Phoca Gallery just use standard utf-8 as set in Joomla!

Jan