Incorrect datetime value: '2023-03-26 01:46:08' for column `dbispconfig`.`dns_rr`.`stamp` at row 1

Discussion in 'General' started by northumberland, Mar 26, 2023.

Tags:
  1. northumberland

    northumberland New Member

    Maybe I shouldn't have updated DNS during daylight savings hours over here in the UK..
    Likely to go away after tomorrow, or is this something else?
    Daemon.log did complain of timestamp being in the future.
    Running on bullseye with latest ispconfig.
    Thanks
    Steve
     
    Last edited: Mar 26, 2023
    northumberland, Mar 26, 2023
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Datetime values in MySQL can be in the past or future, so this should not be an issue. Try updating the DNS record again.
     
    till, Mar 26, 2023
    #2
  3. northumberland

    northumberland New Member

    Solved, today but I think there's more to it.
    When the error occurred it was in the GUI, troubleshooting was where I spotted the 'in the future'.

    After the error in the GUI, I tried and retried but the error persisted, any changes to DNS for any domain or record would simply show a page in the GUI with that error at the top and nothing would be updated. I restarted services but still persisted.

    Changes I made to the dns were in the hours where DST ook effect.

    All okay today, but perhaps there is a bug somewhere and if needed I'm willing to to send it you be whatever logs you might need.

    Thanks dude
     
    northumberland, Mar 26, 2023
    #3

Share This Page