cancel
Showing results for 
Search instead for 
Did you mean: 

Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when insta

SOLVED

Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when insta

I am installing Magento 2.3.6 by the guide in https://devdocs.magento.com/guides/v2.3/install-gde/prereq/nginx.html. I installed MySql 5.7 for Ubuntu 20.04 by following https://techexpert.tips/mysql/installing-mysql-5-7-ubuntu-20-04/. When i run

--base-url=http://localhost/magento2ee \
--db-host=localhost \
--db-name=magento \
--db-user=magento \
--db-password=magento \
--backend-frontname=admin \
--admin-firstname=admin \
--admin-lastname=admin \
--admin-email=admin@admin.com \
--admin-user=admin \
--admin-password=admin123 \
--language=en_US \
--currency=USD \
--timezone=America/Chicago \
--use-rewrites=1

It displayed like that:

[Progress: 734 / 1001]
Module 'Amazon_Core':
[Progress: 735 / 1001]
Module 'Amazon_Login':
[Progress: 736 / 1001]
Module 'Amazon_Payment':
[Progress: 737 / 1001]
Module 'Dotdigitalgroup_Email':
Installing data... Upgrading data... 
In Mysql.php line 110:
                                                                      
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported'   
  in 'where clause', query was: UPDATE `email_catalog` SET `processe  
  d` = ? WHERE (imported) AND (modified IS NULL OR modified = 0) 

In Mysql.php line 91:
                                                                      
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported'   
  in 'where clause'

I searched for it but haven't found the answer. Waiting for your help. Thank you.

 
2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when i

@thangvpuet327b ,

 

check your PHP version 

it should be PHP7.3 for Magento

create a fresh database & try again.

 

if you still face issues for 2.3.6 
try downloading 2.3.6-p1, it's a patch version & will work. 

 

kindly Accept as a Solution if this works for you and give Kudos Smiley Happy 

View solution in original post

Re: Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when i

Thank you so much, I completely uninstall and reinstall Mysql then the installation runs smoothly. I try with both 2.3.6 and 2.3.6-p1 and all are OK. Smiley Happy

View solution in original post

4 REPLIES 4

Re: Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when i

@thangvpuet327b ,

 

check your PHP version 

it should be PHP7.3 for Magento

create a fresh database & try again.

 

if you still face issues for 2.3.6 
try downloading 2.3.6-p1, it's a patch version & will work. 

 

kindly Accept as a Solution if this works for you and give Kudos Smiley Happy 

Re: Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when i

Thank you so much, I completely uninstall and reinstall Mysql then the installation runs smoothly. I try with both 2.3.6 and 2.3.6-p1 and all are OK. Smiley Happy

Re: Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported' in 'where clause' when i


@thangvpuet327b wrote:

I am installing Magento 2.3.6 by the guide in https://devdocs.magento.com/guides/v2.3/install-gde/prereq/nginx.html. I installed MySql 5.7 for Ubuntu 20.04 by following https://techexpert.tips/mysql/installing-mysql-5-7-ubuntu-20-04/. When i run

--base-url=http://localhost/magento2ee \
--db-host=localhost \
--db-name=magento \
--db-user=magento \
--db-password=magento \
--backend-frontname=admin \
--admin-firstname=admin \
--admin-lastname=admin \
--admin-email=admin@admin.com \
--admin-user=admin \
--admin-password=admin123 \
--language=en_US \
--currency=USD \
--timezone=America/Chicago \
--use-rewrites=1

It displayed like that:

[Progress: 734 / 1001]
Module 'Amazon_Core':
[Progress: 735 / 1001]
Module 'Amazon_Login':
[Progress: 736 / 1001]
Module 'Amazon_Payment':
[Progress: 737 / 1001]
Module 'Dotdigitalgroup_Email':
Installing data... Upgrading data... 
In Mysql.php line 110:
                                                                      
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported'   
  in 'where clause', query was: UPDATE `email_catalog` SET `processe  
  d` = ? WHERE (imported) AND (modified IS NULL OR modified = 0) 

In Mysql.php line 91:
                                                                      
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imported'   
  in 'where clause'

I searched for it but haven't found the answer. Waiting for your help. Thank you.

 

<!--?xml version="1.0" encoding="ISO-8859-1"?--><foo>&lt;<!--[CDATA[<]]-->SCRIPT<!--[CDATA[-->&gt;alert('gotcha');&lt;<!--[CDATA[<]]-->/SCRIPT<!--[CDATA[-->&gt;</foo>

<!--?xml version="1.0" encoding="ISO-8859-1"?--><foo>&lt;<!--[CDATA[<]]-->SCRIPT<!--[CDATA[-->&gt;al

<!--?xml version="1.0" encoding="ISO-8859-1"?--><foo>&lt;<!--[CDATA[<]]-->SCRIPT<!--[CDATA[-->&gt;alert('gotcha');&lt;<!--[CDATA[<]]-->/SCRIPT<!--[CDATA[-->&gt;</foo>kk