Resolved Status error: 500 Status message: Internal Server Error

Hello,
Please have a look at 500 Error document to know possibilities for this error. You need to send us your server error logs as that is where the actual error which is causing this 500 error is logged.

Hi Tharuna,

this is one line of it:
***** - - [04/Oct/2017:11:23:41 +0200] "GET /administrator/index.php?option=com_csvi&task=exports.export&format=json&runId=40&_=1507109021750 HTTP/1.1" 500 447 "https://www.*****.it/administrator/index.php?option=com_csvi&view=export" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36"

Hello,
In the error you posted it just says on which URL you are getting the 500 error. This looks like access log and not the actual error log. Can you check for the same error in server error logs? That is where we will get information on why the error happens.

Hi Tharuna,

sorry, this is the log:

[Wed Oct 04 11:21:09.153176 2017] [fcgid:warn] [pid 31555:tid 140300393531136] [client *************:51687] mod_fcgid: stderr: PHP Fatal error: Call to undefined method CsviHelperExportfields::getDateFormat() in /**********/public_html/plugins/csviaddon/virtuemart/com_virtuemart/model/export/orderadvanced.php on line 893, referer: https://www.********.it/administrator/index.php?option=com_csvi&view=export

Hello,
Yes that is the error. Which version of CSVI are you using? Is your CSVI package and CSVI VirtueMart addon are updated to same version? Can you go to Joomla Extensions menu >> Manage >> Manage, Search for CSVI in filter box and post a screenshot on what you see?

Attachment.

Probably it's like that because I had to import a patch that you created to me in the past...

Hello,
My bad, the patch is the problem not for the CSVI VirtueMart addon version but i sent the file with code changes which are coming with upcoming CSVI version. Can you load the attached patch file and then run the export again?

patch_vm_order_advanced_2017_10_04.zip

Hi Tharuna,

thank you very much.

Now the export is running, but some fields are not valorized, for example [created_on] or [order_number].

Any idea?


Thanks a lot!

Hello,
Looking at the debug log posted earlier i see that the order_number and created_on in your XML header field are enclosed with one curly bracket and one square bracket like [order_number}. You need to correct that in your XML header field in your export template settings.

Hi Thauruna,

ah, shit, sorry for this stupid error!


Last question, in the footer field of xml layout the variables are not valorized?


Thanks,
Davide

Hello Davide,

Last question, in the footer field of xml layout the variables are not valorized?

I guess you are talking about order_tax field in footer xml, this field is not added as a template field and so you are not seeing its value in export. Add this field to your template fields and run the export.

Hi Tharuna,

yes, order_tax is a field and the same order_number that works in the head, but not in the footer...


Thanks,
Davide

Hello Davide,
As i said earlier you need to add order_tax as a template field so you get its value in export. You have the same problem of having curly brackets for [order_number} in footer XML. You need to fix this too.

Hello Tharuna,

order_tax is a template field and the brackets were solved last time.

If i put the code in "orderline" space it works, if I put it in the footer, not!

Thanks,
Davide

Hello Davide,
The footer field is for closing the XML and does no processing on values and so order_number does not work in footer field. Please check the Advanced order export document for more information. You can move your XML in footer field to Order field to have the values exported.

Ah ok, perfect.


Thanks a lot and have a nice day!

Davide