magento 2.3.4 installation issue in localhost

Magento Asked by GGC on January 2, 2022

Actually I have tried to install magento 2.3.4 using bitnami lampstack-7.2. I got an installation error at 3% itself like this

[ERROR] MagentoFrameworkSetupException: Unable to apply patch MagentoCatalogSetupPatchSchemaEnableSegmentation for module Magento_Catalog. Original exception message: Invalid column data type “”

Couldnot downgrade MYSQL server version in lampstack for the version of 5.7. Can anyone suggest me the solution?

Thanks in advance

One Answer

please use the below solution


line 1846

after line

case 'smallint':


case 'smallint unsigned':

and after line

case 'int':


case 'int unsigned':

or full method code

protected function _getColumnTypeByDdl($column)
        switch ($column['DATA_TYPE']) {
            case 'bool':
                return Table::TYPE_BOOLEAN;
            case 'tinytext':
            case 'char':
            case 'varchar':
            case 'text':
            case 'mediumtext':
            case 'longtext':
                return Table::TYPE_TEXT;
            case 'blob':
            case 'mediumblob':
            case 'longblob':
                return Table::TYPE_BLOB;
            case 'tinyint':
            case 'smallint':
            case 'smallint unsigned':
                return Table::TYPE_SMALLINT;
            case 'mediumint':
            case 'int':
            case 'int unsigned':
                return Table::TYPE_INTEGER;
            case 'bigint':
                return Table::TYPE_BIGINT;
            case 'datetime':
                return Table::TYPE_DATETIME;
            case 'timestamp':
                return Table::TYPE_TIMESTAMP;
            case 'date':
                return Table::TYPE_DATE;
            case 'float':
                return Table::TYPE_FLOAT;
            case 'decimal':
            case 'numeric':
                return Table::TYPE_DECIMAL;

This worked for me. Hope this works for you as well, Thank You.

Answered by Smita Kagwade on January 2, 2022

Add your own answers!

Related Questions

Remove Duplicate product Images in Magento 2

3  Asked on November 5, 2021 by jafar-pinjar


Add checkbox to toggle custom fee to checkout

0  Asked on November 5, 2021 by coinhndp


Magento 2.3 How add additional links in tag ?

0  Asked on October 2, 2021 by david-young


magento 2 Addtocart success message

0  Asked on October 2, 2021 by kanidhaya


wishlist not working for guest user in magento 2?

1  Asked on October 2, 2021 by jykmhar123


How get item in HTMLCollection?

0  Asked on October 2, 2021


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP