Categories
View Replies (11)

Resolved Virtuemart product import fails

  1. gtcnetworking
    gtcnetworking
  2. RO CSVI
  3. Tuesday, 09 August 2022
  4.  Subscribe via email
Hi I have a problem that has just occurred that I cannot seem to resolve.
I have been using CSVI for some time, to import data into Virtuemart without any problem.
I had a development site sit up for a client and the product import works fine on it.
I did a backup of the site and copied it to the "live" site, in preparation for going live.

But now the product import fails immediately with a error that says just that - Error without details (see attached)

It is the same version of Joomla and Virtuemart as the development site.
It is the same physical server with the same PHP version and settings (PHP 7.4)
I have updated CSVI to the latest version (8.3.1) but the error remains.

I have tried checking database fields, clearing tasks, checking joomla tables, folder permissions.

There are no errors in the web server logs. and CSVI records no errors.(log attached)
Any idea please.

Thanks
Attachments (2)
error.png error.png
com_csvi.log.2.zip
0
Accepted Answer
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

SO is it in the template ?
No, template does not store URLs. What is happening is that RO CSVI is asking Joomla for the URL and Joomla returns http://www.nsoffice.au Do you happen to have the $live_site variable set in your configuration.php?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
It is the same version of Joomla and Virtuemart as the development site.
It is the same physical server with the same PHP version and settings (PHP 7.4)
I have updated CSVI to the latest version (8.3.1) but the error remains.

Template and Import file are also the same?

There are no errors in the web server logs. and CSVI records no errors.(log attached)
Any idea please.

There is no details on the error in the screenshot so it is difficult to find the cause and fix for it. Try to turn on error reporting from System -> Global Configuration from Server tab and run the import. Set error reporting to Maximum and see if you get details on the error. If not send me the template XML file and import file to check. To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
Hi Sorry for delay in replying.
I have spent some time comparing the development site (where the import works)
and the "live" site (where it does not)
The live site was a complete backup of the dev site, so tables and templates are the same.
Attached are the templates from both sites. They look the same.
Also the testplu file I am using. It imports without error in the dev site - Fails in the live site.

I tried turning joomla error reporting on. There is no change to the error I sent before. No more detail

I thought it may have something to do with Virtuemart and reloaded that.
Also manually dropped the categories and product tables and imported them from the dev site.
No change

Very odd - any bright ideas?
Attachments (3)
csvi_templates_nsoffice.com.au_20220813.xml
csvi_templates_nsoffice.custwork.gingertomcat.com_20220813-this one works on development site.xml
plu_test.csv
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Could you please check the Using Developer Tools to analyze problems document and see if you can find some additional info when running the import instead of just the popup with the word error.

I checked the debug log but yes, no info there either because the import does not even start. Do you get a preview or not either?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
Hi That gave us some more information.
But what does it mean ?

JQMIGRATE: Migrate is installed, version 1.4.1 jquery-migrate.min.js:2:552
Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://www.nsoffice.au/administrator/components/com_csvi/rantai/rantai.php?task=import&runId=172&_=1660439185722. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 301.

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://www.nsoffice.au/administrator/components/com_csvi/rantai/rantai.php?task=import&runId=172&_=1660439185722. (Reason: CORS request did not succeed). Status code: (null).

​
see attached
Attachments (2)
Untitled.png Untitled.png
Untitled-1.png Untitled-1.png
  1. more than a month ago
  2. RO CSVI
  3. # 4
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
More---
If I understand this correctly - there is some remnant of the development site addressing somewhere
and when it tries to upload to the "live" site it is using the old information.
Yes ?
  1. more than a month ago
  2. RO CSVI
  3. # 5
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
I see the problem now
It is trying to use a link for http://www.nsoffice.au which a web alias for the actual site address of
http://www.nsoffice.com.au
So where is it finding the nsoffice.au from ?
  1. more than a month ago
  2. RO CSVI
  3. # 6
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
I removed the alias to the other address.
Now when I click on RUN for the template it fails becuase it is switching to nsoffice.au
So how did CSIvV find the alias ?
And how do I remove it
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

You can check the global options by going to Components -> RO CVSI and in the top right corner click on Options. This is where you can set your domain name, I think that is where this is coming from. You can change the domain name, save the changes and try your import again.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
Hi
No I already checked options. It is the correct domain
I also checked all the Joomla domain settings as well.
I cannot find any mention of the alias anywhere, yet it IS saved somewhere
CSVI now works until I click on RUN then it fails looking for the wrong domain.
SO is it in the template ?
  1. more than a month ago
  2. RO CSVI
  3. # 9
gtcnetworking
gtcnetworking
Accepted Answer Pending Moderation
That was it. The live site variable
Fixed
Thank you for all your help
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!