chdemko / joomla-external-login

The External Login project allows Joomla! to manage external Authentication Servers
GNU General Public License v2.0
30 stars 19 forks source link

Joomla 3.x installation issue #27

Closed AshMartian closed 6 years ago

AshMartian commented 8 years ago

I've just installed the plugin on a Joomla 3.5.1 site. After enabling the plugins and navigating to components->External Login, I get the following SQL error.

Error

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `#__externallogin_servers` as a LEFT JOIN #__users AS u ON u.id=a.checked_out LEFT JOIN #__extensions AS e ON `e`.`type`='plugin' AND CONCAT_WS('.', `e`.`folder`, `e`.`element`)=`a`.`plugin` WHERE (a.published >= 0)
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,u.name AS editor,e.enabled AS enabled FROM `#__externallogin_servers` as a LEFT JOIN #__users AS u ON u.id=a.checked_out LEFT JOIN #__extensions AS e ON `e`.`type`='plugin' AND CONCAT_WS('.', `e`.`folder`, `e`.`element`)=`a`.`plugin` WHERE (a.published >= 0) ORDER BY a.title asc LIMIT 0, 100
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `#__externallogin_servers` as a LEFT JOIN #__users AS u ON u.id=a.checked_out LEFT JOIN #__extensions AS e ON `e`.`type`='plugin' AND CONCAT_WS('.', `e`.`folder`, `e`.`element`)=`a`.`plugin` WHERE (a.published >= 0)

Please advise, Thank you for the plugin.

chdemko commented 8 years ago

I will have a look soon

AshMartian commented 8 years ago

Thank you, I tried changing my sql tables to utf8_unicode_ci and utf8_general_ci with no luck.

flashfs commented 8 years ago

Same problem here after installing External Login with Joomla 3.5.1. Workaround solution: changed fields title, plugin, params from table externallogin_servers to utf8_unicode_ci (it was utf8_general_ci). Example of generated SQL on one field: ALTER TABLE externallogin_servers CHANGE params params TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL

chdemko commented 7 years ago

I've no problem using Joomla!3.6.5

chdemko commented 7 years ago

Could you please try version 3.1.0-rc3