Help for Aimeos

1/ When running aimeos:setup
2/ When I try to see an order detail in admin panel :
3/ When aimeos tries to duplicate a product (only when the product existed before the update), the image typeid of the product is null:

An exception occurred while executing ' INSERT INTO "mshop_media" ( "langid", "typeid", "label", "mimetype", "link", "status", "domain", "preview", "mtime", "editor", "siteid", "ctime" ) VALUES ( NULL, NULL, ... ) ': SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'typeid' cannot be null

What can I do?

The solution I found for 1/ is to remove users_address table (but data is lost!)

For 2/ i can now reach a detailed view of the orders but curiously the link for the order is not correct :
i.e. for order 260, the href is : https://myproject/admin/default/jqadm/get/order/265
How can it be explained?

Thank you !

sixbynine wrote:The solution I found for 1/ is to remove users_address table (but data is lost!)

You had records in your users_address table that had no releation to the users table any more. We added that constraint so there will be no more dangling address (and also list) records in the future if you delete an user. A migration task that deletes the dangling records might be helpful in this case ...

sixbynine wrote:For 2/ i can now reach a detailed view of the orders but curiously the link for the order is not correct : i.e. for order 260, the href is : https://myproject/admin/default/jqadm/get/order/265

What was the problem why you got an exception?
There are two order related IDs, the invoice ID from mshop_order (260) and the basket ID from mshop_order_base (265). They may differ if you have more records in one table than in the other.

Can you investigate why the type ID for the images is NULL in that case?

aimeos wrote:

sixbynine wrote:The solution I found for 1/ is to remove users_address table (but data is lost!)

You had records in your users_address table that had no releation to the users table any more. We added that constraint so there will be no more dangling address (and also list) records in the future if you delete an user. A migration task that deletes the dangling records might be helpful in this case ...

Ok ! Sorry ! I did not understand it was a new foreign constraint working in that way. So, it's perfect

sixbynine wrote:For 2/ i can now reach a detailed view of the orders but curiously the link for the order is not correct : i.e. for order 260, the href is : https://myproject/admin/default/jqadm/get/order/265

What was the problem why you got an exception?

I'm not sure about the reason I got this exception, could it be related to the product stock plugin?
Because, I have a custom one and I think aimeos:setup re-enabled the original one.

There are two order related IDs, the invoice ID from mshop_order (260) and the basket ID from mshop_order_base (265). They may differ if you have more records in one table than in the other.

Ok, i'll check that too

Can you investigate why the type ID for the images is NULL in that case?

I'll check it... I noticed in the previous Aimeos version that sometimes when I duplicated a selection product, the image was suddenly lost. I lost a few images that way and it is maybe related to it.

Thank you a lot a lot.

We've added a setup task that removes the left over user address and list entries first before the contraint is added. Thus, the first problem shouldn't occur any more.

Thank you very much !

For the "typeid" problem,

-----------------------------2484765858301
Content-Disposition: form-data; name="'image[idx][media.typeid]'.replace( 'idx', idx )"

2

Yes, this was the problem and a new release is already available. Please run "composer update"

Thank you very much !