TYPO3 Forger
  • Dashboard
  • Get involved
  • Reviews
    Overview Ready for review Work in progress Needs action Needs review Needs verification Needs rebase Negative votes Reviewed and verified Ready to merge
  • Issues
    Stale issues Possible duplicates By category By month
  • Sprints
    Overview Initiatives TYPO3 Core Review board
  • Tools
    Backports ReST helper
  • Help
  • Search
  • Login
Esc

Words find the open ones, a number the issue and the change with it.

  1. Issues
  2. #82756
Issue Bug Closed

#82756Can't remove access starttime / endtime

Mike van Dee 10/13/17, 10:37 updated 10/02/18, 10:55

Open in Forge Comment in Forge

Description

I can’t remove the access start and endtime of tt_content block.

Create a tt_content block. Set start and or end time under the access tab. Save it. When you remove the start or end time an error will popup.

2: SQL error: 'Incorrect integer value: '' for column 'starttime' at row 1' (tt_content:44)

I use typo3 version 8.7.7

Reviews 2

  • TYPO3_8-7 56064[BUGFIX] Allow empty date/time in strict database modes Resolves this issue Merged Susi Moog CR +2 V +2 → main, 8.7 Normal +34 −34 03/12/18, 14:15
  • main 56062[BUGFIX] Allow empty date/time in strict database modes Resolves this issue Merged Oliver Hader CR +2 V +2 → 8.7 Normal +36 −36 03/08/18, 15:47

Related issues 3

  • Bug #63735High memory consumption in DataHandler->checkValue_SW while bulk inserting Related to Closed Performance v6.2 Stephan Großberndt 12/10/14, 13:09
  • Task #72610Officially support MySQL Strict Mode Related to Closed Documentation v8 Morton Jonuschat 01/08/16, 22:13
  • Bug #78921Copying records fails with SQL error without any message Related to Closed DataHandler aka TCEmain v7 Andreas Kießling 12/08/16, 12:54
Author
Mike van Dee
Priority
Must have
Category
DataHandler aka TCEmain
Target version
8.7.11
TYPO3 version
8
Complexity
hard
© 2026 TYPO3 GmbH.
  • API
  • Privacy Policy
  • Legal Notice
  • Feedback