AnswerBun.com

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

vendor/magento/framework/DB/Adapter/Pdo/Mysql.php

line 1846

after line

case 'smallint':

add

case 'smallint unsigned':

and after line

case 'int':

add

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 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP