06-20-2018 08:15 AM - edited 06-20-2018 08:16 AM
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.
06-21-2018 02:07 PM
That is a bug with 1.0.90, 1.0.91 appears to have fixed it
06-21-2018 02:07 PM
That is a bug with 1.0.90, 1.0.91 appears to have fixed it
06-21-2018 05:49 PM
Same exact issue here, running 1.0.91
06-22-2018 03:52 AM
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
06-22-2018 10:58 AM
I was having the same error as above until I manually ran the PHP script you linked. I'm running 1.0.92.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!