[BUG] PHP Fatal error: Uncaught TypeError: scenario::getTimeout(): Return value must be of type int, null returned

[spyjo]

Description

Hello,

After an upgrade from 4.5 to 4.6 stable, I have this error in logs:

PHP message: PHP Fatal error: Uncaught TypeError: scenario::getTimeout(): Return value must be of type int, null returned in /var/www/jeedom/core/class/scenario.class.php:1875

It seems related to one specific scenario because in Jeedom message center, I have this message multiple times : "La dernière exécution du scénario ne s'est pas lancée. Vérifiez le log scenario_execution, ainsi que le log du scénario "Extinction chauffe serviette"."

And when I try to open this specific scenario, the page doesn't load, so I can't edit it.
This scenario is here since more than 5 years without issue before.

Thanks

Type de matériel / Hardware type

Autre / Other

Version de Jeedom / Jeedom Version

4.6

Navigateur / Browser

Chrome

Étapes pour reproduire / Steps to reproduce

no specific step

Logs

No response

[Mips2648]

Hello,

Is it possible to have a copy of the scenario? (in case you rollback to the previous version)
If not, do you recall if you had code block in it or only standard block?

[spyjo]

I can't open the scenario due to the php error, but I'm pretty sure it's only using standard blocks.

I can export it manually through Phpmyadmin if you have the right sql query to do so

[spyjo]

I searched the scenario in Phpmyadmin, and I just saw the column "timeout" was NULL for this scenario, instead of "0". Just changed the value and the error disappeared :)

May be it's something to be checked in the upgrade process to avoid this issue for other Jeedom users

[Mips2648]

yes indeed, I was on the same track; you can identify all potential cases with such query:
SELECT * FROM scenarioWHEREtimeout is null
and the correction is clear: set 0 instead off null

a fix is ready: develop...hotfix/scenario-pdo-hydratation