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
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
3 Asked on November 5, 2021 by jafar-pinjar
1 Asked on November 5, 2021
0 Asked on November 5, 2021 by pandurang
2 Asked on November 5, 2021 by afreen-sheikh
0 Asked on November 5, 2021
0 Asked on November 5, 2021
1 Asked on November 5, 2021 by user12398926
0 Asked on October 2, 2021 by david-young
1 Asked on October 2, 2021 by jykmhar123
3 Asked on October 2, 2021
0 Asked on October 2, 2021
0 Asked on October 2, 2021 by saurabh-garg
1 Asked on October 2, 2021 by fernandus
0 Asked on October 2, 2021 by chequille
1 Asked on October 2, 2021 by goose84
custom attributes customer customer attribute frontend label magento2
Get help from others!
Recent Questions
Recent Answers
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP