Resolved SEF URL cache is not filled

Hello,

Now the export timeouts again and I cannot see any record being created in the #__csvi_sefurls table. Is that expected? Is the cache filled only after a successful execution?

There is an option in CSVI maintenance menu to insert SEF URLs in advance before running the export, to do that select VirtueMart in first option and in the second option Refresh URLs and select the template and click continue. This will make entries in your #__csvi_sefurls table, you can now run the export and see if it goes without timeout and with SEF URLs.

Hello and thank you for your reply.

I executed the maintenance task, but it timeouts after 20 minutes and no record is created into the #__csvi_sefurls table. Is this an expected behaviour? Are all records written into the table at the end of execution?

Is it possible to get logs from maintenance tasks as well?

Thank you for any suggestion.

Hello,
Can you check if CSVI has been blocked by Firewall or admin tools extension? Please check into your .htaccess file too. There has been a forum post with same type of issue, you can have a look at the post here and see if it is of any help.

Hello and thank you for your reply.

No firewall extensions are installed and operating system firewall does not block HTTP traffic.

No extra blocks / redirects in .htaccess except from non-www to www. Does the live_site matters? It's empty at the moment.

Is there any way I can track the URL actually called by the SEF URL generator so I can test it manually?

Thank you for any suggestion.

Hello,
The SEF URLs are processed in the batch of 500, you can try lowering it to 50 and see if it works. To do this change you need to check the file at location /administrator/components/com_csvi/addon/com_virtuemart/model/maintenance.php. Please look for refreshSefUrls function, and line if($count > 500), reduce the number to 50. Save the file and run the refreshURL again from maintenance page.

If you still have issues, you can check the helper file which generates the SEF URLs at /administrator/components/com_csvi/helper/sef.php. Check getSefUrl function to see the URL generated.

Hello and thank you for your reply.

By debugging the code I was able to find two issues.

1. The hostname in CSVI settings was not correct, it was http://www.joy-shop.it instead of joy-shop.it. The request gets redirected correctly, but by default a POST request will lose its payload on redirect, so no response was retrieved. Basically you must be sure that the hostname is the final one, not just a valid alias for the site.

2. The returned data is an object and not an array. So this check fails and the URL is never saved:

if (is_object($output) && $output->success && is_array($output->data))

I changed that into

if (is_object($output) && $output->success && !empty($output->data))

and now SEF URLs are filled correctly into the table.

Thank you for your help! If you need any more test / clarifications, I am available.

Hello,
Thank you for your feedback, we will look into this.

Hello,

Thank you for your insightful feedback. The Refresh SEF URLs has been updated and the changes I made are not to allow redirects and check for a 200 status. If any other status is returned this is caught and the feedback from the server will be shown. The message also includes the tip to check the domain URL in the global settings.

As for the object versus array, I am simply checking if it is either as it doesn't matter for the next code.

In the future this piece is now better, thank you for that.