Skip to main content
edited body
Source Link
ManiMaran A
  • 1.1k
  • 12
  • 12

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name CHANGEMODIFY column_name VARCHAR(10);

Note: Update only magento table if you have the result using search query not other mysql table.

Try this, thumps up.

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name CHANGE column_name VARCHAR(10);

Note: Update only magento table if you have the result using search query not other mysql table.

Try this, thumps up.

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name MODIFY column_name VARCHAR(10);

Note: Update only magento table if you have the result using search query not other mysql table.

Try this, thumps up.

added 102 characters in body
Source Link
ManiMaran A
  • 1.1k
  • 12
  • 12

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name CHANGE column_name VARCHAR(10);

Note: Update only magento table if you have the result using search query not other mysql table.

Try this, thumps up.

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name CHANGE column_name VARCHAR(10);

Try this, thumps up.

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name CHANGE column_name VARCHAR(10);

Note: Update only magento table if you have the result using search query not other mysql table.

Try this, thumps up.

Source Link
ManiMaran A
  • 1.1k
  • 12
  • 12

No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';

Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.

Eg: ALTER TABLE table_name CHANGE column_name VARCHAR(10);

Try this, thumps up.