×
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
6 Anni 5 Mesi fa #1799
da Rachel Greig
JInstaller: :Install: Error SQL DB function failed with error number 1273 è stato creato da 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
Si prega Accedi o Crea un account a partecipare alla conversazione.
David Vargas
New Member
Posts: 17
6 Anni 5 Mesi fa #1800
da David Vargas
Risposta da David Vargas al topic 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.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Tempo creazione pagina: 0.082 secondi