×
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 years 6 months ago #1799
by Rachel Greig
JInstaller: :Install: Error SQL DB function failed with error number 1273 was created by 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
Please Log in or Create an account to join the conversation.
David Vargas
New Member
Posts: 17
6 years 6 months ago #1800
by David Vargas
Replied by David Vargas on 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.
Please Log in or Create an account to join the conversation.
Time to create page: 0.053 seconds