Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format, MysqlEngine:68

[menturion]

Hi, I am getting the following error:

PHP Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'TeamTNTTNTSearchStemmerNoStemmer' for column 'value' at row 2 in /MysqlEngine:68

tntsearch/src/Engines/MysqlEngine.php

Line 68 in 781e0ee

$this->index->exec("INSERT INTO ".$this->indexName."_info ( `key`, `value`) values

Without changing the types, I can solve this by disabling strict MySQL mode.

[menturion]

tntsearch/src/Engines/MysqlEngine.php

Lines 68 to 72 in 781e0ee

	$this->index->exec("INSERT INTO ".$this->indexName."_info ( `key`, `value`) values
	( 'total_documents', 0),
	( 'stemmer', 'TeamTNT\TNTSearch\Stemmer\NoStemmer'),
	( 'tokenizer', 'TeamTNT\TNTSearch\Support\Tokenizer')"
	);

needs to be escaped like ...

        $this->index->exec("INSERT INTO ".$this->indexName."_info ( `key`, `value`) values 
            ( 'total_documents', 0), 
            ( 'stemmer', 'TeamTNT\\\\TNTSearch\\\\Stemmer\\\\NoStemmer'), 
            ( 'tokenizer', 'TeamTNT\\\\TNTSearch\\\\Support\\\\Tokenizer')"
        );

Otherwise string "TeamTNTTNTSearchStemmerNoStemmer" gets stored in the DB which isn't a valid stemmer class instantiated at \teamtnt\tntsearch\src\TNTSearch.php:325, see ...

tntsearch/src/TNTSearch.php

Line 325 in 781e0ee

$this->stemmer = new $stemmer;