Login to Bitrix 24?

Question

1C-Bitrix

After restoring the backup, an error occurred when entering the site
[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1054) Unknown column 'main_localization_culture.SHORT_DATE_FORMAT' in 'field list' (400)
SELECT
`main_localization_culture`.`ID` AS `ID`,
`main_localization_culture`.`CODE` AS `CODE`,
`main_localization_culture`.`NAME` AS `NAME`,
`main_localization_culture`.`FORMAT_DATE` AS `FORMAT_DATE`,
`main_localization_culture`.`FORMAT_DATETIME` AS `FORMAT_DATETIME `,
`main_localization_culture`.`FORMAT_NAME` AS `FORMAT_NAME`,
`main_localization_culture`.`WEEK_START` AS `WEEK_START`,
`main_localization_culture`.`CHARSET` AS `CHARSET`,
`main_localization_culture`.`DIRECTION` AS `DIRECTION`,
`main_localization_culture`.`SHORT_DATE_FORMAT` AS `SHORT_DATE_FORMAT`,
`main_localization_culture`.`MEDIUM_DATE_FORMAT` AS `MEDIUM_DATE_FORMAT`,
`main_localization_culture`.`LONG_DATE_FORMAT_DATE` AS `
LONG `.`FULL_DATE_FORMAT` AS `FULL_DATE_FORMAT`,
`main_localization_culture`.`DAY_MONTH_FORMAT` AS `DAY_MONTH_FORMAT`,
`main_localization_culture`.`SHORT_TIME_FORMAT` AS `SHORT_TIME_FORMAT`,
`main_localization_culture`.`LONG_TIME_FORMATization`
ASF_LONG_ `AM_VALUE` AS `AM_VALUE`,
`main_localization_culture`.`PM_VALUE` AS `PM_VALUE`,
main_localization_culture`.`NUMBER_THOUSANDS_SEPARATOR` the AS `` NUMBER_THOUSANDS_SEPARATOR`,
`` the AS main_localization_culture`.`NUMBER_DECIMAL_SEPARATOR` NUMBER_DECIMAL_SEPARATOR`,
`` the AS main_localization_culture`.`NUMBER_DECIMALS` NUMBER_DECIMALS`
the FROM `` b_culture` main_localization_culture` the
WHERE `main_localization_culture`.`ID` = 1
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
/home/bitrix/www /bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
/home/bitrix/www/bitrix/modules/main/lib/orm/query /query.php:3209
#2: Bitrix\Main\ORM\Query\Query->query(string)
/home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php:807
#3: Bitrix\Main\ORM\Query\Query->exec()
/home/bitrix/www/bitrix/ modules/main/lib/orm/data/datamanager.php:500
#4: Bitrix\Main\ORM\Data\DataManager::getList(array)
/home/bitrix/www/bitrix/modules/main/lib/orm/ data/datamanager.php:361
#5: Bitrix\Main\ORM\Data\DataManager::getByPrimary(array, array)
/home/bitrix/www/bitrix/modules/main/include.php:69
#6: require_once( string)
/home/bitrix/www/bitrix/modules/main/include/prolog_admin_before.php:31
#7: require_once(string)
/home/bitrix/www/bitrix/modules/main/interface/desktop.php:2
# 8: require(string)
/home/bitrix/www/bitrix/admin/index.php:2

Answer 1

It looks like you have a kernel and a database of different versions. You need to restore a complete holistic backup, and not just the database.

Answer 2

Perhaps you need to update the freshly installed Bitrix24, check the components (that were previously installed) and only then "roll" the recovery.
Or another option to create fields that are visible in errors, for example, now add SHORT_DATE_FORMAT and try again until the query is successfully executed in the database, and after a successful login, analyze the database