Categories
View Replies (26)

Resolved Hikashop Order Export - advanced export functionality patch error

  1. web-tiki
    web-tiki
  2. RO CSVI
  3. Tuesday, 13 November 2018
  4.  Subscribe via email
Hello,
I need for the advanced order export functionality and tried the patch you shared in this topic
I also needed to do point 1 and 2 twice to be able to select the "order advanced operation for HikaShop" option and test it.
Unfortunatly I am getting an internal server error when running the export. This is the error message :
"0 Class 'hikashop\com_hikashop\model\export\Registry' not found"
I tried running the export with simple fields and with no fields in the xml template. Both return this error.
Am I doing something wrong?
What can I do to solve this error?
0
Responses (26)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you tell us which version of Joomla and CSVI you are using?
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
web-tiki
web-tiki
Accepted Answer Pending Moderation
I am using
- joomla 3.8.13
- CSVI 7.9.0
- PHP 7.2.10
- Hikashop 4.0.0
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your versions look good. Can you post the complete error or post a screenshot? We need to see on which line this is breaking. If you do not see the complete error, take a look at Internal server error document. This document will tell us where to find the details of the error and once we have the details, we can then look for the fix.
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. # 3
web-tiki
web-tiki
Accepted Answer Pending Moderation
Unfortunatly there is no information on what line the error is occuring on. I have attached the screenshot of the error I have.

2018-11-13 13_47_21-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png

I will check the internal error document you linked.
Attachments (1)
2018-11-13 13_47_21-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png 2018-11-13 13_47_21-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Did you check the link to Internal server error document in my previous reply? Check your server error logs and see if you can find any details on the error.
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
web-tiki
web-tiki
Accepted Answer Pending Moderation
Unfortunatly, I am not able to give more information on the error. I have tried the solutions described in the document you linked in the previous reply:
- setting Error Reporting to Development doesn't give more information (same screen as the one I shared earlier)
- The website I am working on is on an ovh shared hosting and the error logs have no trace of 500 internal server errors

I will try to transfer the website on my local server to test some more.
  1. more than a month ago
  2. RO CSVI
  3. # 6
web-tiki
web-tiki
Accepted Answer Pending Moderation
I have transfered my website to my local server. It's running on wamp server with php 7.2.7
I get the same internal server error. I have attached the last lines of the apache access.log that contains the 500 error :
access.txt

** Edit **
I have also updated my local test site to joomla 3.9 but the error is still displaying on export
Attachments (1)
access.txt
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You have sent us access log, it just says the URL which has 500 internal server error and does not give any details of the error. Can you check your error logs and post it?
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
web-tiki
web-tiki
Accepted Answer Pending Moderation
Sorry for the wrong error log. I have managed to change the configuration on my local server and get more information on the error. Please take a look at the attached screenshot.
It seems like the error occurs in the plugins\csviaddon\hikashop\com_hikashop\model\export\orderadvanced.php file on line 91


[attachment]2cd512d6f8266f4835ca05a7d260b226[/attachment]
Attachments (1)
2018-11-14 11_12_38-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png 2018-11-14 11_12_38-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for details on the error. Can you load the attached patch file and check your export again?

patch_hikashop_order_advanced_2018_11_14.zip
Attachments (1)
patch_hikashop_order_advanced_2018_11_14.zip
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
web-tiki
web-tiki
Accepted Answer Pending Moderation
Thank you for the patch. I loaded it and reset tasks + available fields.
On export, I still have an error as seen in the attached screenshot
2018-11-14 11_51_21-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png
Attachments (1)
2018-11-14 11_51_21-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png 2018-11-14 11_51_21-CSVI - Export - Route Mandarine - Administration - Firefox Developer Edition.png
  1. more than a month ago
  2. RO CSVI
  3. # 11
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The errors you are seeing now is about mysql connection. Check the MySQL adapter you are using by going to System -> Global Configuration -> Server -> Database Type. Is this set to MySQLi? If not, set to MySQLi and check export again.
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. # 12
web-tiki
web-tiki
Accepted Answer Pending Moderation
The database type is MySQLi. But I have tried installing the last patch you provided on the "live" server and the first tests are positive, it solved the internal server error.
Thank you very much for your support!
  1. more than a month ago
  2. RO CSVI
  3. # 13
