phpBB • Free and Open Source Forum Software

This is the info:
General Error
SQL ERROR [ mysqli ]

Unknown data type: 'DEFAULT' [4161]

SQL

ALTER TABLE `phpbb_users` ADD COLUMN `0` DEFAULT 'u' NOT NULL

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 211
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1011
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1217
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 499
CALL: phpbb\db\tools\tools->sql_column_add()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 715
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 662
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 590
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 518
CALL: phpbb\db\migrator->try_revert()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 489
CALL: phpbb\db\migrator->revert_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 108
CALL: phpbb\db\migrator->revert()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 341
CALL: phpbb\extension\base->purge_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 305
CALL: phpbb\extension\manager->purge_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()


PHP Error Log:
thrown in public_html/ext/andreask/ium/classes/ignore_user.php on line 250
#6 {main}
#5 public_html/adm/index.php(81): p_master->load_active()
#4 public_html/includes/functions_module.php(676): andreask\ium\acp\main_module->main()
#3 public_html/ext/andreask/ium/acp/main_module.php(253): andreask\ium\acp\main_module->get_inactive_users()
#2 public_html/ext/andreask/ium/acp/main_module.php(579): andreask\ium\acp\main_module->inactive_users()
#1 public_html/ext/andreask/ium/acp/main_module.php(730): andreask\ium\classes\ignore_user->ignore_groups()
#0 public_html/ext/andreask/ium/classes/ignore_user.php(201): andreask\ium\classes\ignore_user->get_banned()
Stack trace:
[24-Jul-2024 09:25:02 UTC] PHP Fatal error: Uncaught TypeError: Return value of andreask\ium\classes\ignore_user::get_banned() must be of the type array, null returned in public_html/ext/andreask/ium/classes/ignore_user.php:250
thrown in public_html/ext/andreask/ium/classes/ignore_user.php on line 250
#6 {main}
#5 public_html/adm/index.php(81): p_master->load_active()
#4 public_html/includes/functions_module.php(676): andreask\ium\acp\main_module->main()
#3 public_html/ext/andreask/ium/acp/main_module.php(253): andreask\ium\acp\main_module->get_inactive_users()
#2 public_html/ext/andreask/ium/acp/main_module.php(579): andreask\ium\acp\main_module->inactive_users()
#1 public_html/ext/andreask/ium/acp/main_module.php(730): andreask\ium\classes\ignore_user->ignore_groups()
#0 public_html/ext/andreask/ium/classes/ignore_user.php(201): andreask\ium\classes\ignore_user->get_banned()
Stack trace:
[24-Jul-2024 09:24:52 UTC] PHP Fatal error: Uncaught TypeError: Return value of andreask\ium\classes\ignore_user::get_banned() must be of the type array, null returned in public_html/ext/andreask/ium/classes/ignore_user.php:250
#5

Hello,

Thank you for the logs.
Please tell me the php version.

Though I haven't really tested it because I don't have a laptop currently, I believe this should fix the issue, but not 100% sure.
open file /ext/andreask/ium/classes/ignore_user.php

and find the following Should be on line 243

Replace with Question mark "?" before the word "array".
And try again.

All the best.

Hi, after applying the changes unfortunately same error.
Im using php 7.4

Could you please post the new logs?

Hi, could you provide some sql to delete the files manually?

Hello,
Firstly please provide the logs after the change so I can asses the situation.
Many thanks!