• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

SQL Error After Updating to Trunk at Login

Scheduled Pinned Locked Moved
FOG Problems
4
5
1.1k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R
    rstockham23
    last edited by Jun 22, 2016, 4:23 PM

    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?

    1 Reply Last reply Reply Quote 0
    • S
      slparker09
      last edited by slparker09 Jun 22, 2016, 12:58 PM Jun 22, 2016, 5:48 PM

      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.

      1 Reply Last reply Reply Quote 0
      • W
        Wayne Workman
        last edited by Wayne Workman Jun 22, 2016, 1:51 PM Jun 22, 2016, 7:34 PM

        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

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
        Daily Clean Installation Results:
        https://fogtesting.fogproject.us/
        FOG Reporting:
        https://fog-external-reporting-results.fogproject.us/

        1 Reply Last reply Reply Quote 0
        • T
          Tom Elliott
          last edited by Jun 22, 2016, 7:50 PM

          This should now be fixed.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          S 1 Reply Last reply Jun 24, 2016, 1:25 PM Reply Quote 0
          • S
            slparker09 @Tom Elliott
            last edited by Jun 24, 2016, 1:25 PM

            @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!

            1 Reply Last reply Reply Quote 0
            • 1 / 1
            1 / 1
            • First post
              2/5
              Last post

            158

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project