Database with UTF8 failure

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
Sonya

Database with UTF8 failure

Post by Sonya »

Hello,

while creating database in uft-8 I've got the error:
Couldn't create table: cms_module_templates
The problem is the key 'module_name' which cannot be created. Probably is the key too large???
CREATE TABLE `cms_module_templates` ( `module_name` varchar(200) default NULL, `template_name` varchar(200) default NULL, `content` text, `create_date` datetime default NULL, `modified_date` datetime default NULL, KEY `module_name` (`module_name`,`template_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
When I delete the key, the table can be created.

Sonya
alby

Re: Database with UTF8 failure

Post by alby »

Sonya wrote: while creating database in uft-8 I've got the error:
Try to lower varchars to 160:
varchar(200)

Alby
Sonya

Re: Database with UTF8 failure

Post by Sonya »

alby wrote:
Try to lower varchars to 160:
varchar(200)

Alby
In this case I am going to have problems installing additional modules later if the module_name or template_name is larger than 160 characters. Correct?
alby

Re: Database with UTF8 failure

Post by alby »

Sonya wrote:
alby wrote:
Try to lower varchars to 160:
varchar(200)

Alby
In this case I am going to have problems installing additional modules later if the module_name or template_name is larger than 160 characters. Correct?
Yes, but module name or template name larger then 160  :o

Alby
Locked

Return to “[locked] Installation, Setup and Upgrade”