Error Cases

How to deal with the following error or debug messages:

• No Content Object definition found at TypoScript object path "tt_content.list.20.5"

  • (1/1) #1540246570 TYPO3FluidFluidCoreViewHelperException
  • You must activate the extension tt_products in the Extension Manager or by Composer.

• Expression #1 of ORDER BY clause is not in SELECT list, references column 'db_t3test.tt_products_cat.sorting' which is not in SELECT list; this is incompatible with DISTINCT

  • You must change the mysql mode: Remove the ONLY_FULL_GROUP_BY option.
  • E.g. sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
  • see https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

Just insert this line into class.tx_ttproducts_main.php line 260:

$res = $GLOBALS['TYPO3_DB']->sql_query('SET SESSION sql_mode ='TRADITIONAL';');

• It looks like the character set "utf8" is not used for this connection even though it is configured as connection charset. The charset "utf8mb3" is used instead of it. This TYPO3 installation is using the $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['charset'] property with the following value: "utf8". Please make sure to configure your utft8 charset variant "utf8mb3"

  • You must edit the file LocalConfiguration.php under typo3conf and change the connection charset.

'DB' => [
    'Connections' => [
        'Default' => [
            'host' => 'localhost',
            'port' => 3306,
            'driver' => 'mysqli',
            'dbname' => 'mydatabase',
            'charset' => 'utf8mb4',
            'tableoptions' => [
                'charset' => 'utf8mb4',
                'collate' => 'utf8mb4_unicode_ci',
            ],
            'user' => 'myuser',
            'password' => 'mypassword',
        ],
    ],
    'extTablesDefinitionScript' => 'extTables.php',
],