Resolved ERROR Frontend

Hello Vladimir,
Thank you for confirming the import is working. This fix will be included in our upcoming RO CSVI release.

Hello Tharuna.
As I can see, the import occurs without errors.
Everything's fine.

Hello,

To be honest, I am surprised by the fact that there are children's products. I created the products in the standard VM way.
And where the children came from is a mystery to me.

Yes and that happens when a translation language is set in VirtueMart.

I saw that you made changes to the template.
and the import is made from a file located on the server. In this case, there are no problems with importing from the backend.

Correct, i wanted to test if setting to another source gets the same error or not.

IMPORT from googlesheet - regularly ends with an error

Thats correct, import from Google sheets ends up with an error. I am finding out the cause for the error with Google sheet import on frontend.

Hello Tharuna.
To be honest, I am surprised by the fact that there are children's products. I created the products in the standard VM way.
And where the children came from is a mystery to me.

I saw that you made changes to the template.
and the import is made from a file located on the server. In this case, there are no problems with importing from the backend.


However, when importing from an external server - for example, Google Tables-the import fails.

now the test site has two menu items:
1) IMPORT from googlesheet
2) IMPORT from the server


IMPORT from googlesheet - regularly ends with an error

Hello Vladimir,
Thank you for posting the site details. I was testing the import and was able to see the error a few times and most of the times import finishes without an error. The first thing i found with import in your site is that the products in VirtueMart don't show correct. See the attached screenshots. It shows 4 children for all products when there is no child products at all. Next thing i see is the ID as 0 for all the 4 products. I clicked on the product to see the details but it shows empty. So i cleaned VirtueMart database using RO CSVI maintenance option. Ran the import again from backend. Checking RO CSVI import debug log shows all 4 products are inserted to English language table and that is because English is the language set in import template. Database also shows the products are in English language table. I am not sure if it is an issue with VirtueMart 3.8.8 version in not loading translation product details.

Then i changed the language to Russian in import template and ran the import. The products are imported to Russian language table and products show correct in VirtueMart. Attached screenshot of that too. In both of these cases with import, i was not able to reproduce the error again on frontend. Since the error happens only sometimes, i am going to keep watching the frontend import so to see if setting up language in template to Russian makes any difference with the error. Would request you to also to test this and let me know if you can see the error again.

Server IP address: 93.125.99.98
SSH port: 22
User name: atestroc
Password: Mae9ie6e

Does that mean the import goes good at first and then with next imports you see the error or import takes so long and then throws the error without finishing?

Hello.
Yes. Several imports go well, and the next ones fail.

Service address for viewing the site:

http://atestroc.vh98.hosterby.com/

admin admin

Hello Vladimir,

The import from the backend passes without problems. The import from the frontend is also easy at first. after half an hour, it returns an error. If you click on the link now, an error will occur.

Does that mean the import goes good at first and then with next imports you see the error or import takes so long and then throws the error without finishing?

http://testrocsvi.by/
log/pas admin/admin

Site does not load for me with the link. See attached screenshot.

If necessary, I can give you access to the C-Panel.

Please send us (S)FTP details and Joomla administrator login details. You can post the details on Site details tab under your reply.

Hello. I created a test site. I took the latest version of VM3 https://dev.virtuemart.net/attachments/1280/VirtueMart3.8.8_Joomla_3.9.24-Stable-Full_Package.zip.
Created the /IMPORT CSVI / menu item.

Follow this link to the import file. Access is shared.
https://docs.google.com/spreadsheets/d/1XLWtnEDcqxlDWgkyPKqd0rH-1mbniL4DdaNH-P35ZIk/edit?usp=sharing


The import from the backend passes without problems. The import from the frontend is also easy at first. after half an hour, it returns an error. If you click on the link now, an error will occur.

But if you go to the backend in the import template, the error from the frontend disappears.


http://testrocsvi.by/
log/pas admin/admin

If necessary, I can give you access to the C-Panel.

Hey Vladimir,

I do not think you need a clean site, but I would like to see a new debug log. The one in the first post only has 1 line in it. Do you have a newer log?

I will create a test site with a clean jumla and virtumart. I'll try to import it. If the error persists, I will give you access. so that you can see it, too.

Yes. always

Hello Vladimir,

Is the error you get always the same?

Call to a member function load() on bool

Hello,

The error is only in the frontend.

Since you are saying error is only on frontend and not on backend there is no problem with the import itself. Something is stopping the import on frontend on your site.

Few things to check

1. Do you have htaccess enabled on your site? Is it the default one which comes with Joomla installation?
2. Do you have Security plugins like Admin tools installed on site? If so check if that is stopping RO CSVI import.
3. Check if other import or export templates works on frontend.

Hello. The error is only in the frontend.
And the error appears only after some time.
And the error appears only after some time.
But as soon as I visit the import template in the backend, it disappears. and the import can be done.

Hello,
There is no problem with the attached import file, Import goes fine both on backend and frontend for me. Does the import work for you with the file on backend? Error is only on frontend?

I'm sorry. I attached the wrong file.

oops

Hello,
The import file you attached, did you try to import it from backend? Did import work for you?

When i run the import from backend i am seeing an error that "No supported fields have been found in the import file". See attached screenshot from import preview page.

Saving file as CSV and import preview page loads without a problem(See attached screenshot). Import goes fine from frontend too.