SQL Error After Updating to Trunk at Login

[rstockham23]

I updated to Trunk today from 1.2.0 and the install was succesful with no errors, however after the update when accessing the website to login, I get this error instead:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘hosts.hostPending’ in ‘where clause’ SQL: [93] SELECT COUNT(hosts.hostID) AS total FROM hostsWHERE hosts.hostPending=‘1’ LIMIT 1 Params: 0

Any thoughts?

[slparker09]

I have/had this same error. I upgraded an existing 1.2.0 server (which was working fine) yesterday and it never came back online. I received the same errors when upgrading and installing. OP’s issue was the first thing I encountered.

I was never able to get passed it to install/update the DB schema. My next step was to do a fresh install of Debian 8.5 and Ubuntu 16.x and try to install trunk from the start. This resulted in the installer failing to create the DB at all.

Logging into MySQL showed that the database “fog” did not exist after running the installer. I am now reinstalling a 1.2.0 server so we have a working system again; unfortunately it is next to useless due to its inability to boot to UEFI/secure boot on our new and existing systems.

Is there a reason why the current trunk is neglecting to install the DB?

Update: Fresh install of Debian 8.x. Fresh install of 1.2.0. Everything working out of the box. Upgraded to current trunk via git, installed it and receive:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘hosts.hostPending’ in ‘where clause’ SQL: [93] SELECT COUNT(hosts.hostID) AS total FROM hostsWHERE hosts.hostPending=‘1’ LIMIT 1 Params: 0

when visiting <IP>/fog/management after. No DB update. No access to update the schema. Just this error.

Update:

Also receive this every time I run the installer:

########################################################################################
FOG has adjusted to using a login system to protect what can/cannot be downloaded
We have detected that you don’t have credentials defined to perform the backup
If you would like the database to be backed up during install please define
in your /opt/fog/.fogsettings file

fogguiuser=‘usernameOfFOGGUI’
fogguipass=‘passwordOfFOGGUIUser’

You can also re-run this installer as:

fogguiuser=‘usernameOfFOGGUI’ fogguipass=‘passwordOfFOGGUIUser’ ././installfog.sh
########################################################################################

But doing what it says doesn’t result in any change or fix.

[Wayne Workman]

Cross linking similar threads:

https://forums.fogproject.org/topic/7855/sql-error-when-upgrading-database-schema

https://forums.fogproject.org/topic/7876/installation-error-fresh-install-with-current-git-trunk-version

https://forums.fogproject.org/topic/7873/sql-error-after-updating-to-trunk-at-login

https://forums.fogproject.org/topic/7870/chromium-os-woes/9

https://forums.fogproject.org/topic/7862/nfs-mount-fails-network-unreachable/16

[Tom Elliott]

This should now be fixed.

[slparker09]

@Tom-Elliott

This resolved our issues. Thank you for the great support. I now have a working FOG server again; now on trunk. I hope this makes our upgrades to Windows 10 Edu easier over summer break.

Thanks, again!