Hello Denis, you will have to compare the current schema and the schema from this file : https://github.com/inverse-inc/packetfence/blob/devel/db/pf-schema-6.4.0.sql
Connect to the db pf and do :explain node; and compare ... regards Fabrice Le 2017-06-14 à 11:16, denis via PacketFence-users a écrit : > Hello, > > I'm running a 6.4 PF server, upgraded from 4.x 6 months ago. > > Primary functionnalities ( 802.1x, vlan enforcement, > autoregistration...) are working as expected, but nodes databases > seems to be corrupted : > > > - node status is always unknown, switches and ports are not displayed > on node info, > > - reevaluate access gives and error and does nothing. > > - packetfence.log has a lot of errors like > > Jun 14 17:00:36 httpd.aaa(9080) INFO: [mac:28:84:fa:f7:f8:c8] database > query failed with: Unknown column 'role' in 'field list' (errno: 1054) > (pf::db::db_query_execute) > > Apart from that it works. > > > When upgrading db from 4.x i was very cautious in applying schema > updates, but it looks like something goes wrong. I'm not expert in db, > so if someone can help me to correct this problem, i will be happy to > do this before upgrading to 7.1. > > Thanks > > Denis > > > > ------------------------------------------------------------------------------ > > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users -- Fabrice Durand fdur...@inverse.ca :: +1.514.447.4918 (x135) :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence (http://packetfence.org) ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users