Search code examples
typo3typo3-extensions

TYPO3 version 6 to version 8 compatibility issues

While upgrading typo3 version 6 to 8.7.3 getting this database error... 

An exception occurred while executing 'SELECT `pid` FROM `sys_template` WHERE (root = 1 AND deleted = 0 AND hidden = 0 AND starttime <= :starttime AND (endtime = 0 OR endtime > :endtime)) AND ((`sys_template`.`deleted` = 0) AND (`sys_template`.`hidden` = 0) AND (`sys_template`.`starttime` <= 1500543000) AND ((`sys_template`.`endtime` = 0) OR (`sys_template`.`endtime` > 1500543000)))': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':starttime AND (endtime = 0 OR endtime > :endtime)) AND ((`sys_template`.`delete' at line 1

Please review the screen shot.

Error while upgrading the project

Getting the error while performing Database analyzer

Solution

  • DB Configuration variables have changed from TYPO3 v7 to v8 ^^

    It is not

    $GLOBALS['TYPO3_CONF_VARS']['DB']['database'] $GLOBALS['TYPO3_CONF_VARS']['DB']['host'] $GLOBALS['TYPO3_CONF_VARS']['DB']['username'] $GLOBALS['TYPO3_CONF_VARS']['DB']['password']

    anymore, but

    $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['host'] $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['dbname'] $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['user'] $GLOBALS['TYPO3_CONF_VARS']['DB']['Connections']['Default']['password']

    This is especially the case, when configuring additional Environments via AdditionalConfiguration.php