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

    r4211 schema issue

    Scheduled Pinned Locked Moved Solved
    Bug Reports
    2
    2
    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.
    • G
      Gilou
      last edited by

      installing from latest SVN on debian8 (on mysql 5.5), I encountered an error due to the latest schema update not mentioning the type of new columns. I suppose they are meant to be INT, but I guess it was just forgotten there 😉

      The following errors occured

      Update ID: 198 - 0

      Database Error:

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1

      Database SQL:

      ALTER TABLE fog.snapinGroupAssoc ADD COLUMN sgaPrimary

      Update ID: 198 - 1

      Database Error:

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1

      Database SQL:

      ALTER TABLE fog.imageGroupAssoc ADD COLUMN igaPrimary

      1 Reply Last reply Reply Quote 1
      • Tom ElliottT
        Tom Elliott
        last edited by Tom Elliott

        This has been fixed. It was an accidental mix up. I tested the code and found the problem and corrected. Then I overwrote my edits mistakenly and missed this file. Thank for reporting and it is now corrected for.

        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
        • 1 / 1
        • First post
          Last post

        211

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project