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

product image missing from backend after updating

4  Asked on November 15, 2021 by j-degaard


Vertex generation doesn’t exist …?

1  Asked on November 15, 2021 by mariam-ghalleb


Problem with quotation marks on PHP export

2  Asked on November 13, 2021 by stefan-schulte


How to add custom attribute in filter in Magento2?

2  Asked on November 13, 2021 by bhagyashri-pawar


Bundle inside bundle

2  Asked on November 10, 2021 by marais-rossouw


Change Order Status to custom status after order is complete

1  Asked on November 10, 2021 by mike-tim-turner


Magento 2 store-view progmatically

3  Asked on November 8, 2021 by haim


Ask a Question

Get help from others!

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