TYPO3 Core

When I try to test or update the reference index in Tools->DB Check->Manage reference index there are some database errors. I have no idea if this is a bug, or if it has something to do with me running some extensions that are not yet fit for 4.0 or something like that.

On testing reference index I get these messages:

caller
t3lib_DB::exec_SELECTquery

ERROR
Unknown column 'pages' in 'where clause'

lastBuiltQuery
SELECT hash
FROM sys_refindex
WHERE
tablename NOT IN (pages,'be_users','be_groups','sys_filemounts','sys_workspace','sys_language','tt_content','fe_users','fe_groups','sys_domain','pages_language_overlay','sys_template','static_template','sys_note','tx_rtehtmlarea_acronym','static_territories','static_countries','static_country_zones','static_languages','static_currencies','tx_templavoila_tmplobj','tx_templavoila_datastructure','tt_address','static_taxes','fe_groups_language_overlay','tx_partner_main','tx_partner_contact_info','tx_partner_relationships','tx_partner_val_status','tx_partner_val_contact_permissions','tx_partner_val_titles','tx_partner_val_org_types','tx_partner_val_legal_forms','tx_partner_val_marital_status','tx_partner_val_religions','tx_partner_val_occupations','tx_partner_val_hobbies','tx_partner_val_courses','tx_partner_val_rel_types','tx_partner_reports','sys_dmail_category','sys_dmail','sys_dmail_group','tx_irfaq_q','tx_irfaq_cat','tx_irfaq_expert')
debug_backtrace sc_mod_tools_dbint_index->main // sc_mod_tools_dbint_index->func_refindex // t3lib_refindex->updateindex // t3lib_db->exec_selectgetrows // t3lib_db->exec_selectquery // t3lib_db->debug

caller
t3lib_DB::exec_SELECTquery

ERROR
Unknown column 'pages' in 'where clause'

lastBuiltQuery SELECT hash
FROM sys_refindex
WHERE
tablename NOT IN (pages,'be_users','be_groups','sys_filemounts','sys_workspace','sys_language','tt_content','fe_users','fe_groups','sys_domain','pages_language_overlay','sys_template','static_template','sys_note','tx_rtehtmlarea_acronym','static_territories','static_countries','static_country_zones','static_languages','static_currencies','tx_templavoila_tmplobj','tx_templavoila_datastructure','tt_address','static_taxes','fe_groups_language_overlay','tx_partner_main','tx_partner_contact_info','tx_partner_relationships','tx_partner_val_status','tx_partner_val_contact_permissions','tx_partner_val_titles','tx_partner_val_org_types','tx_partner_val_legal_forms','tx_partner_val_marital_status','tx_partner_val_religions','tx_partner_val_occupations','tx_partner_val_hobbies','tx_partner_val_courses','tx_partner_val_rel_types','tx_partner_reports','sys_dmail_category','sys_dmail','sys_dmail_group','tx_irfaq_q','tx_irfaq_cat','tx_irfaq_expert')

debug_backtrace
sc_mod_tools_dbint_index->main // sc_mod_tools_dbint_index->func_refindex // t3lib_refindex->updateindex // t3lib_db->exec_selectgetrows // t3lib_db->debug

On updating the reference index I get tons of these:

caller
t3lib_DB::exec_DELETEquery

ERROR
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 'aa67dd690b077bf9e13f304d11407)' at line 3

lastBuiltQuery
DELETE FROM sys_refindex
WHERE
hash IN (3e8aa67dd690b077bf9e13f304d11407)
debug_backtrace sc_mod_tools_dbint_index->main // sc_mod_tools_dbint_index->func_refindex // t3lib_refindex->updateindex // t3lib_refindex->updaterefindextable // t3lib_db->exec_deletequery // t3lib_db->debug
(issue imported from #M2427)