×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
JInstaller: :Install: Error SQL DB function failed with error number 1273
Rachel Greig
New Member
Posts: 1
pred 6 rokmi 6 mesiacmi #1799
od Rachel Greig
JInstaller: :Install: Error SQL DB function failed with error number 1273 bolo vytvorené Rachel Greig
Hello, I have just created my first component but I am having issues installing it I get the message:
JInstaller: :Install: Error SQL DB function failed with error number 1273
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE IF NOT EXISTS `jos_rsscontact_` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `companyname` VARCHAR(255) NOT NULL , `department` VARCHAR(255) NOT NULL , `email` VARCHAR(255) NOT NULL , `gdprconsent` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
Could anyone tell me where I am going wrong?
Thanks
JInstaller: :Install: Error SQL DB function failed with error number 1273
Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE IF NOT EXISTS `jos_rsscontact_` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `companyname` VARCHAR(255) NOT NULL , `department` VARCHAR(255) NOT NULL , `email` VARCHAR(255) NOT NULL , `gdprconsent` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
Could anyone tell me where I am going wrong?
Thanks
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
David Vargas
New Member
Posts: 17
pred 6 rokmi 6 mesiacmi #1800
od David Vargas
Odpoveď od David Vargas na tému JInstaller: :Install: Error SQL DB function failed with error number 1273
Hi Rachel,
It's hard to determine the cause of the error without any further information. Anyway, this might help you, please check it: stackoverflow.com/questions/29916610/127...b4-unicode-ci-cpanel
Best regards,
David.
It's hard to determine the cause of the error without any further information. Anyway, this might help you, please check it: stackoverflow.com/questions/29916610/127...b4-unicode-ci-cpanel
Best regards,
David.
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Čas vytvorenia stránky: 0.052 sekúnd