Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Hi, when proceeding to checkout we are experiencing that with any payment method the checkout button gets stuck processing the payment and it is not possible to complete purchases. Test URL: https://tienda.studyplan.es/realizar-pedido
We would appreciate your help in resolving this issue.
Best regards,
Pilar
Hello Pilar,
is this a store you have updated from Joomla 3? If so, could you send us a copy of the j2store database table structures (no data)?
Olivier.
Hi, Oliver.
Yes, it's an updated Joomla 3 store.
I'm sending you the tables you requested.
If you need anything else, don't hesitate to let me know.
Thank you very much and best regards,
Pilar.
I'm sending you the file again, as there was an error before.
Thanks Pilar,
it looks like the j2store_addresses table has an extra column that is not used anymore
vm_userinfo_idOlivier.
Hi Olivier, could you give me a bit more guidance on how to disable the unnecessary Bootstrap versions? I can't seem to fix the issue to complete the purchase. I've left only one payment method, by bank transfer.
I think there's a problem with the shopper custom fields; I try to save and nothing happens. Is it possible that, to complete the purchase, it's detecting a field that isn't being correctly registered when the user was created before the migration?
Best regards,
Pilar
Alright, I managed to fix the issue with the custom fields by deleting the column you mentioned from the vm_userinfo_id table, but the "complete purchase" button still hangs while trying to process the order.
Hello,
Thank you for your support so far regarding this issue. Although the ticket has already been addressed, the problem is still pending resolution, and we would like to kindly request your urgent attention, as this is the final step we need to complete before launching the website.
We have the original site running on Joomla 3 on a test server, and we’ve verified that this issue does not occur there.
The problem happens with all payment methods, not just with bank transfer. We haven’t been able to identify the source of the issue and would really appreciate your help in resolving it.
Best regards,
Pilar,
The reason none of the payment options are working properly is because the order information is not being passed to the payment processor. The fact that it affected all of the payment plugins was a clue that it wasn't the payment plugin itself, rather something that would affect all of them. I checked the database and while I am sure there could be more than just these two tables affected - the following tables have additional fields that were added from the VM to J2 migration component (from the Joomla 3 site). The reason it still works in J3 is due to the newer database parameters in Joomla 4/5 and since those fields are still using older J3 database settings (which are not set to NULL), the orders are not saving since there's an extra field in the table that is not saving anything at all.
The following fields in the two tables I looked into need to be removed first on your end in order to continue testing...
#__j2store_orders (order_vm_id)
#__j2store_orderitems (vm_orderitem_id)
on my test server, I can see the order is now saving correctly in the database (after removing those two fields) however the order amount is still not properly passing so most likely there are other affected tables. If you can send me the J3 extension that converts from Virtuemart to J2 - I can use that to see what other tables are affected as well.
Adam
Hi Adam, thank you so much for your great help.
Indeed, there may still be some VM tables left because this website originally started as a Virtuemart and was later migrated to Joomla 3. When you say I should send you a J3 extension, are you referring to the original website that had Virtuemart or the one currently running Joomla 3 with J2Store? We no longer have the first one, but we do have the second, although it's 140MB in size. Let me know how I can send it to you or if I can send you a private download link.
Best regards,
Pilar.
I believe the migration was done using J2Store's own app for migrating from Virtuemart.
Pilar,
You should be able to send the file to support@j2commerce.com through a site like WeTransfer.
Olivier.
I’ve just sent you the copy via Wetransfer. I also wanted to let you know that I’ve removed the fields from the tables you mentioned, and I was already able to complete a purchase using bank transfer and test another one to see if it connects with PayPal — both worked without any issues.
Pilar,
That is great news. I was about to load the J3 version of the site you sent me, but it looks like we have resolved this issue for you :)
While we have rebuilt many of older J2Store Joomla 3 apps. there are a few that we were never able to get our hands on - the VM to J2 migration extension happened to be one of them so it was hard to figure out the cause at first, but once I saw the same issue affecting all the payment plugins, I realized it was most likely a database issue. Glad to have helped and great looking site!
I will also be at Joomla Day Spain this November so I hope we get a chance to meet in person :)
Adam
