Magento Product import error - SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null

magento

Solution

There is a value missing in "_media_attribute_id"

check all column and insert "88" where it is missing.

It solved my problem

Problem

I am having an issue uploading a large csv of products. It goes through the check on then after then import says: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_id’ cannot be null After this has done I have checked the products page and they are all there but do not seem to be in the categories, do not show in search and even if I manually enable the categories do not show. Any ideas? Really stuck!

Original source