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

Schema Update Problem in 1.0.1

Scheduled Pinned Locked Moved
FOG Problems
4
7
2.5k
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.
  • B
    BigMan99211
    last edited by May 19, 2014, 9:09 PM

    See the attached image…

    I’m getting this error when updating to 1.0.1 and running the Schema update. I have this FOG server running at one of my other branch locations, and hasn’t been updated since early April (17th) I believe. What you see is only a couple of the errors. You can see the scroll bar on the side of the page indicating there are quite a few more.

    What can be done to fix this?

    [url=“/_imported_xf_attachments/0/794_Fog_Schema_Update_Issue.jpg?:”]Fog_Schema_Update_Issue.jpg[/url]

    "Failure is not an option. It come pre-installed on Windows…" - Anonymous

    "Life is hard; It's harder if you're stupid" - John Wayne

    1 Reply Last reply Reply Quote 0
    • W
      Wolfbane8653 Developer
      last edited by May 20, 2014, 11:58 AM

      When installing fog did you input a password in for mysql?

      If so you will need to change that in a config.php file. I can’t remember the location off the top of my head.

      1 Reply Last reply Reply Quote 0
      • T
        Tom Elliott
        last edited by May 20, 2014, 12:01 PM

        To me, it appears, that somebody has reset the schema version in the database table to 0.

        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

        1 Reply Last reply Reply Quote 0
        • B
          BigMan99211
          last edited by May 20, 2014, 12:17 PM

          I don’t understand how that would be possible. I upgraded it the exact same way that I did my main FOG server here.

          So, if somehow the version is set to 0, how do I fix it?

          "Failure is not an option. It come pre-installed on Windows…" - Anonymous

          "Life is hard; It's harder if you're stupid" - John Wayne

          1 Reply Last reply Reply Quote 0
          • T
            Tom Elliott
            last edited by May 20, 2014, 12:22 PM

            To check what value it currently displays:
            [code]SELECT vValue FROM schemaVersion;[/code]
            To set it to a more recent version: Probably 96
            [code]UPDATE schemaVersion SET vValue=‘96’;[/code]

            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

            1 Reply Last reply Reply Quote 0
            • B
              BigMan99211
              last edited by May 20, 2014, 12:47 PM

              I’m assuming that I would be running those commands in the MySQL interface…

              But, how do I log into it remotely?
              I’m using Putty, and every time I try to run MySQL, it gives me Access Denied.

              "Failure is not an option. It come pre-installed on Windows…" - Anonymous

              "Life is hard; It's harder if you're stupid" - John Wayne

              1 Reply Last reply Reply Quote 0
              • S
                SaxxAppeal
                last edited by May 21, 2014, 8:11 AM

                I had this same issue on my last reinstall, and corrected it.

                First, as WolfBane said, you must make sure if you set a MySQL password, you update your config.php file.

                Other than that, the fix that worked for me for this issue was to stop and start the MySQL service. After that it works fine. Try running the following in Terminal:
                [CODE]sudo service mysql stop
                sudo service mysql start[/CODE]

                If you go to the web interface after this, click next on the database schema update page, does it let you go on? If yes, then see my permanent fix for this solution [URL=‘http://fogproject.org/forum/threads/mysql-problem-what-am-i-doing-wrong.10515/#post-27515’]here[/URL].

                Hope this works for you, let us know!

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

                192

                Online

                12.0k

                Users

                17.3k

                Topics

                155.2k

                Posts
                Copyright © 2012-2024 FOG Project