Categories
View Replies (16)

Resolved Error when exporting

  1. porscha
    porscha
  2. RO CSVI
  3. Wednesday, 05 June 2019
  4.  Subscribe via email
Hi Roland,

we're experiencing the following error when making an export of all products. I'm attaching the logs. Around the 40th second it throws the error. We have few sites on the same hosting, but only on this one we having the error. The setup of all sites is identical, only the languages are different. We have experimented with different export combinations, but still no luck when trying to export all products. I would appreciate any help or advice that you can offer. Thank you in advance!

An error has occured during the export. Below the information received from the server.
Status error: 500
Status message: Internal Server Error
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
0
Responses (16)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Have a look at 500 Internal server error document to know the causes of 500 error. Details of real error causing 500 error can be found from your server error logs. Unless we know the real error it is difficult to find the cause. So check the error logs and post any relevant information you find.
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
porscha
porscha
Accepted Answer Pending Moderation
Hi Tharuna,

unfortunately there are no errors in the server error logs. All other sites working normally, but with this one still no luck exporting the full product table.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
When you say full products table, i think there are many number of records in products table and server is hitting its limit on export. Go to your export template settings on File tab set From field to be 1 and To field to 500 or 1000, save the template and run the export. Does the export work? If you still see the error try reducing the number of records exported by changing To field to a lesser number.

Let me know how it goes.
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
porscha
porscha
Accepted Answer Pending Moderation
Hi Tharuna,

actually there are errors in the administrator error log. Each time the export throws the error, I get:

PHP Warning: in_array() expects parameter 2 to be array, null given in /home/xxxxxx/public_html/administrator/components/com_csvi/models/template.php on line 330

The line from the template.php file is:

if (in_array($settings->custom_table, $fullData['jform']['custom_table'])
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
This error is not related to your export. This line of code will be triggered only when you save a template. Since with export you are not saving the template it is not possible to get this warning. But we will check the warning and fix it. Please check if you are seeing any other errors related to your export or can you try your export with the export settings i mentioned in my previous reply?

Can you also post your template XML file to check? To get the template backup go to Maintenance page, select CSVI Pro in first dropdown, Backup Templates in second dropdown, select your export template and click continue. Post the downloaded 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. # 5
porscha
porscha
Accepted Answer Pending Moderation
Hi again Tharuna,

So the results are these:

1. I tried to update CSVI to last version - again throwing error.
2. I tried From To record - from 1 to 500, from 500 to 1000, ... to from 3500 to 4000 (because my products are nearly 4000) every export was successful. But when I tried from 1 to 1000 the error is showing again.

3. Here is the XML of my template (attachment)

Thank you for your time and suggestions :)
Attachments (1)
csvi_templates_v-tac.eu_20190605.xml
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The fields from your template looks good. There is no field which i could say can cause the delay for your export and lands to 500 error. Exporting 4000 products is not a big thing but your server is not able to handle it and so hitting its limits. Since you mentioned that export works with 500 records, there is nothing wrong with your export settings. You need to check your server memory_limit and max_execution_time values. You can get that value by going to your Joomla administrator menu and using System -> System Information and in PHP Information tab search for memory_limit and max_execution_time. Ask your hosting provider to increase these value and then check if export works.
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. # 7
porscha
porscha
Accepted Answer Pending Moderation
Hi Tharuna and thank you for help. I've checked the parameters for:
memory_limit Local Value 256M Master Value256M
max_execution_time Local Value 3600 Master Value3600

I used the settings to override system limits to these values, but again tha same error. The strange thing is that we are on VPS server, and on this server we have 8 more sites, exact copy of this but in different language. And I manage to make an export from Italian and Bulgarian site without any problems and errors. does it make sense to contact the hosting provider in the presence of this information? Thank you again!
  1. more than a month ago
  2. RO CSVI
  3. # 8
porscha
porscha
Accepted Answer Pending Moderation
In addition I can tell that I have checked our bulgarian site, from which the exports has no problems and the max ex time and limits are:

max_execution_time 30 30
memory_limit 128M 128M

Does this look strange?
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
memory_limit Local Value 256M Master Value256M
max_execution_time Local Value 3600 Master Value3600

I used the settings to override system limits to these values, but again tha same error. The strange thing is that we are on VPS server, and on this server we have 8 more sites, exact copy of this but in different language. And I manage to make an export from Italian and Bulgarian site without any problems and errors. does it make sense to contact the hosting provider in the presence of this information? Thank you again!

Override limits should work because you are on VPS server. How many products do the Italian and Bulgarian sites have? Before you talk to your hosting, can you make a basic export template with product_sku and product_name and see if you can export all products at once?

In addition I can tell that I have checked our bulgarian site, from which the exports has no problems and the max ex time and limits are:

max_execution_time 30 30
memory_limit 128M 128M

Does this look strange?

These are fine as they are the default values. Strange thing is that these sites don't throw any error but your English export site does.
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
porscha
porscha
Accepted Answer Pending Moderation
Products in Bulgarian and Italian sites are as in English - 3925.

I tried an export as you said - with SKU, Name, Cat Path, and add Warranty and Product Code just like that and there is no error. the export was running and I have a table with 3925 product now. But when I include more custom fields (around 40) it again throwing the same error.
  1. more than a month ago
  2. RO CSVI
  3. # 11
porscha
porscha
Accepted Answer Pending Moderation
I have around 80 custom fields and I think that when I include them all the error is present. Do I need to contact the server provider and to tell them to decrease ex time and limito to max_execution_time 30 memory_limit 128M ?
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
More fields means more time to process and so basic template works than your template with 80 custom fields.

Yes, you can talk to your hosting provider on max_execution_time and memory_limit values.
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. # 13
porscha
porscha
Accepted Answer Pending Moderation
Thank you! I wrote them and will see what they're going to tell me. Have a great day :)
  1. more than a month ago
  2. RO CSVI
  3. # 14
porscha
porscha
Accepted Answer Pending Moderation
Hi Tharuna!

People from hosting company were not very helpful. I do not know if they made some changes on the hosing, but yesterday evening I tried to make an export from English site and set the records from 1 to 2000 (considering that it worked from 1 to 500 only) and miracle - it worked. Than I set the records from 1 to 4000 and again the export was successful. I have no idea what actually happened, but everything is working now (in the morning I made an export again, because I wanted to try it when the server is more busy). Cross your fingers to continue this way. This was not related to CSVI at all, but what was the problem is a total mystery :D

Have a great weekend!
  1. more than a month ago
  2. RO CSVI
  3. # 15
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Glad to know that your issue is solved :)
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. # 16
  • Page :
  • 1


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