• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Oct 24, 2015, 11:04 PM

    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
    • T
      Tom Elliott
      last edited by Tom Elliott Oct 24, 2015, 9:43 PM Oct 25, 2015, 3:43 AM

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

      161

      Online

      12.1k

      Users

      17.3k

      Topics

      155.3k

      Posts
      Copyright © 2012-2024 FOG Project