topic Re: error when adding device in Expedition Discussions

error when adding device

Retired Member — Wed, 20 Jun 2018 15:16:57 GMT

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.

Re: error when adding device

PAN-Expert — Thu, 21 Jun 2018 21:07:04 GMT

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

Re: error when adding device

charlesw — Fri, 22 Jun 2018 00:49:54 GMT

Same exact issue here, running 1.0.91

Re: error when adding device

alestevez — Fri, 22 Jun 2018 10:52:47 GMT

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

Re: error when adding device

acrown — Fri, 22 Jun 2018 17:58:31 GMT

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

Re: error when adding device

charlesw — Fri, 22 Jun 2018 18:05:15 GMT

That script did it for me, as well. Thanks!

Re: error when adding device

NickFreeman — Fri, 16 Nov 2018 15:53:10 GMT

I have this issue on 1.0.107 . Running the sudo php /var/www/html/bin/updates/updateSQL.php made no difference. Any ideas?

Re: error when adding device

alestevez — Mon, 26 Nov 2018 18:09:01 GMT

Maybe did you UPGRADE the OS? with something like "apt-get updagre" ?

If yes you should downgrade it or download it again and dont use the Upgrade or dist-upgrade commands, just use

sudo apt-get update
sudo apt-get install expedition-beta

There is something in newer version of the packages in the new OS version that breaks expedition so keep it in 16.04 dont upgrade to 18.04

Re: error when adding device

prasetya — Mon, 13 May 2019 15:20:45 GMT

my expedition 1.1.17 and i found this error after upgrade and try to sudo apt-get dist-upgrade but result its still error.

try to sudo php /var/www/html/bin/updates/updateSQL.php and the result PHP FATAL ERROR not found /var/www/html/bin/updates/updateSQL.php

anyone have another solution?

Re: error when adding device

dgildelaig — Mon, 13 May 2019 18:36:12 GMT

It is in the documentation that we should perform "apt-get update" but do not perform "upgrade", as it will break Expedition dependencies by updating some packages that have modified their internal APIs.

I am sorry to say, but you may have to collect a new Expedition VM.