Resolved Server response time settings for exporting to xml

Hello,
Can you Analyse the export with firebug and send the screenshot of what you see? The document explains about import but it is the same for export too.

Hello,

Firebug gives out nothing at all:

It looks like you started it after you started the export. Did you open the Firebug tab before starting the export?

Is this connected somehow?

That is irrelevant if you ask me. However it is something you want fixed. Rather than going to About to fix them it is better if you go to Extensions -> Manage -> Database and check there what the status is and fix it from there.

AND xml file I have with 1700 records is 1,53 MB big, is this OK?

That is OK, I have downloaded much larger XMLs. It seems you are hitting some kind of server limit. Can your hosting provider shed some light on this?

Hello,
The processing is taking more time than it gets from the server. You can try Increasing the maximum execution time by clicking on Advance button, find tab called Limits, set Override system limits to Yes and set a maximum execution time in there. This may not work if your server is not a VPS or dedicated server, in that case you can ask your hosting provider to increase the maximum execution time on the server. See if your export goes good after that.

What time should I place there?
There is no hint in what units time is set by the value I enter....
I tried to enter 100, but I am not sure if it is in seconds or miliseconds

UPS, just noticed how to see hints. My bad....

What value should I try?

Hmm, in logs I see that it is creating a list, and that creation is cancelled...

Hello,

What value should I try?

Try putting the value to 120 seconds(2 minutes) and increase it if you still have issue.

Hosting provider changed php script execution time.
Also I changed the limit to 200, after 120 didn 't work.

It doesn't manage t make a list anyway... the time goes over 300 and nothing happens.
On Sunday it took less than 60 seconds to make a file.
Nothing changed in setup. The only thing changed I can think of is the amount of products. But it shoudn't be a problem, right?

Hello,

The only thing changed I can think of is the amount of products. But it shoudn't be a problem, right?

That should not be a problem. Can you try exporting only a few products by setting From record and to record on files tab in template settings?

I tried that.
I set to make file with 10 records. No problem there. It did generate the file.

When I set the setting back, same thing, no xml in result. I waited over 1500 s.

I included log file.

com_csvi.log.204.zip

I tried to experiment with file option amount of records. Until 1700 file is generated. If I set amount over 1700 or leave the setting empty, there is no result.

I am looking at the moment what firebug can tell me....

Firebug gives out nothing at all:
http://screencast.com/t/WZk0g1Tm6w

Is there a way I can give you template settings to check?

Edit:
OK, I noticed that in section About I have Error message:

Error
Table 'datevlv_new.#__utf8_conversion' doesn't exist SQL=SELECT `converted` FROM `#__utf8_conversion` WHERE `converted` = 2

and:

Warning: Database is not up to date!

Table 'lg_csvi_icecat_index' does not have column 'm_prod_id' with type VARCHAR(50). (From file 6.4.2.sql.)
COM_CSVI_MSG_DATABASE_UTF8_CONVERSION_UTF8MB4

Is this connected somehow?

AND xml file I have with 1700 records is 1,53 MB big, is this OK?

Yeah, now firebug gives this: http://screencast.com/t/uGw9MvDQZ8

Hosting provider is looking into that as well.

Hello,
In your screenshot firebug looks good but it will show the error when you get "The last server response has not been received in a timely fashion....." , You need wait till then. Lets wait and see what your hosting provider comes with.

OK, hosting provider changed settings for script handling.
Now everything works.

Thanks.

Hello,
Glad to know everything is fixed and Thank you for posting your solution.

I am having the same issue will only export 5 records - after that nothing can i ask what was the solujtion re server script handling that occured ??