Upgrade from 18.10.11 to 22.7.1

[aimeos]

But there are some users missing again in the backend.
Also the entries in fe_users_address are away of these users.

Do they have a site ID of "" (empty string) or NULL again?
Did you upgrade from your 18.10 database structure or from an already upgraded one?

[Moritz]

Sorry it was my fault.
I didn't upgrade from my 18.10 database structure.
Now the users are in the list.

But I saw no order in frontend for my user.

user_orders.png (57.77 KiB) Viewed 1586 times

In the template file of the order history no orders are found for this user.

no_history.png (38.36 KiB) Viewed 1586 times

[Moritz]

And how is it about the catalog filter tree?
I see you have made some modifications there "aimeos_22.10.1-pre2\Resources\Libraries\aimeos\ai-client-html\templates\client\html\catalog\filter\tree-partial.php".
The basis of my style changes was on v22.7.3-pre7.
Now the tree isn't display correct anymore.
Are these modifications also done in the next official version and does more modifications on templates planed?
I don't want to change my styles every version

[aimeos]

Did you check if fe_users.uid is the same as mshop_order_base.customerid?

[Moritz]

Yes.

fe_users.png (19.1 KiB) Viewed 1583 times

mshop_oser_base.png (46.18 KiB) Viewed 1583 times

[aimeos]

Is the site ID different?

[Moritz]

The site ID of users and orders are the same.
Or do you mean another one?

[Moritz]

I've downgrade to v22.7.3-pre7 and execute the upgrade wizard on my old database structure from v18.10.11.
In this case the user can see his order history.

[aimeos]

Can you please enable debug logging of the executed SQL statements to check why that happens?

[Moritz]

The problem is that I do not know the reason why the orders are not displayed.
Due to this ignorance, I also don't know where to investigate.

I can provide you with the results of the upgrade wizard. Debug logging should be enabled there.
DB was v18.10.11 and Aimeos v22.10.1-pre2.

SQLs_upgrade_wizard.zip

(12.41 KiB) Downloaded 96 times

And here a question from some posts before
Have you an explanation why die category filter are not always expanded anymore?
Before experimenting with v22.10.1-pre2 the full filter tree was shown...