Can’t install Hikashop Starter 5.0- Error installing component

-- HikaShop version -- : 5.0
-- Joomla version -- : 4.3.4
-- PHP version -- : 8.2
-- Browser(s) name and version -- : chrome 17.0.5938.132
-- Error-message(debug-mod must be tuned on) -- : Warning: Illegal mix of collations (utf8mb3_general_ci, IMPLICIT) and (utf8mb3)unicode)ci, IMPLICIT) for operation ‘=‘
Error installing component

Got this message when trying to install Hikashop Starter 5.0.

Warning: Illegal mix of collations (utf8mb3_general_ci, IMPLICIT) and (utf8mb3)unicode)ci, IMPLICIT) for operation ‘=‘
Error installing component

Only database tables was created and the Hikashop extension in administer folder.

I droped all the Hikashop tables from the DB and tried to uninstall the extension to do a clean install from the ftp as suggested in some articles.

Got an error with a message saying: can’t uninstall, please remove manually. I checked in all the folders listed in the message and no com_hikashop exist there but Joomla still show the extension.

I decided to manually created these com_hikashop folders and redo the Extension uninstall process. Joomla removed all the folders but I got a new message like din’t find Filesetup.XML.

Finally I moved forward with the FTP installation with exactly the same result

Warning: Illegal mix of collations (utf8mb3_general_ci, IMPLICIT) and (utf8mb3)unicode)ci, IMPLICIT) for operation ‘=‘
Error installing component

I don’t know what else to do to try to fix this issue. If somebody have an idea, you’re welcome.

Hi Nicolas,

First thanks for your help. it is really appreciate.

1- Using PHP MyAdmin I remove all traces of the old installation.

2- I change the code line in ExecutionFailureException.php
public function __construct($query, $message = '', $code = 0, \Exception $previous = null)
{
// PDO uses strings for exception codes, PHP forces numeric codes, so "force" the string code to be used
parent::__construct($message.' '.$query, 0, $previous);

3- I relaunch the installation process from FTP folder with exactly the same result. No change same message without additional information about the error.

So we are at the same place.

I read an old post about the illegal mix of collation where you suggest to make sure that the hikashop_user table or the users table of Joomla have the same charset. Maybe I can start with that to eliminate this warning.

I just checked My database and All the tables including the ones Hikashop created have utf8mb3_general_ci charset except 8 tables including 4 from Akeebabackup that use utf8mb4_unicode_ci. Furthermore, the server connection collation charset is set to utf8mb4_unicode_ci. Nothing about utf8mb3_unicode_ci Charset from the conflict message!!!!

Do I have to change something on these?

Hi Nicolas,

Problem solved. You were right, the Joomla user table contained few columns with collation utf8mb3_unicode_ci. I changed them to utf8mb3_general_ci and proceed to Hikashop installation with no problem.

Thank you so much for your help.