Jump to the post that solved this thread.
Solved: 4 Years, 10 Months, 4 Weeks ago made a mistake or not? delete all pms
#1
Solved: 4 Years, 10 Months, 4 Weeks ago
Hello!
I think I made a mistake ...
I wanted to do a plastering and delete all pms (from all users).
I read this thread here in the forum:
https://community.mybb.com/thread-145772...pid1036933

I ran this command in SQL:
truncate table mybb_privatemessages;

https://imgur.com/FL2tZMs

According to the advertisement there are still 121 PMs in my mailbox, but I cannot see them in my mailbox. What went wrong?
https://imgur.com/OHzHqc1

Please help me, I'm afraid of doing something wrong...

THX in advance for your help ..
blongso
Reply
#2
Solved: 4 Years, 10 Months, 4 Weeks ago
also run below SQL queries

UPDATE `mybb_users` SET `totalpms`='0'

UPDATE `mybb_users` SET `unreadpms`='0'
Reply
#3
Solved: 4 Years, 10 Months, 4 Weeks ago
(2020-02-29, 06:52 AM).m. Wrote: also run below SQL queries

UPDATE `mybb_users` SET `totalpms`='0'

UPDATE `mybb_users` SET `unreadpms`='0'

Thank you .m.!!!

Greets,
blongso
Reply
#4
Solved: 4 Years, 10 Months, 4 Weeks ago
if users have limited quota (eg. 250 / 500 based on user group) then
there should be no need to truncate PMs. or perhaps it would be better
to use a related plugin for the deletion [eg. prune old PMs]
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 2 Guest(s)