Installing and upgrading help

PHP warnings and error in due of PHP 7.1.12 update

 
Picture of Adrian Perez Rodriguez
Re: PHP warnings and error in due of PHP 7.1.12 update
 
Hello Moodlers

Did somebody of you have some idea where's the dog is buried? It's really frustrating because I'm not progressing in this case. In the mean time there's a new php built:

  • PHP 7.1.12 (cli) (built: Dec  1 2017 13:53:12) ( NTS )
    • php-7.1.12-4.el7.remi.x86_64

The old built was the 7.1.12-3 one! But the errors still exists.

Thanks for helping out!
Adrian

 
Average of ratings: -
Picture of Matteo Scaramuccia
Re: PHP warnings and error in due of PHP 7.1.12 update
Core developersParticularly helpful MoodlersPlugin developers

Hi Adrian,
please follow MDL-60987.

In the mean time try to revert to PHP 7.0.x, 7.1.13 is coming (08/01/2018) and maybe - not sure at all right now - it will fix your issue; RC1 is already available: https://github.com/php/php-src/blob/049f993190d73ded614d84291412aabc8600daf6/NEWS#L3 => https://blog.remirepo.net/post/2017/12/08/PHP-version-7.0.27RC1-and-7.1.13RC1 .

HTH,
Matteo

 
Average of ratings: -
Picture of Adrian Perez Rodriguez
Re: PHP warnings and error in due of PHP 7.1.12 update
 

Hello Matteo

Thanks for your post! I've tested it with the 7.1.13RC and now both, the error and the warning are gone! 


What's interesting, is following:

  • The search on https://<FQDN>/admin/search.php works on a clean moodle 3.3.5+ setup with php 7.1.12 
  • The same works on the "broken existing platform" (moodle 3.3.5+) only with php 7.1.11 or 7.1.13
  • I've 1:1 the same application environment and only changed the database configuration.


The second thing, the "narrowing..." and "notifications" warning, it's a bug in PHP 7.1.12 because:

  • It occurs when debugging is enabled on a clean moodle and on the existing broken platform running  php 7.1.12
  • Running on PHP 7.1.11 or 7.1.13 doesn't gives this warning.
  • But the first error must be something in our database, maybe in the mdl_config table? It's strange that this sql statement query is running false with the PHP 7.1.12 version.


We'll stay now on 7.1.11 on the productive platform until 7.1.13 is released!

Kind regards
Adrian

 
Average of ratings: -
Picture of Matteo Scaramuccia
Re: PHP warnings and error in due of PHP 7.1.12 update
Core developersParticularly helpful MoodlersPlugin developers
It's strange that this sql statement query is running false with the PHP 7.1.12 version

The broken SQL is the result not the root cause, mostly (guessing) due to opcache and function calls.

HTH,
Matteo

 
Average of ratings: -
Picture of Adrian Perez Rodriguez
Re: PHP warnings and error in due of PHP 7.1.12 update
 
The broken SQL is the result not the root cause, mostly (guessing) due to opcache and function calls.

As I say here https://moodle.org/mod/forum/discuss.php?d=362349#p1461346, the problem ist that the caps array has not the right capabilities and then the roleid is "NULL". And the strange thing is, that the error must come from the database (I explain it in the previous comments, what I've done...). 

So what I think is, that moodle can't access the right capabilities from the database and then this "SELECT ... statemenet" for search through the site administration gives an error. 

Why this behaviour happened only with PHP 7.1.12 is also dubious.

 
Average of ratings: -