CODEWITHSUNDEEP
mysqlsqldatabasemagentomagento-1.9
Vipin
Vipin

Reputation: 1

Column not found: 1054 Unknown column '`default`' in 'where clause', query was: SELECT `main_table`.* FROM `fastimporter_attributes`

I am getting below error on magento1.9, How can I solve this one.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'default' in 'where clause', query was: SELECT main_table.* FROM fastimporter_attributes AS main_table WHERE (profile_id = '8') AND (default IS NOT NULL)

Upvotes: 0

Views: 966

Answers (1)

Mage Wet
Mage Wet

Reputation: 186

Please use this command:

SELECT main_table.* FROM fastimporter_attributes AS main_table WHERE (profile_id = '8') AND (main_table.default IS NOT NULL)

The "default" field is quite sensitive in this case, I think you should use main_table.default

Upvotes: 1

Related Questions