1. konstantinos29
  2. RO CSVI
  3. Wednesday, 30 September 2020
  4.  Subscribe via email
Hello,

We had this problem a long time ago, we had a workaround, which no longer works with current CVSi 7.17.

The problem
After update we get "The list of available fields is out-of-date for extension com_contact. Update the list to ensure you have all fields available.".
We go ahead to update the available fields.

Due to some unknown server limitation, after a few seconds, the first 3-5 fields get updated and then the update process fails with server error 500. (I assume our hosting does not like the way CSVi behaves).

How we used to solve it
Because this is shared hosting, with limited server config options... we used to copy the CSVi URL to the browser, and manually update each field by incrementing the key number in the URL!
(tedious, I know... but it worked)

Why we can't solve it now
Now we find that the URL parameters are encoded, and can no longer do it manually (without significantly more work).
e.g. https://www.trop.gr/administrator/index.php?option=com_csvi&task=maintenance.runoperation&operation=updateavailablefields&component=com_csvi&format=json&run_id=15&key=1&f73f39129fa81fdb5968f6ca4a90bc5c=1&_=1601452901515

We are therefore stuck with v7.17 now, and an out of date list of available fields. Our exports are missing some columns now.

How do you propose we proceed?

Thanks
Accepted Answer Pending Moderation
Hello,
The problem
After update we get "The list of available fields is out-of-date for extension com_contact. Update the list to ensure you have all fields available.".
We go ahead to update the available fields.

Due to some unknown server limitation, after a few seconds, the first 3-5 fields get updated and then the update process fails with server error 500. (I assume our hosting does not like the way CSVi behaves).

We need to find out what is causing this 500 error. You can check your server error log and get the details of the error. Post it here so we can check. If you are finding it difficult to find the error, post the server error log so we can check it for you.

How we used to solve it
Because this is shared hosting, with limited server config options... we used to copy the CSVi URL to the browser, and manually update each field by incrementing the key number in the URL!
(tedious, I know... but it worked)

May i know on which CSVI Pro version this worked?

Why we can't solve it now
Now we find that the URL parameters are encoded, and can no longer do it manually (without significantly more work).
e.g. https://www.trop.gr/administrator/index.php?option=com_csvi&task=maintenance.runoperation&operation=updateavailablefields&component=com_csvi&format=json&run_id=15&key=1&f73f39129fa81fdb5968f6ca4a90bc5c=1&_=1601452901515

There is no change done to this URL with RO CSVI 7.17.0 version. This URL has been working this way for few years now.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 4 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello and thanks for the quick reply. I did more research, here are my findings...

1) The server error log shows this:

Thu Oct 01 08:56:00.709671 2020] [:error] [pid 1034] [client 109.242.4.253:65394] client denied by server configuration: /xxxxx/public_html/administrator/index.php, referer: https://www.xxxxx.xx/administrator/index.php?option=com_csvi&task=maintenance.read&component=com_csvi&operation=updateavailablefields


As I notice in the browser dev tools (Network tab), this doesn't happen immediately... the first few (3-5) calls to update the fields are successful. It seems like the server doesn't like the way/speed CSVi calls the endpoint to update the fields.
Possibly a security measure. It's shared hosting. Our provider couldn't help us the last time we asked.

I would consider adding a small delay inbetween the API calls, so that it doesn't look like hammering to some sensitive servers.

2) It was my mistake regarding the URL. it may not have changed as you said.
In the past, I would copy/paste the field update URL in the browser, change a URL parameter number (run_id? key?), then reload... each time I would get a message saying a new field has been processed.

I now realized I don't need to change any values, simply refresh the same URL, and a new field gets processed. Until I hit the end. I managed to update all fields in my v7.17 installation.

Problem is solved for me, again, with this workaround.

Thank you.
  1. 4 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
As I notice in the browser dev tools (Network tab), this doesn't happen immediately... the first few (3-5) calls to update the fields are successful. It seems like the server doesn't like the way/speed CSVi calls the endpoint to update the fields.

RO CSVI Updates available fields as ajax call. So if i understood correct after 3 to 5 ajax calls your server is blocking the request.

I would consider adding a small delay inbetween the API calls, so that it doesn't look like hammering to some sensitive servers.

This issue is because of your server configuration and is very specific to your server. No other user has reported this issue.

It was my mistake regarding the URL. it may not have changed as you said.
In the past, I would copy/paste the field update URL in the browser, change a URL parameter number (run_id? key?), then reload... each time I would get a message saying a new field has been processed.

The URL you are pasting in browser by changing the run_id is the same URL called as ajax request. I guess you are not running the urls back to back else you will see the same issue as you see with ajax requests.

Problem is solved for me, again, with this workaround.

Glad to know that issue is solved.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 4 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Try update of available fields as cron job. May be that will solve the issue of copying and pasting URLs in browser. You can check Setting up cron job in RO CSVI document to setup the cron job.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 4 weeks ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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