MJ, That’s strange. You are effectively missing the “login_remaining” column in the “password” table. It should be part of the upgrade-5.7.0-6.0.0.sql script.
Can you open it and tell me what you have at line 35 of that file ? Thanks Cheers! -dw. — Derek Wuelfrath [email protected] :: +1.514.447.4918 (x110) :: +1.866.353.6153 (x110) Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) > On Sep 23, 2016, at 10:19, mj <[email protected]> wrote: > > Hi Derek, > > Thanks for the response. > >> Can you send output of ‘explain password’ in MySQL. > Here it is: > >> mysql> explain password >> -> ; >> +-----------------+--------------+------+-----+---------------------+-------+ >> | Field | Type | Null | Key | Default | Extra | >> +-----------------+--------------+------+-----+---------------------+-------+ >> | pid | varchar(255) | NO | PRI | NULL | | >> | password | varchar(255) | NO | | NULL | | >> | valid_from | datetime | YES | | NULL | | >> | expiration | datetime | NO | | NULL | | >> | access_duration | varchar(255) | YES | | NULL | | >> | access_level | varchar(255) | YES | | NONE | | >> | category | int(11) | YES | | NULL | | >> | sponsor | tinyint(1) | NO | | 0 | | >> | unregdate | datetime | NO | | 0000-00-00 00:00:00 | | >> +-----------------+--------------+------+-----+---------------------+-------+ >> 9 rows in set (0.00 sec) >> >> mysql> > >> >> Can you also send the output of 'select * from pf_version;’ in MySQL. > > Here: >> mysql> select * from pf_version;’ >> +--------+---------+ >> | id | version | >> +--------+---------+ >> | 327936 | 5.1.0 | >> | 328192 | 5.2.0 | >> | 328448 | 5.3.0 | >> | 328704 | 5.4.0 | >> | 328960 | 5.5.0 | >> | 329216 | 5.6.0 | >> | 329472 | 5.7.0 | >> | 393216 | 6.0.0 | >> | 393472 | 6.1.0 | >> | 393728 | 6.2.0 | >> +--------+---------+ >> 10 rows in set (0.00 sec) > > All looking good it seems... > > MJ > > ------------------------------------------------------------------------------ > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
