Resolved 500 Status message: Internal Server Error

Hello,

Did you have a look at the Internal Server Error document? We need to know the real error from your server, so we know where to look.

Do I find this error from my Cpanel?

Thx

Usually you would need to ask your hosting provider for this.

Hello, I checked the logs but no errors are shown.. below is the most recent action I ran that relates to CSVI.

***.125.56 - - [29/Sep/2015:04:11:41 -0400] "POST /administrator/index.php?option=com_csvi HTTP/1.1" 303 20 "http://www.***.com/administrator/index.php?option=com_csvi&task=logdetails.display&run_id[]=1443514056" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36"
***.125.56 - - [29/Sep/2015:04:11:42 -0400] "GET /administrator/index.php?option=com_csvi&view=log HTTP/1.1" 200 9544 "http://www.***.com/administrator/index.php?option=com_csvi&task=logdetails.display&run_id[]=1443514056" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36"


I will be more than happy to provide access if that helps?

Hello,

Providing access is not going to help. As the document says, which I linked earlier, you need to get the real error from the server log, which usually is only available to the system administrator. Occasionally it happens because of an outdated PHP version, like PHP 5.3. However without the real error, it is like finding a needle in a haystack.

Hi Roland thanks for your reply ,

From cPanel I downloaded the 'Raw Access Log' files immediately after I tried to run CSVI pro from the Admin.

The only lines related to CSVI that are shown in the Raw Access Log is the below:
***.125.56 - - [29/Sep/2015:08:25:33 -0400] "POST /administrator/index.php HTTP/1.1" 303 20 "http://www.***.com/administrator/index.php?option=com_csvi&view=process" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36"
***.125.56 - - [29/Sep/2015:08:25:34 -0400] "GET /administrator/index.php?option=com_csvi&task=process.finished&run_id=1443529499 HTTP/1.1" 200 8457 "http://www.***.com/administrator/index.php?option=com_csvi&view=process" "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36"


I already emailed the Hosting Provider asking if there are any other Error Log files I can find/download and they said that the 'Raw Access Log' file should contain all information.

I don't know who else to ask help from ? Perhaps there is no Internal Server Error and there is another reason for the script not running?

Hello,

That access log (which is not the error log since it shows access requests and not errors) shows that you loaded the process page and after that it tried to finish the run.

they said that the 'Raw Access Log' file should contain all information.

:blink:

I don't know who else to ask help from ?

Your hosting provider apparently have no clue what they are talking about. Let's take a slow step, are you on PHP 5.4 or higher? If not, that is definitely a step to take because PHP 5.3 is over 2 years unsupported and actually PHP 5.4 is already unsupported by the PHP project.

Perhaps there is no Internal Server Error and there is another reason for the script not running?

If the system says there is an Internal Server Error, that is what it is. The script runs but it can't seem to finish the run. The records should have imported already, did they?

Hello, just an update

1) Re-submitting a ticket requesting to see the Error Log Files - please standby until I hopefully get access to the errors

2) We are on PHP 5.4

3) The records/products did not update no. As soon as I click on the 'Process' button I immediately see the error mentioned in this post but without any updates of the products. Just to clarify that the products already exist in the database and that I'm just trying to update their price and Minimum order Quantity.


G

...response from my Hosting Provider after I advised them that the 'Raw Access Log' do not contain any Errors and that I need to see the Severs' Error Log file.

The repeatadly asked me to:
"Once again you will need to configure your script to log errors. "

I'm lost

Hello,

Sorry to hear you chose a host that has no clue what they are doing.

Why don't you try something very simple and import this file

"product_sku","product_name"

"ABC","My ABC"

In the new template you create, set the Auto-detect delimiters to No and set the field delimiter to ,-symbol and the text enclosure to "-symbol.

Leave all other settings as they are. Import this file and see if you get the 500 error or not.

Hello, thank you for your reply.

1) I tried importing the file you mentioned but once again I get a 500 Internal Server Error.

2) My hosting admin replied back to my ticket and gave me the error logfile. I'm copy-pasting it in a private message ..

Hello,

Since the simple file won't work, I can't think of anything else we can try to see why the server kills CSVI.

As for the logfile, I am no server administrator, so I can only guess what is in there. I see twice an abort request processing but no reason as to why it is aborting.

If you are not bound to this hosting provider, there are others out there that will provide good hosting solutions that work and in case of issues know what to do.

Hello,

Well the Process never stops really. As soon as I click on the 'Process' button it starts Running however it never stops. The 'Time Running' keeps going indefinately so I eventually click on the Cancel button (that's why it probably shows it's aborting on the log files).

The 500 Error message appears immediately after I click on the Process Button eventhough it keeps on processing (whilst the error message is there)

The attached image shows it running for about an hour whilst the Error message was visible the whole time..

Hello,

As soon as I click on the 'Process' button it starts Running however it never stops. The 'Time Running' keeps going indefinately

That timer is not linked to your server or anything, it is a simple timer that starts when you click Process and won't stop unless it is stopped either by finishing the import or clicking on the Cancel button.

eventhough it keeps on processing (whilst the error message is there)

Nothing is being processed, timer runs regardless.

Since we are still lacking the real reason why the server kills the process, it will be hard to figure out what is wrong.