FOG Project

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

    Renumbering Image IDs

    FOG Problems
    3
    5
    45
    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.
    • DJslimD1k
      DJslimD1k last edited by

      Hope you fine folks are doing well! While I’m running the community script to change my Image ID numbers, I get this error at the end of the script. Has anyone else seen this issue? ERROR 1292

      fdf31d85-1bb1-4bde-8ec6-523c2023d1fc-image.png

      1 Reply Last reply Reply Quote 0
      • george1421
        george1421 Moderator @Wayne Workman last edited by george1421

        @Wayne-Workman What has happened is mariadb starting at version 10 (?? I think) added some default values to mysql startup that are causing an issue with some of FOG’s default values (such as 0’s in date fields) I think we need to update the schema to use a invalid, but valid date of something like 1/1/1900 instead of 0/0/0000 as an unset date.

        Again its not a problem with the renumber script, but the default startup values used for the sql server that was introduced with the later releases of mariadb.

        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 1
        • Wayne Workman
          Wayne Workman last edited by

          @george1421 is this something we could add to the script?

          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!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          george1421 1 Reply Last reply Reply Quote 0
          • george1421
            george1421 Moderator last edited by

            I realize this thread talks a lot about other things but this post should get you pretty close. https://forums.fogproject.org/topic/14254/high-cpu-usage/10

            You need to set the sqlmode parameter without the NO_ZERO_IN_DATE and NO_ZERO_DATE values. Then restart mysql and then rerun the command that should take care of the zero date error.

            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 1
            • george1421
              george1421 Moderator last edited by

              Its not specifically an issue with the community script but a default setting ubuntu has added to the mysql startup. Let me see if I can find the fix.

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

              257
              Online

              10.2k
              Users

              16.3k
              Topics

              149.9k
              Posts

              Copyright © 2012-2020 FOG Project