• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.
  • G
    george1421 Moderator
    last edited by george1421 Sep 27, 2020, 2:25 PM Sep 27, 2020, 8:19 PM

    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
    • T
      Tom Elliott
      last edited by Sep 27, 2020, 8:56 PM

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

      162

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project