Chromium OS Woes

rstockham23

@Tom-Elliott Thank you. I just attempted to upgrade to Trunk. Ran into some bumps. I was using Ubuntu 12 before and appeared PHP wasn’t going to be new enough, so I upgraded to Ubuntu 14 and then updated to Trunk. Appeared to be successful but when going to the Fog login page, I’m getting 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?

Tom Elliott

@rstockham23 Is that the EXACT message or you hand typed it?

rstockham23

@Tom-Elliott Exact…copy and pasted from the web browser I tried to access it with

Tom Elliott

@rstockham23 can you run a join.me session?

I’m unable to replicate.

Tom Elliott

@Tom-Elliott Send me number (if so) via chat.

rstockham23

@Tom-Elliott Let me ask you this real quick. If I create a brand new fog server from scratch with Trunk. Is there any way to transfer information from the old to the new? Images, registration information, etc? Or do you think I’d be better off trying to fix my current one?

Tom Elliott

@rstockham23 YOu can take a backup of hte current and do a fresh install. Once installed, re-import the old database and allow schema update (as necessary).

However, I don’t know what’s wrong and would much prefer to see it.

I imagine this can be fixed really easily.

Try this Please:

rm -rf /home/fog*.BACKUP /var/www/fog /var/www/html/fog /var/www/fog.prev /var/www/html/fog.prev

Then retry installing. If you have ISO’s please back them up (if they’re in the FOG Web root folders) before removing.

rstockham23

@Tom-Elliott Just tried removing all of those files and re-installing fog trunk. This time it did get to the screen in the installation where it said to access the site to update the schema and then hit Enter to continue. However again, when I went to the website to update the schema, I got this message on the browser:

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

Roger Saffle

just a heads up incase you didnt know, Chromium has been discontinued and replaced by CUB due to name issue complaints by Google. I havent looked at CUB and dont know how similar the are.

Wayne Workman

@rstockham23 said in Chromium OS Woes:

@Tom-Elliott Just tried removing all of those files and re-installing fog trunk. This time it did get to the screen in the installation where it said to access the site to update the schema and then hit Enter to continue. However again, when I went to the website to update the schema, I got this message on the browser:

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

Cross-linking similar posts:

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