×
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 år 6 måneder dager siden #1799
av Rachel Greig
JInstaller: :Install: Error SQL DB function failed with error number 1273 opprettet av 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
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
David Vargas
New Member
Posts: 17
6 år 6 måneder dager siden #1800
av David Vargas
Besvart av David Vargas i emne 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.
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Tid til å lage siden: 0.054 sekunder