1. Donnerflug
  2. RO CSVI
  3. Friday, 19 May 2017
  4.  Subscribe via email
Hello Tharuna,

made some more tests and all works fine! Thank you!

By the way I found another issue. Orders of guest shoppers are stored in the _virtuemart_orders table with user-id=0. When trying to import the order state of a finalized order it comes a note "Cannot process user, no user ID found" - because the id is 0.

<?xml version="1.0" encoding="UTF-8" ?>
<orderstatuses>
<orderstatus>
<Order_id>76</Order_id>
<Order_User_Id>0</Order_User_Id>
<Order_Status>F</Order_Status>
<Order_Status_Code>F</Order_Status_Code>
</orderstatus>
</orderstatuses>

How can I solve this?

Kind regards,

Teresa
Accepted Answer Pending Moderation
Hello Teresa,

That is a special case I actually didn't think about. I will have to take a look what needs to be done for these users, they are going to need some special treatment. Are you running 7.2.0 now?
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. # 1
Accepted Answer Pending Moderation
Hello Roland,

yes, 7.2.0 is running on test site.

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Teresa,

Attached is a patch file that allows to update orders for guest users using CSVI 7.2.0. Can you give it a try and let me know if it works for you as well? I have used the example XML you posted as an example to test with.
Attachments (1)
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
Accepted Answer Pending Moderation
Hello Roland,

sorry for the delayed response and thanks for the patch! I tried it, preview is OK, however it comes an error regardless of guest order or registered users:

An error has occured during the import. Below the information received from the server.
Status error: 0
Status message: error

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Teresa,
Just to confirm again, you ran the patch on CSVI 7.2.0 version?
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. # 5
Accepted Answer Pending Moderation
Hello Tharuna,

of course running on 7.2.0 version on Joomla 3.7.2 and VM 3.2.2 by using the CSVI_packages.zip you sent on 20.05.2017 and attached patchfile!

Kind regards,

Teresa
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Tharuna,

tried anothother import for products in stock and the import fails too with this error:

An error has occured during the import. Below the information received from the server.
Status error: 0
Status message: error

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Teresa,
The issue is imports just say us that there is an error but don't know what. We should know what the error is so to fix it. To find that can you check your server logs and see if there is any log for these error?

You can also try running the import by turning on error reporting in Joomla under System -> Global Configuration -> Server -> Error Reporting -> Development.
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. # 8
Accepted Answer Pending Moderation
Hello Tharuna,

turning on error reporting gives no more output as above.

the last entries in error.log are:

[Tue May 30 20:43:20.267900 2017] [fcgid:warn] [pid 19062] (32)Broken pipe: [client 80.248.225.168:53702] mod_fcgid: ap_pass_brigade failed in handle_request_ipc function
[Tue May 30 22:20:20.457112 2017] [core:error] [pid 26321] [client 58.18.131.28:26871] AH00126: Invalid URI in request GET login.cgi HTTP/1.0
[Wed May 31 05:09:33.258806 2017] [core:error] [pid 22099] [client 2.28.249.193:58142] AH00126: Invalid URI in request GET login.cgi HTTP/1.0

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Teresa,
Thank you but those logs are not related to the issue. From what i can think of is that something is blocking CSVI from sending the request and so there is no error code but it is 0. Can you check if there is any firewall extension which is blocking CSVI and whitelist it? Can you also check your htaccess 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. # 10
Accepted Answer Pending Moderation
Hello Tharuna,

there is definitevely no firewall or extension which blocks CSVI.

But I played a bit around and I believe there is perhaps a difference between the 7.2.0 on test.sektkellerei.de and the fresh installed on my new test site with your second, fixed version of CSVI 7.2.0.

On test.sektkellerei.de all imports including the guest order status are working fine! The only difference between the two Joomla installations is Joomla 3.7.1 (works) and Joomla 3.7.2. Both are on the same server.

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Teresa,

That is very odd, I am quite sure I am running 3.7.2 as well but going to take another look. What is odd is that on this particular installation all imports fail. If this would be an issue with CSVI, everybody on 3.7.2 should have this problem and we haven't received any other reports.

Nothing new comes up in the error log when you run the import? I also do not think that the last lines from the error log are related because the request talks about login.cgi.

I guess the next step would be to see if an update is done from 3.7.1. to 3.7.2 on the site that works if it still works after that. The last thing that would be good to see as well is the full response from the server. On how to check that we have explained this in the Using Firebug to analyze problems document.
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. # 12
Accepted Answer Pending Moderation
Hello Roland,

here the the firebug output:

Quellübergreifende (Cross-Origin) Anfrage blockiert: Die Gleiche-Quelle-Regel verbietet das Lesen der externen Ressource auf https://www.metzgerei-hambel.de/administrator/components/com_csvi/rantai/rantai.php?task=import&runId=76&_=1496246232498. (Grund: CORS-Kopfzeile 'Access-Control-Allow-Origin' fehlt).

Line 0

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Roland,

made an update from 3.7.1 to 3.7.2 on test.sektkellerei.de and import is running fine.

Kind regards,

Teresa
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Teresa,

The Firebug output is telling us exactly what is happening.

Quellübergreifende (Cross-Origin) Anfrage blockiert:
The request has been denied by the server. The URL that is being called is http://www.metzgerei-hambel.de, is this also the exact URL where the site is running under?

(Grund: CORS-Kopfzeile 'Access-Control-Allow-Origin' fehlt).
This means as much as that the request is coming from another origin then where the site is running under.

In other words, there is nothing wrong with the Joomla/CSVI setup but there is a restriction on the server that is being met and therefore the server denies the request. Causing all imports to fail.
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. # 15
Accepted Answer Pending Moderation
Hello Roland,

my goodness! What a silly mistake! There is no restriction on the server, but in my brain! I completely overlooked the live site settings in configuration file.

Normally I never set the live site in configuration.php, however in this case I did it. The setting was http://www.metzgerei-hambel.de - the server configuration is at first "https" and second without www in URL! Leaving the live site blank or set https://metzgerei-hambel.de solves the issue.

Sorry for rocking the boat!

Kind regards,

Teresa

PS: Call you back at least after my holidays end of June! We need to talk about different licenses for my client sites.
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello Teresa,

Sorry for rocking the boat!
No worries, glad to know the issue has been identified.

PS: Call you back at least after my holidays end of June! We need to talk about different licenses for my client sites.
Sure, have a good holiday :)
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. # 17
  • Page :
  • 1


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