A Few Warning

[rxu]

Maybe check it again to make sure there're no more non-existent users left here

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

Another idea is checking if there're users having no groups, like

SELECT user_id, username FROM phpbb_users WHERE group_id IS NULL or SELECT user_id, username FROM phpbb_users WHERE group_id = ''

[halil16]

Zero result.

[invenio]

I know that the official STK is no longer officially supported, I seem to remember there is still one in development that works with current versions of phpBB? If so, would that be an option to "clean" the database, see if that will resolve these errors? Just grasping at straws here.

[rxu]

Zero result.

Then, may be check if there're bots which don't exist in users table:

Code: Select all

SELECT b.user_id FROM phpbb_bots b LEFT JOIN phpbb_users u ON u.user_id = b.user_id WHERE u.user_id IS NULL;

[halil16]

Then, may be check if there're bots which don't exist in users table:

Code: Select all

SELECT b.user_id FROM phpbb_bots b LEFT JOIN phpbb_users u ON u.user_id = b.user_id WHERE u.user_id IS NULL;

user_id
142464
142466
142468
142470
142472
142474
142476
142478
142480
142482
142484
142486
142488
142490
142492
142494
142496
142498
142500

[rxu]

Then alike before but for bots table with the given ids into IN() clause

Code: Select all

DELETE FROM phpbb_bots WHERE user_id IN ()

[halil16]

Then alike before but for bots table with the given ids into IN() clause

Code: Select all

DELETE FROM phpbb_bots WHERE user_id IN ()

Yes! Errors messages no longer occur in the file. Thank you very much for your help.

[halil16]

Hey @rxu

The problem here always happens:
viewtopic.php?t=2659528

In rare cases (More than 2K according to GSC), I get the following error when entering a topic:

Code: Select all

General Error
SQL ERROR [ mysqli ]

[0]

SQL

No values specified for SQL IN comparison

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/driver.php
LINE: 573
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 465
CALL: phpbb\db\driver\driver->sql_in_set()

FILE: [ROOT]/phpbb/auth/auth.php
LINE: 609
CALL: phpbb\db\driver\factory->sql_in_set()

FILE: [ROOT]/phpbb/auth/auth.php
LINE: 388
CALL: phpbb\auth\auth->acl_raw_data()

FILE: [ROOT]/viewtopic.php
LINE: 1679
CALL: phpbb\auth\auth->acl_get_list()

Sometimes a topic on the forum page, but when you click on it, it says not found. I've seen many topic links like this exist even though they shouldn't be listed.

[thecoalman]

Link to the forum and example topic you are getting this error?

[rxu]

Sometimes a topic on the forum page, but when you click on it, it says not found.

You might want to try to resynchronise forums via ACP -> Forums tab.

In rare cases (More than 2K according to GSC), I get the following error when entering a topic

In theory, this is possible if topic has no posters on the page. But that shouldn't be possible unless there's some issue with the board, so probably related with those "not found" topics issue.

[Kailey]

The problem here always happens:
viewtopic.php?t=2659528

In rare cases (More than 2K according to GSC), I get the following error when entering a topic:

It's hard to root out a cause for an issue if you keep refusing to provide a link to your board (and an example topic). You've had a habit in the past of hacking the core which no doubt may be the cause of the many support issues you've posted.

[halil16]

Link to the forum and example topic you are getting this error?

PM sent.

You might want to try to resynchronise forums via ACP -> Forums tab.

I actually did this and solved the problem and forgot about it. :) Sorry.

In theory, this is possible if topic has no posters on the page. But that shouldn't be possible unless there's some issue with the board, so probably related with those "not found" topics issue.

It could be.

It's hard to root out a cause for an issue if you keep refusing to provide a link to your board (and an example topic). You've had a habit in the past of hacking the core which no doubt may be the cause of the many support issues you've posted.

PM sent. This is a board where I have clean updated many times and have not edited any core files.

this is a board the same age as me. so... I have had authorization for the last 1 year.

[thecoalman]

What is the result of:

Code: Select all

SELECT * FROM `phpbb_posts` WHERE `topic_id` = 551

[halil16]

What is the result of:

Code: Select all

SELECT * FROM `phpbb_posts` WHERE `topic_id` = 551

Ekran görüntüsü 2025-02-12 125040.jpg

But user 2 does not exist.

[warmweer]

Just a thought: have you tried the unofficial STK for 3.3.14?
That runs some initial checks and could identify inconsistencies in the database (e.g. for the user anonymous, also resync the posts_table).