PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab/htm

Before posting something, READ the changelog, WATCH the videos, howto and provide following:
Your install is: Bare metal, ESXi, what CPU model, RAM, HD, what EVE version you have, output of the uname -a and any other info that might help us faster.

Moderator: mike

Post Reply
adsfadsfadsfdwf
Posts: 24
Joined: Thu Mar 23, 2017 10:07 am

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab/htm

Post by adsfadsfadsfdwf » Fri Sep 15, 2017 1:10 pm

Getting HTTP 500 when I try to log into eve-ng

stuff I did prior to getting the error
apt-get update && apt-get upgrade
deleted files under /opt/unetlab/tmp/0
added a second hard drive
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab/html/includes/api_aut
hentication.php:108
Stack trace:
#0 /opt/unetlab/html/includes/api_authentication.php(108): PDOStatement->execute()
#1 /opt/unetlab/html/api.php(121): apiLogin(Object(PDO), Object(PDO), Array, '99818686-6ce0-4...')
#2 [internal function]: {closure}()
#3 /opt/unetlab/html/includes/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)
#4 /opt/unetlab/html/includes/Slim/Slim.php(1357): Slim\Route->dispatch()
#5 /opt/unetlab/html/includes/Slim/Middleware/Flash.php(85): Slim\Slim->call()
#6 /opt/unetlab/html/includes/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()
#7 /opt/unetlab/html/includes/Slim/Middleware/PrettyExceptions.php(67): Slim\Middleware\MethodOverride->call()
#8 /opt/unetlab/html/includes/Slim/Slim.php(1302): Slim\Middleware\PrettyExceptions->call()
#9 /opt/unetlab/html/api.php(1339): Slim\Slim->run()
#10 {main}

ecze
Posts: 489
Joined: Wed Mar 15, 2017 1:54 pm

Re: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab

Post by ecze » Fri Sep 15, 2017 11:15 pm

on cli:

cat /opt/unetlab/schema/guacamole-update.sql | mysql -u root --password=eve-ng guacdb

E.

adsfadsfadsfdwf
Posts: 24
Joined: Thu Mar 23, 2017 10:07 am

Re: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab

Post by adsfadsfadsfdwf » Sat Sep 16, 2017 8:22 am

ecze wrote:
Fri Sep 15, 2017 11:15 pm
on cli:

cat /opt/unetlab/schema/guacamole-update.sql | mysql -u root --password=eve-ng guacdb

E.

Thanks. That fixed it. Did database schema change in recent updates?

ecze
Posts: 489
Joined: Wed Mar 15, 2017 1:54 pm

Re: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab

Post by ecze » Sun Sep 17, 2017 12:47 am

Yes, latest html5 engine need new table's fields

E.

Post Reply