DataTables logo
≡

Editor throws sql-format error

Editor throws sql-format error

rostrost Posts: 26Questions: 9Answers: 1
in Free community support

Error messages shown: "An SQL error occurred: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer va..."
Description of problem:
Running editor with 'native' data works fine.
Now I imported some more data via phpmyadmin, and the data are displayed well. Only when I try to save a row which is opened in the editor, it throws the error "An SQL error occurred: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date val..."
I tried to find out where it comes from (disabled the code that does the validation, which has no effect. Refilled the date-related fields by the editor - no better.) and some attempts more - but now I'm stuck.
Could someone please give me an advice how to find out where the problem arises from?

Answers

  • rostrost Posts: 26Questions: 9Answers: 1

    Ok, found out how to display the trucated error-message: marking the message and displaying it by right-clicking 'show marked source-text' helped along...

    BTW: the error came from NULL in integer-fields - using

    ->setFormatter( Format::ifEmpty( null )),

    did the trick.

This discussion has been closed.