×
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ånader sedan #1799
av Rachel Greig
JInstaller: :Install: Error SQL DB function failed with error number 1273 skapades 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
Be Logga in eller Skapa ett konto ansluta till konversationen.
David Vargas
New Member
Posts: 17
6 år 6 månader sedan #1800
av David Vargas
Svar från David Vargas i ämnet 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.
Be Logga in eller Skapa ett konto ansluta till konversationen.
Sidan laddades på: 0.048 sekunder