Author Topic: Failed to import database construction. MySQL said: Index column size too large.  (Read 1301 times)

ChristophW

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
- Version 3.4.4.1
- MySql: 5.6.33
- InnoDb
« Last Edit: October 26, 2016, 07:09:06 AM by ChristophW »

koksalbasar

  • Newbie
  • *
  • Posts: 1
    • View Profile
Same problem.

The message came after two tables are created.
fo_administration_tools
fo_dimensions

I deleted the following indexes from ...fengoffice\public\install\installation\templates\sql\mysql_schema.php file; (for the next table : members)
KEY `by_dimension` (`dimension_id`,`parent_member_id`,`name`),
  KEY `by_object_id` (`object_id`),
  KEY `archived_on` (`archived_on`),
  KEY `name` (`name`)

setup is continued until another error message...

Failed to import initial data. MySQL said: Field 'description' doesn't have a default value

My experience is not enough yet to solve these problems...

Is any body have solution?
« Last Edit: November 09, 2016, 06:05:48 PM by koksalbasar »

lemrm

  • Newbie
  • *
  • Posts: 2
    • View Profile
public-install-installation-templates-sql-mysql_schema.php
change Line 46

from

 `name` varchar(511)

to

`name` varchar(200)

you could later change it back in db to latin1_general_cs varchar 511

 

anything