I have a simply import template that imports four fields. The import was working before, but now I'm getting a 500 error and the last server respose gets up to 300 then times out.
Here is what I did to try and correct the situation.
- I re-saved the template
- I ran Maintenance and Updated Available Fields
- I turned on Enable Logging, but no log appears
I'm running Joomla 5.1.1 and RO CSVI 8.11.1
Your feedback/help is appreciated.
Hello,
In your screenshots there are no details of error other than you have 500 internal server error. We need the actual error details to fix it. Please read through 500 Internal Server Error document to know causes of this error.
I would suggest doing two things
- In import template on Limit tab set Number of lines to import to 100, save the template and check the import.
- If point 1 does not help and you still have the error, check server error logs and see if you can find details of the error. Post it here and we can help.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry for the delay in replying - took me some time to figure out how to get to the correct server log.
I tried #1 suggestion, but still the same result.
Here is a copy of the 500 error from the server log.
GET /administrator/components/com_csvi/rantai/rantai.php?task=import&runId=5&_=1718549787905 HTTP/1.0
Note that I'm running PHP 8.2.20 and the latest joomla and RO CSVI.
I have also attached a screen shot of other log records that may shed some light.
David
Hello,
The details posted is not from server error log but it access log. We will not know the error details from access log. May I know the type of import you are using? Can you post the template XML and import file used so I can check? To get the template XML file from RO CSVI templates list page select the import template and click on Backup templates button. 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
Thank you for your help. I have attached the import XML file, along with the spreadsheet I'm trying ti import.
David
Further to the previous email - with the things that you asked for....is the attached errors helpful?
David
Hello David,
The last screenshot you posted has warnings which are not errors. Warnings are not as bad as errors, warnings are just to inform us developers to clean it up. Which is hard if you want to support Joomla 3/4/5. However the silver lining is that we can ignore warnings for now, we are aware of them. Once the Joomla 5 only release sees the light of day, these will be solved.
Now to get back to your 500 error, which is more important. To be able to test this I recreated your setup and I am able to see the error. As expected this is a conflict between old and new code. Some code has changed on your site, either Joomla is updated or the Google library.
If you are not using the Google sheets integration you can safely remove the folder administrator/components/com_csvi/assets/google/ If you are using this integration, let us know and we can send a temporary patch to make it run on Joomla 5 with the new PHP version.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you for the great support.
Note that we are not using google sheets intyegratoin, so I renamed the folder in the path you showed, from google to dhgoogle. However, I received the same error.
I then removed the folder and received the same error. Was i supposed to do something else?
David
Hello David,
I see that you are doing Joomla users import. Please load the attached patch file and check the import. Let me know if the patch file fixes the error.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Works and thank you for the patch.
Just as an FYI, you do have a support documents that says if you get a 500 error, check the server log of more information. Since having this problem, i have become quite familiar with all the server log files on our VPS and in this instance, there was nothing in there that highlighted the issue.
I guess there are MANY reasons for 500 errors, but my lesson leaned is that not all of them have helpful info in the server logs.
Thank you for your always-quick responses and helpful suggestions. You really do provide great support!
David
Hello David,
Glad to know patch fixed the error.
I guess there are MANY reasons for 500 errors, but my lesson leaned is that not all of them have helpful info in the server logs.
That is correct. Most of these errors are logged in server error log and so we suggest to look for details in error log. In this case there was a change missing in code in Joomla user import file and that was causing the 500 error.
Thank you for your always-quick responses and helpful suggestions. You really do provide great support!
Thank you for your feedback. Please leave us a review in Joomla Extension Directory.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello David,
Also the fix in patch file will be included in upcoming RO CSVI release. I am setting this topic to closed. Feel free to open a new topic for any new issues.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.