Jump to unread not working after user deletion

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
rowiz
Registered User
Posts: 5
Joined: Tue Oct 06, 2020 1:18 pm

Problems jumping to unread posts after user deletion

Post by rowiz »

Hello everybody,
I use to manage a phpbb board with hundreds of users and like 5Gigs' db.
We are experiencing some problems in jumping to last unread posts since one of our admins deleted an user with some thousands of posts (from ACP). During the operation he got an error but he didn't took note of it, neither did a backup of DB. Only solution I've experienced as a user seems to be mark the posts as read, but I'd like to check if there's some global way to fix the misbehaviour.
Thanks in advance
User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7819
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Problems jumping to unread posts after user deletion

Post by JimA »

Hi, welcome to phpBB!

Can I ask what exactly the problem looks like?
For example, do you jump to the wrong post, or do you not jump to posts at all? What URL appears when you try to jump to a post?

A test account and a link to a topic where this happens would be helpful as well. :)
Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.
rowiz
Registered User
Posts: 5
Joined: Tue Oct 06, 2020 1:18 pm

Re: Problems jumping to unread posts after user deletion

Post by rowiz »

Hello,

I jump to a wrong post.
It seems like I jump in the page where was last deleted post.
I'll send the references via PM
rowiz
Registered User
Posts: 5
Joined: Tue Oct 06, 2020 1:18 pm

Re: Problems jumping to unread posts after user deletion

Post by rowiz »

no one?
User avatar
Mick
Support Team Member
Support Team Member
Posts: 22841
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket probably.

Re: Problems jumping to unread posts after user deletion

Post by Mick »

Maybe filling out the Support Request Template and posting the results back here will help, thanks.
"The more connected we get the more alone we become" - Kyle Broflovski©
rowiz
Registered User
Posts: 5
Joined: Tue Oct 06, 2020 1:18 pm

Jump to unread not working after user deletion

Post by rowiz »

Support Request Template
What version of phpBB are you using? phpBB 3.3.0
What is your board's URL? http://forum.playitusa.com
Who do you host your board with? ovh
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What extensions do you have installed? Antispam by CleanTalk 5.7.3
Ban Hammer 1.0.8
Board Announcements 1.1.0
phpBB 3.2 Post Love 2.0.0-b3
phpBB Media Embed PlugIn 1.1.2
Rin Editor for phpBB 0.2.18
Share On 2.0.1
Simple mentions 1.0.5
Tapatalk Plugin for phpBB 3.1/3.2/3.3
What styles do you currently have installed? custom style
What language(s) is your board currently using? italian
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? rowiz
What password can be used to view this issue? I can send it privately
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Another admin deleted an user with thousands of posts
Please describe your problem. After the deletion he had an error he didn't take note, after that the "jump to last unread" button doesn't work as should when visiting thread in which the deleted user posted
Generated by SRT Generator
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 4142
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Jump to unread not working after user deletion

Post by thecoalman »

Do you know the user id? You are going to need that. If you are firm ground here if you look in /includes/functions_user.php around line 447:

Code: Select all

/**
 * Remove User
 *
 * @param string	$mode		Either 'retain' or 'remove'
 * @param mixed		$user_ids	Either an array of integers or an integer
 * @param bool		$retain_username
 * @return bool
 */
function user_delete($mode, $user_ids, $retain_username = true)
{/////.......
You can apply the SQL queries manually. I would do this on local install before applying to live database and make sure you back up live DB before doing anything.

The script probably timed out. I'm not sure if there other solution than manually doing it.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
Post Reply

Return to “[3.3.x] Support Forum”