Jump to content

upgrade 1.0.0.8 to 1.2.4.0 SQL error


Recommended Posts

I update directly from 1.0.0.8 to 1.2.4.0, upgrade is ending with 1 error

INSERT INTO ps_product_attribute_image (id_image, id_product_attribute) (SELECT id_image, id_product_attribute FROM ps_product_attribute)

(1048) Column 'id_image' cannot be null

Link to comment
Share on other sites

You need to make sure your original database is fine.
ps_product_attribute have a field named id_image.
If one of the record filled with null, you need to track it.
Either delete the false product or re-upload the image file.


yes you are right, but shop in both version is displaying images ok
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...