This is the issue I face on indexing from terminal.

column 'created_in' used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat`

enter image description here

Kindly help me to fix this.

  • Does the customer_grid_flat exist in your database? if not use the rest of the error to create it – Dava Gordon Sep 10 '19 at 11:35
  • @Dava customer_grid_flat doesn't exist. Tried the above query in phpmyadmin, throws 2 issues. 1-Unrecognized data type. (near "FTI_AC9FBFAE9FBD3A0B02DBA986349612A6" at position 2053) and 2- #1170 - BLOB/TEXT column 'created_in' used in key specification without a key length – Ejilarasan J Sep 10 '19 at 11:38
  • Your version of Mysql/MariaDB/Phpmyadmin are out of date they do not have the new data types you need to upgrade these so they can support FULLTEXT as a valid data type – Dava Gordon Sep 10 '19 at 11:49
  • Now, changed the datatype of 'created_in' from text to varchar(255) the query works fine. Then after indexing the customer_grid from the terminal, the same issue exists. – Ejilarasan J Sep 10 '19 at 11:51
  • You will continue to have issues as there are quite a lot of new data types used in 2.3 as stated in my previous comment i would recommend upgrading your database software which should allow you to run without any issues – Dava Gordon Sep 10 '19 at 11:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.