PHP warnings and error in due of PHP 7.1.12 update

Re: PHP warnings and error in due of PHP 7.1.12 update

by Adrian Perez Rodriguez -
Number of replies: 4
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: -
In reply to Adrian Perez Rodriguez

Re: PHP warnings and error in due of PHP 7.1.12 update

by Matteo Scaramuccia -
Picture of Core developers Picture of Peer reviewers Picture of Plugin 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: -
In reply to Matteo Scaramuccia

Re: PHP warnings and error in due of PHP 7.1.12 update

by Adrian Perez Rodriguez -

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: -
In reply to Adrian Perez Rodriguez

Re: PHP warnings and error in due of PHP 7.1.12 update

by Matteo Scaramuccia -
Picture of Core developers Picture of Peer reviewers Picture of Plugin 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: -
In reply to Matteo Scaramuccia

Re: PHP warnings and error in due of PHP 7.1.12 update

by Adrian Perez Rodriguez -
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: -