error when adding device

[JohanBogema]

When adding a device I receive an empty error message in the UI as shown below

In the Apache error.log I see the following message appear:

PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'avoidToday' in 'field list' in /var/www/html/libs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77\nStack trace:\n#0 /var/www/html/libs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(77): PDO->prepare('insert into `de...', Array)\n#1 /var/www/html/libs/vendor/illuminate/database/Connection.php(452): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('insert into `de...')\n#2 /var/www/html/libs/vendor/illuminate/database/Connection.php(657): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('insert into `de...', Array)\n#3 /var/www/html/libs/vendor/illuminate/database/Connection.php(624): Illuminate\\Database\\Connection->runQueryCallback('insert into `de...', Array, Object(Closure))\n#4 /var/www/html/libs/vendor/illuminate/database/Connection.php(459): Illuminate\\Database\\Connection->run('insert into `de...', Array, Object(Closure))\n#5 /var/www/html/libs/vendor/illuminate/database/Connection.php(411) in /var/www/html/libs/vendor/illuminate/database/Connection.php on line 664, referer: https://172.16.11.129/

Is this a known issue for the 1.0.90 build? The only "strange" thing about the device is that it's accessible on a different port than 443.

[PAN-Expert · Accepted solution]

That is a bug with 1.0.90, 1.0.91 appears to have fixed it 

[charlesw]

Same exact issue here, running 1.0.91

[alestevez]

Hi, That's is weird, after the upgrade there is a script that updates the tables on the databases. Please can you try to run the command from the cli and see the output?

sudo php /var/www/html/bin/updates/updateSQL.php

[acrown]

I was having the same error as above until I manually ran the PHP script you linked.  I'm running 1.0.92.