1. Comenaranjas
  2. RO CSVI
  3. Wednesday, 07 January 2015
  4.  Subscribe via email
Hi Roland

We made 4 reports and only in one of them we get this error instantly when trying to export.

I upload you the logfile in case that helps.

The difference between this report and the rest is the size I believe, we try to export values for one month, we tried in CSV, HTML or even HTML by e-mail but in all cases it crashes.

I have read your documentation for 500 erros and some old about timeouts but I dont find options in CSVI to set parameters for this, maybe not yet included?

Something I could touch there or on the hosting side?

Regards
Accepted Answer Pending Moderation
Hello Manuel,

Can you post a screenshot of the 500 error? The problem is, there are different errors with the same 500 number :-|
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
There you go ;)

Regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thanks, this is the ISE from the server and not Joomla. You will need to ask the hosting provider to check the log to get the real error. Once you know the real error we know where to look for the solution.
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
Hi Roland

Im looking at the the FTP and found a folder with logs, downloaded file and saw this:

81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_logo_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_process_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_order_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_replace_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_log_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_maintenance_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_av_fields_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_analyzer_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_settings_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_template_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"
81.45.55.121 - - [31/Dec/2014:14:15:36 +0100] "GET /administrator/components/com_csvi/assets/images/csvi_about_16.png HTTP/1.1" 304 0 "http://www.comenaranjas.com/administrator/index.php?option=com_virtuemart&view=orders&task=edit&virtuemart_order_id=7052"; "Mozilla/5.0 (Linux; U; Android 2.3.4; es-es; SonyEricssonMT11i Build/4.0.2.A.0.62) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1"


On the normal error log I have in my Cpanel there is no reference to this error,

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
The reply from the host:

This is due to the time limit set.

You can create a custom php.ini with the values required by the particular script (usually indicated in the documentation of the scripts).

If you need help, please tell us.

-----------------------------

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Ok, now that we have the real error message we know what to do. The host suggests a custom php.ini, the other option is to set the refresh time in CSVI. In your template you can open the Limit tab and set the Lines per import to a lower number, this means that CSVI will refresh the import faster and as such staying within the time limit. A value of 0 means no limit, so you could set it to 500 and see if that works. If not, you can lower the 500 until you get a useful value for yourself.
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. # 6
Accepted Answer Pending Moderation
Hi Roland

I upload image of what I see, I dont find the field to set max lines.

Should I ask the host for those values?

However If I limit lines I wont get the full values no?

Regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Manuel,

Why are you looking at the Joomla configuration? I am talking about the Limit tab in your template. Give that a look.
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
Accepted Answer Pending Moderation
:woohoo: sorry Roland, was posting a bug in VM forum and confused image. Here is the correct one, this is what I see so dont really know how to deal with that.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
My bad, we are talking about export here not import. That got me confused. I have not build in a specific limit for the export. I will have a look at it and we can see if that will work for you.
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. # 10
Accepted Answer Pending Moderation
Hi Roland

Are you sure this is a server side issue?

I tried the same export with another component and was able to download the same fields and values even for past 3 months. The only difference it took about 30 secs to generate the CSV but didnt get any error messages.

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

An internal server error is always generated by the server and only tells us something went wrong but I won't tell you what. That is why you need to ask the hosting provider to check the logs for the exact error. Once you know the exact error, we can see what is really happening. This may very well be something triggered by CSVI but we won't know without the actual error.
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
Hi Roland

Ironically I tried the export now and it work exporting more than 1900 lines without issues. It took a few seconds more but didnt crash.

Dont know if you modified something in the VM plugin you send me or maybe the host itself adjusted some settings.

I will make several tests to see if it happens again and ask them for an exact error.

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

That always happens when least expected ;) I had a look into this but it isn't an easy feature to implement. Let's see if you can trigger it again or not.
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. # 14
  • Page :
  • 1


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