A Few Warning

[halil16]

Some images from Show Database Processes

[halil16]

When I enter "anonymous" in User permissions in ACP, the following warnings appear at the top of the page:

[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/auth.php on line 416: Undefined array key 1
[phpBB Debug] PHP Warning: in file [ROOT]/includes/acp/auth.php on line 416: Trying to access array offset on value of type null

It doesn't show up on my other boards.

[warmweer]

I made Anonymous Remove from Newly Registered. Is it do a problem?

On a pristine phpBB board Anonymous is member of the Guest group only.

[GanstaZ]

It doesn't show up on my other boards.

And have you compared anonymous database row with the ones from other boards?

[warmweer]

Is user_id = 1 taken?

[halil16]

On a pristine phpBB board Anonymous is member of the Guest group only.

Yes, but there seems to be such an option in Quick Tools. It's probably something that's been overlooked.

And have you compared anonymous database row with the ones from other boards?

I did this. I did some comparisons and deleted some columns. The error rows in ACP are no longer visible.

But the error_log continues to occur:

Code: Select all

[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/auth/auth.php on line 424
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/includes/functions.php on line 3978
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/notification/method/board.php on line 147
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2014
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2043
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "avatar" in /home/name/public_html/forums/includes/functions.php on line 3723
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "avatar_width" in /home/name/public_html/forums/includes/functions.php on line 3724
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "avatar_height" in /home/name/public_html/forums/includes/functions.php on line 3725
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "avatar_type" in /home/name/public_html/forums/includes/functions.php on line 3730
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_new_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4039
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_unread_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4040
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_new" in /home/name/public_html/forums/includes/functions.php on line 4041
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_perm_from" in /home/name/public_html/forums/includes/functions.php on line 4078
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4088
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_options" in /home/name/public_html/forums/phpbb/user.php on line 780
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/event/listener.php on line 345
[28-Jan-2025 12:19:57 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/form/form_helper.php on line 56
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/auth/auth.php on line 424
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/includes/functions.php on line 3978
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/notification/method/board.php on line 147
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2014
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2043
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "avatar" in /home/name/public_html/forums/includes/functions.php on line 3723
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "avatar_width" in /home/name/public_html/forums/includes/functions.php on line 3724
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "avatar_height" in /home/name/public_html/forums/includes/functions.php on line 3725
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "avatar_type" in /home/name/public_html/forums/includes/functions.php on line 3730
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_new_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4039
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_unread_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4040
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_new" in /home/name/public_html/forums/includes/functions.php on line 4041
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_perm_from" in /home/name/public_html/forums/includes/functions.php on line 4078
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4088
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_options" in /home/name/public_html/forums/phpbb/user.php on line 780
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/event/listener.php on line 345
[28-Jan-2025 12:20:00 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/form/form_helper.php on line 56
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/auth/auth.php on line 424
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/includes/functions.php on line 3978
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/notification/method/board.php on line 147
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2014
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2043
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "avatar" in /home/name/public_html/forums/includes/functions.php on line 3723
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "avatar_width" in /home/name/public_html/forums/includes/functions.php on line 3724
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "avatar_height" in /home/name/public_html/forums/includes/functions.php on line 3725
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "avatar_type" in /home/name/public_html/forums/includes/functions.php on line 3730
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_new_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4039
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_unread_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4040
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_new" in /home/name/public_html/forums/includes/functions.php on line 4041
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_perm_from" in /home/name/public_html/forums/includes/functions.php on line 4078
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4088
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_options" in /home/name/public_html/forums/phpbb/user.php on line 780
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/event/listener.php on line 345
[28-Jan-2025 12:20:03 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/form/form_helper.php on line 56
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/auth/auth.php on line 424
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/includes/functions.php on line 3978
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/notification/method/board.php on line 147
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2014
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2043
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "avatar" in /home/name/public_html/forums/includes/functions.php on line 3723
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "avatar_width" in /home/name/public_html/forums/includes/functions.php on line 3724
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "avatar_height" in /home/name/public_html/forums/includes/functions.php on line 3725
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "avatar_type" in /home/name/public_html/forums/includes/functions.php on line 3730
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_new_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4039
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_unread_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4040
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_new" in /home/name/public_html/forums/includes/functions.php on line 4041
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_perm_from" in /home/name/public_html/forums/includes/functions.php on line 4078
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4088
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_options" in /home/name/public_html/forums/phpbb/user.php on line 780
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/event/listener.php on line 345
[28-Jan-2025 12:20:07 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/form/form_helper.php on line 56

Is user_id = 1 taken?

Anonymous's user id should have been 1 after sql query. But it did not. I changed it to 1 myself.

----

Could it be related to bots?

[rxu]

What will be the result of the following query (assumed phpbb_ as tables prefix)?

Code: Select all

SELECT ug.user_id FROM phpbb_user_group ug LEFT JOIN phpbb_users u ON u.user_id = ug.user_id WHERE u.user_id IS NULL

[halil16]

What will be the result of the following query (assumed phpbb_ as tables prefix)?

Code: Select all

SELECT ug.user_id FROM phpbb_user_group ug LEFT JOIN phpbb_users u ON u.user_id = ug.user_id WHERE u.user_id IS NULL

user_id
40365
40365
48128
48128
53970
53970
142334
142336
142338
142340
142342
142344
142346
142348
142350
142352
142354
142356
142358
142360
142362
142364
142372
142373
142374
142376
142377
142379
142380
142382
142383
142385
142386
142388
142389
142391
142392
142394
142395
142397
142398
142400
142401
142403
142404
142406
142407
142409
142410
142412
142413
142416
142419
142422
142425
142428
142431
142434
142437
142440
142443
142446
142449
142452
142464
142466
142468
142470
142472
142474
142476
142478
142480
142482
142484
142486
142488
142490
142492
142494
142496
142498
142500

[rxu]

So, there're users in user_group table which don't exist in users table (that is, their phpBB accounts don't exist anymore). Do/did you have some social login extension installed? Like OneAll etc.

[halil16]

So, there're users in user_group table which don't exist in users table (that is, their phpBB accounts don't exist anymore). Do/did you have some social login extension installed? Like OneAll etc.

I didn't make it. I don't know if it was made before me. It's a 28-year-old board.

[rxu]

Okay. You might want to try to backup user_group table and apply the following SQL query (putting all ids from the list from previous query result into IN() clause) and to see if it will fix the issue.

Code: Select all

DELETE FROM phpbb_user_group WHERE user_id IN ()

[invenio]

I didn't make it. I don't know if it was made before me. It's a 28-year-old board.

Considering phpBB was only released in 2000, is it possible it was a conversion from some other bulletin board system and there is some kind of leftover from the that (although not sure why it would only show up now as errors)?

[halil16]

Okay. You might want to try to backup user_group table and apply the following SQL query (putting all ids from the list from previous query result into IN() clause) and to see if it will fix the issue.

Code: Select all

DELETE FROM phpbb_user_group WHERE user_id IN ()

I did. this did not stop the errors in the error_log:

Code: Select all

[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/auth/auth.php on line 424
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/includes/functions.php on line 3978
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/phpbb/notification/method/board.php on line 147
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2014
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/includes/functions.php on line 2043
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "avatar" in /home/name/public_html/forums/includes/functions.php on line 3723
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "avatar_width" in /home/name/public_html/forums/includes/functions.php on line 3724
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "avatar_height" in /home/name/public_html/forums/includes/functions.php on line 3725
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "avatar_type" in /home/name/public_html/forums/includes/functions.php on line 3730
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4030
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4031
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_new_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4039
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_unread_privmsg" in /home/name/public_html/forums/includes/functions.php on line 4040
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_new" in /home/name/public_html/forums/includes/functions.php on line 4041
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_colour" in /home/name/public_html/forums/includes/functions.php on line 4064
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_perm_from" in /home/name/public_html/forums/includes/functions.php on line 4078
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "username" in /home/name/public_html/forums/includes/functions.php on line 4088
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_options" in /home/name/public_html/forums/phpbb/user.php on line 780
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_type" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/event/listener.php on line 345
[28-Jan-2025 15:13:52 UTC] PHP Warning:  Undefined array key "user_form_salt" in /home/name/public_html/forums/ext/phpbb/webpushnotifications/form/form_helper.php on line 56

At least we checked the user group table, thanks.

I didn't make it. I don't know if it was made before me. It's a 28-year-old board.

Considering phpBB was only released in 2000, is it possible it was a conversion from some other bulletin board system and there is some kind of leftover from the that (although not sure why it would only show up now as errors)?

Maybe.

[rxu]

Purged the cache?

[halil16]

Purged the cache?

Yes. I just checked again. Same.