Error when trying to restore a deleted post

[bynw]

I recently found the option that we could restore deleted posts and turned it on. It's a great feature, thanks.

As such I tried to restore a recently deleted post and it gave me an error. I'll post that backtrace information below. The user that wrote the post is no longer a member of our community and the account is deleted so I'm wondering if that is the cause and if so what is the work around for it.

Please see the attached files for the error and backtrace details.

You cannot view this attachment.


You cannot view this attachment.


Thanks

[shawnb61]

What database engine?  Version?

Are you using MariaDB?

The solution is almost certainly to add subject to the GROUP BY line.

Moving to Bug Reports.

[bynw]

What database engine?  Version?

Are you using MariaDB?

The solution is almost certainly to add subject to the GROUP BY line.

Moving to Bug Reports.

Yes it is a MariaDB version 10.3.37

[shawnb61]

Issue logged:
https://github.com/SimpleMachines/SMF/issues/7656

In the meanwhile, you can try adding the subject to the GROUP BY as a temporary fix. 

[bynw]

Issue logged:
https://github.com/SimpleMachines/SMF/issues/7656

In the meanwhile, you can try adding the subject to the GROUP BY as a temporary fix. 

How would I do that?

[shawnb61]

How would I do that?

In RemoveTopic.php, ~line 1396:
https://github.com/SimpleMachines/SMF/blob/5be32db86ab8b0152c078d258b946b33fa32fcb0/Sources/RemoveTopic.php#L1396

Change it to:

Code Select Expand

GROUP BY id_topic, approved, subject
You will have to revert this change when SMF issues a patch, so the patch can be applied properly.  But I think it will get rid of those errors for now.

[bynw]

That did the job.

Thank you very much