web-tiki
web-tiki
Accepted Answer Pending Moderation
I have manage to make one of the exports I need. But now I need to build another one and export orders only with a specific shipping method.
I see in the options that I can export orders depending on the payment method, state date... but there is no option to export depending on the sihipping method.

Is that something I can do and how? I have tried using rules but it doesn't seem to be the best way to achive this.
  1. more than a month ago
  2. RO CSVI
  3. # 14
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Filtering by shipping method has been missing in order advanced export. I have added this feature with the attached patch file. Please load the patch file and let me know if export works as expected.

patch_hikashop_2018_11_15.zip
Attachments (1)
patch_hikashop_2018_11_15.zip
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. # 15
web-tiki
web-tiki
Accepted Answer Pending Moderation
Hello,
Thank you for the patch, I have successfully loaded it. The option to filter by shipping method is availbale in the option tab of the template but:

  • It seems like I can only choose shipping methods that are already used in the hikashop orders. I have many shipping methods and I am testing with a few fake orders. All the shipping methods aren't selected in the fake orders.

  • On export all the orders are exported (I'm using .csv export) even the ones that don't have the selected shipping method in template option


On a side note : I am also filtering the orders by status and only exporting order with a specific status.

Thankj you,
web-tiki
  1. more than a month ago
  2. RO CSVI
  3. # 16
tharuna
tharuna
Accepted Answer Pending Moderation
Hello web-tiki,
It seems like I can only choose shipping methods that are already used in the hikashop orders. I have many shipping methods and I am testing with a few fake orders. All the shipping methods aren't selected in the fake orders.

Yes only the shipping methods in HikaShop Orders table are shown in Shipping filter. There is no use in listing the shipping methods which do not have any orders in the shipping method filter. I don't think shipping method for any real orders will be empty.

On export all the orders are exported (I'm using .csv export) even the ones that don't have the selected shipping method in template option

Can you send us the debug log of your export? To get the debug log check How to get debug information? document.
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. # 17
web-tiki
web-tiki
Accepted Answer Pending Moderation
I have enable logging and done the export again. The log file : com_csvi.log.112.zip

For the shipping method selection, the point is that I have over 20 shipping methods depending on several parameters (shipping zones, order price, order volume...).
If the select dropdown only allows me to choose shipping methods that are selected in an order, I need to create a fake order for each shipping method.
To compare, in the order status dropdown I can select any status even though there is no order with every status in my system.
Attachments (1)
com_csvi.log.112.zip
  1. more than a month ago
  2. RO CSVI
  3. # 18
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The debug log you posted is for HikaShop order export and not for order advanced export. The patch i sent has shipping method filter only for order advanced export. Is this the right debug log?

For the shipping method selection, the point is that I have over 20 shipping methods depending on several parameters (shipping zones, order price, order volume...).
If the select dropdown only allows me to choose shipping methods that are selected in an order, I need to create a fake order for each shipping method.
To compare, in the order status dropdown I can select any status even though there is no order with every status in my system.

Ok i get your point. Please load the attached patch file and check the export.

patch_hikashop_2018_11_15.zip
Attachments (1)
patch_hikashop_2018_11_15.zip
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. # 19
web-tiki
web-tiki
Accepted Answer Pending Moderation
Thank you for the last patch. I can now select any published shipping method.
For the log, I though it would also work with HikaShop order export, sorry.
I have tried with order advanced export and the result is the same. Please see the attached log file. The last line has a shipping method that isn't selected in the template option. In this export, I am also filtering orders by status.

com_csvi.log.115.zip
Attachments (1)
com_csvi.log.115.zip
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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