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

    Feature request for FOG 1.6.x - Change default mysql date from invalid 00/00/0000

    Scheduled Pinned Locked Moved
    Feature Request
    2
    2
    241
    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.
    • george1421G
      george1421 Moderator
      last edited by george1421

      Many of the new implementation of the mysql/mariadb/percona have default settings that are causing issues within fog. Specifically these two parameters are now default when the database starts.

      NO_ZERO_IN_DATE and NO_ZERO_DATE

      FOG uses a default dates of 00/00/0000 for some fields, which causes an issue when converting the mysql database format from ISAM to INNODB. FOG should pick a valid yet improbable date as a null date like 1/1/1980 (the old folks will know this date) or 1/1/2000 (for the millennial) as the default improbable date instead of 00/00/0000.

      ref: https://forums.fogproject.org/topic/14254/high-cpu-usage/9?_=1601237694089

      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!

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

        Fog 1.6 already does this.

        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

        206

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project