TYPO3 version 6 to version 8 compatibility issues

Question

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.

Answer 1

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