All,
I upgraded my test system to Moodle 3.4. I have enabled the PHP settings to allow for larger file upload sizes. This is a SCORM file. It goes to the end of the upload and then seems to stop and gives the "Error connecting to server" message. I have debugging turned on and do not see any other errors. Where do I look to start to debug this issue?
Sincerely,
Peter
I know it's not very likely these days but first check your server is 64Bit. 32Bit installs have a file size limit of 2GB.
Next, switch on Debugging, reproduce the error, and check your web server's error log. Hopefully, something that will help pinpoint the problem will have been logged.
Dear Howard,
Would you tell me the location of the log files?
Peter
Go to Site administration > Server > PHP Info. Search for the 'error_log' setting. This shows you the location of PHP log output.
Hi Howard,
Thanks for that information. The only ting I see in the file is the following:
[04-Jan-2018 14:32:59 UTC] PHP Warning: Module 'ldap' already loaded in Unknown on line 0
Not sure what it indicates.
Peter
Hi Peter,
could you share what are the changes you've made on your PHP settings?
I'd like to see both the numbers and the parameters involved in your change.
HTH,
Matteo
Hello,
Thank you for your help. We are using IIS – Version 7.5.7600.16385 and PHP – Version 7.1. I have attached our php.ini file per your request. I appreciate any assistant you can provide.
Sincerely,
Peter
Hi Peter,
TNX for the info, I was looking for:
post_max_size = 0
upload_max_filesize = 102400M
since post_max_size should be at least 30% greater than upload_max_filesize. Here, we're fine.
PHP 7.1 actually supports 64 bit integers in Windows, so guessing an issue w/ IIS configuration or other settings:
BTW you could use a File System repository to avoid uploading files via HTTP (it will requires another way to upload files in the folder mapped into that repository, e.g. a UNC trusted path since you're on Windows) e.g. https://moodle.org/mod/forum/discuss.php?d=363474#p1465950 .
Edit: you should not rely on wincache (php_wincache.dll) but stick w/ opcache since Moodle supports only opcache.
HTH,
Matteo
Hello,
We made the suggested changes and rebooted the server. We still get the generic upload error message. We transferred the file to the Moodle server (Windows 2008 R2). We then attempted to load the file from the Moodle server's file system and we get the error on the attached image.
Hi Peter,
the (in)famous SyntaxError popup means that the supposed JSON reply is broken i.e. is not a valid JSON probably due to some chars representing the HTML/text error we're searching for.
Open the browser Dev Tools using <F12> and then go to the Network pane, replicate the steps and then inspect all the rows w/ type xhr selecting one by one and look for its response body in the related Response tab.
HTH,
Matteo
Good Day Friends!
I have taken your advice and have been tweaking the PHP file. Now when I try the upload I get the following error:
[09-Jan-2018 06:45:04 America/Tegucigalpa] PHP Warning: sqlsrv_free_stmt(): supplied resource is not a valid ss_sqlsrv_stmt resource in C:\inetpub\wwwroot\moodle\lib\dml\sqlsrv_native_moodle_recordset.php on line 135
We are using SQL Server as our database.
Does this get us any further?
Peter
Hi Peter,
I do not use MSSQL but for DEV purposes in Moodle: it looks like a timing issue with the underling connection closing before the code could do its job. It should not be a big issue unless it is the root cause for the JSON Syntax Error.
Are you still unable to upload that huge file?
HTH,
Matteo
Hello,
No, I am still not able to upload the file. I still get the generic error. No errors in the PHP error logs. To me, it appears to be a timing issue, as the upload starts and the progress bar continue to move across the screen. At the very end it just stops with the error.
Peter