· 7 years ago · Nov 29, 2018, 09:24 AM
1SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'created_in' used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat` (
2 `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' ,
3 `name` text NULL COMMENT 'Name' ,
4 `email` varchar(255) NULL COMMENT 'Email' ,
5 `group_id` int NULL COMMENT 'Group_id' ,
6 `created_at` timestamp NULL default NULL COMMENT 'Created_at' ,
7 `website_id` int NULL COMMENT 'Website_id' ,
8 `confirmation` varchar(255) NULL COMMENT 'Confirmation' ,
9 `created_in` text NULL COMMENT 'Created_in' ,
10 `dob` date NULL COMMENT 'Dob' ,
11 `gender` int NULL COMMENT 'Gender' ,
12 `taxvat` varchar(255) NULL COMMENT 'Taxvat' ,
13 `lock_expires` timestamp NULL default NULL COMMENT 'Lock_expires' ,
14 `shipping_full` text NULL COMMENT 'Shipping_full' ,
15 `billing_full` text NULL COMMENT 'Billing_full' ,
16 `billing_firstname` varchar(255) NULL COMMENT 'Billing