UBNT Unifi upgrade issues

Recently my best friend installed some unifi access points in his home.  We had ordered a 60W unifi switch, a couple of AP-LR, and a couple of AC-Lites.  These were ordered and sat for several months until we could get around to installing them.  Upon installation, the AC Lites were adopted and had to go through the normal upgrades to bring them up to the latest version.

However, the AP-LRs were used and had very old firmware on them and would not upgrade properly. They would adopt but not upgrade.  We fixed this in the following ways.
1. We Factory reset the APs. At this point, they grabbed DHCP from the local network. Quick ssh into the AP verified it had internet connectivity.

2. I was able to find some old firmware on the UBNT web-site.  We issued the following command to each LR AP

upgrade http://dl.ubnt.com/unifi/firmware/BZ2/3.7.58.6385/BZ.ar7240.v3.7.58.6385.170508.0942.bin

the “HTTP” is important to note.  If you copy the link directly from the UBNT website it has https in it.  The older firmware blows an error due to invalid certs (fixed in newer versions).

Once it came back we were able to upgrade from the controller.

PHPIPAM upgrade 1.3.2 to 1.4 error and fix

Tonight I was upgrading PHPIPAM from version 1.3.2 to version 1.4 and ran into an issue.  After doing a git pull I logged into the web GUI and went to upgrade the database.  I receive the following error.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dbversion' in 'field list'

Since I run Webmin, I logged into Webmin and ran the following command on my database

alter table settings add column dbversion tinyint(1);

Once that was executed I was able to go back into the web GUI and upgrade the database.  I ended up with two theme errors which were easily fixed.

Cleaning Dude Database in Version 4

This content is for Patreon subscribers of the j2 blog. Please consider becoming a Patreon subscriber for as little as $1 a month. This helps to provide higher quality content, more podcasts, and other goodies on this blog.
To view this content, you must be a member of Justin Wilson's Patreon
Already a qualifying Patreon member? Refresh to access this content.