PacketFence - BTS - PacketFence
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001818PacketFenceupgradepublic2014-08-19 17:412014-08-19 21:18
Reportercpross90 
Assigned Tofrancis 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformLinuxOSRHEL / CentOSOS Version6
Product Version4.2.2 
Target VersionFixed in Version 
fixed in git revision
fixed in mtn revision
Summary0001818: Schema Update Incomplete
DescriptionWhen upgrading to the most recent version switch_ip and switch_mac columns were not added to the locationlog when the schema update was run; nor was the code found in the updates for adding the columns.
Steps To ReproduceUpgraded from 4.1, ran schema update for 4.1 -> 4.2, and finally ran update for 4.2 -> 4.3.
Additional InformationAfter adding columns to the locationlog table in mysql pf was able to read from locationlog table.
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-19 17:41cpross90New Issue
2014-08-19 20:36francisNote Added: 0003575
2014-08-19 20:54cpross90Note Added: 0003576
2014-08-19 21:18francisStatusnew => closed
2014-08-19 21:18francisAssigned To => francis
2014-08-19 21:18francisResolutionopen => no change required

Notes
(0003575)
francis   
2014-08-19 20:36   
It looks like you forgot to run the upgrade script from 4.0 to 4.1:

https://raw.githubusercontent.com/inverse-inc/packetfence/stable/db/upgrade-4.0.0-4.1.0.sql [^]
(0003576)
cpross90   
2014-08-19 20:54   
That would be the problem.

Thanks!