Virtuemart Order Details missing the rows that include the products ordered.

[hzwicewicz]

I've migrated a Joomla 3 site which was running VM 3.8.8 up to Joomla 4 running VM 4.4.10 - I've done this on a backup installed on a subdomain. When I updated to VM 4.4.10, I installed the latest version as opposed to using the Joomla extension updater. There is a membership associated with the subdomain where I'm developing the site, and the VM version installed came from the my downloads section. Other info: I'm using the SMART VirtuePlanet template and the VP One Page checkout extension - both are up to date. After migrating, I moved the subdomain up to PHP 8.2.

On the front-end, the migration appears to have gone well. However when I tested placing an order, I noticed the invoice that was emailed was missing the rows that include the details of the products ordered (SKU, Product Description etc).

In the back-end, when you open the Order, the products ordered are also missing in the 'Ordered Products' section. I've attached a screenshot that shows what details are/are not included. 

The orders that were placed before I updated to Joomla 4 and VM 4.4.10 all include the Ordered Products info. So it appears that since the update, the details of the products ordered is not ending up where it should be.

I did try assigning the Cassiopeia template and then placed an order but got the same result. So it's not the template.

One more thing to mention, after I click the 'check out' button, the order processed but a warning 'vmTable store insertObject'appeared. Not sure if that's related to the problem I'm experiencing.

[hzwicewicz]

More details to include on this issue.

I started from scratch again with a backup of my Joomla 3.10.12 site, running VM 3.8.8
I updated all installed extensions including VirtueMart which brought it up from version 3.8.8 to version 4.4.10. Then, before migrating up to Joomla 4 I tested placing an order. Everything worked perfectly. My invoice included the order details of each product ordered, and on the front-end and in the back-end, the products ordered for my test order also appear.

Then I migrated up to Joomla 4 and again placed an order.
The list of products ordered was missing from the invoice, and if you open the order in the back-end, there's no list of items ordered either. I've attached a screenshot of the back-end view of the order for reference.

So this is an issue that occurs AFTER migrating up to Joomla 4. In the Joomla 3 environment, VM 4.4.10 was working exactly as you'd expect. After migrating up to Joomla 4, the described issue appears.

[PRO]

ok, sounds like plugin, or override messing this up.


ALSO: make sure to keep a copy of the database.
Sometimes to ghet your old data, you can just migrate the old database

ALSO, WHAT I HAVE ALWAYS DONE IS, for big updates.
I get a working blank site of vmart, and the new joomla.
THEN, i move over the data. Then start working on templates and overrides.