Resolved Update available fields and Import error

Hello,
The 500 error doesn't tell us details on what has gone wrong. Please see the document 500 Internal server error and follow what is in there. Post the real details of the error and once we know the details we can look for solving it.

Hello Stefanato,

If you enable the Debug System option in Joomla Global Configuration, do you see more information? Please also check the document Tharuna has provided.

Hi Tharuna,

Here is the log and find the attachment after enabled Debug System option in Joomla Global Configuration

An error occured processing the records. The error occured is shown below if available. Additionally check your server log for any errors or warnings.
Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/vhosts/finesso.it/httpdocs/libraries/src/Table/Table.php on line 965

Hello Stefanato,
Maximum execution error shows up when the server is unable to finish the process in the given 60 seconds time limit. In you server look for php.ini file and try increasing max_execution_time variable and check the update of available fields. This is a server setting and we can do nothing about it.

Hi,
sorry but for me the situation is not clear.
Server is a standard shared server. I have loaded the project also in our dedicated cloud server and the problem is the same.
The max_execution_time is been increased to 180 : https://easycaptures.com/fs/uploaded/1658/4239775487.png
This this the other PHP standard configurations: https://easycaptures.com/fs/uploaded/1658/2774547765.png

Moreover there is no errors about Joomla in server log apart the CSVI component : https://easycaptures.com/fs/uploaded/1658/5375359456.png

What do you suggest ? Do you need Plesk/Joomla access ? The website is finesso.it
If there is anything to pay to solve this it's not a problem but the import process must work.
With joomla 3 on this server all worked fine.

Le me know.
Thanks in advance.

Hello Stefanato,

No need to pay for support, you have done that. There is also no need to increase the maximum execution time. What I find intriguing is that you get a timeout in this process. Do you get these timeout errors in more pages other than updating the available fields? The log you posted you seem to get a timeout as well when you want to edit a template. Is that correct?

Your screenshot shows the error but not the stack trace, that would be interesting to see as well. If you can recreate the error and click on the stack trace tab and post that output, that would be appreciated.

In the meantime, I am thinking you can go to the About page in RO CSVI and click on Verify Database and see if things improve after that.

Let us know how it goes.

Hi,
here the test results :

When Verify Database from ROcsvi: https://easycaptures.com/fs/uploaded/1659/6381906648.png
After optimized/repair DB from phpmyadmin: https://easycaptures.com/fs/uploaded/1659/4335650731.png

When lunched Update Available Fields Error ROcsvi:
https://easycaptures.com/fs/uploaded/1659/8067193995.png

When lunched Optimize database tables from ROcsvi
https://easycaptures.com/fs/uploaded/1659/8075388379.png

Is this what you requested?

Hello Stefanato,

That is what I requested indeed. One thing we found out the other day with one customer is that this out of memory occurred almost instantly because the #__menu table was corrupted. The #__menu table is missing the root element. Can you check if that is missing?

You are looking for the menu entry with ID 1 and a title of Menu_Item_Root and the alias is root. Does that entry exist in the #__menu table?

In case the entry does not exist, you will need to add it. Please check another website that you have as to how it should look.

If the entry exists, please post Joomla and (S)FTP access to your site so we can investigate why you get the out of memory error.

Hi,
checked #__menu table but the root element seems ok : https://easycaptures.com/fs/uploaded/1660/4057552580.png
(also compared to others websites)
I give to you the websites details.
Thanks in advance

Hi, i removed all as suggested (tables give 500 error so I have deleted them manually) , fresh reinstall and now works all perfectly !
Thanks for support.
Bye.
Andrea