Details
-
Bug
-
Status: Open
-
Resolution: Unresolved
-
None
Description
I have search a while, and there are many bugs but no solutions.
PM resync option
+ delete orphan PMs
+ delete PMs without entry in phpbb_privmsgs
+ recount all PMs and unreaded PMs
test it in includes/ucp/ucp_pm_viewfolder.php
$sql = 'SELECT t.*, p.root_level, p.message_time, p.message_subject, p.icon_id, p.to_address, p.message_attachment, p.bcc_address, u.username, u.username_clean, u.user_colour, p.message_reported
|
FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . " u
|
WHERE t.user_id = $user_id
|
AND p.author_id = u.user_id
|
AND $folder_sql
|
AND t.msg_id = p.msg_id
|
$sql_limit_time
|
ORDER BY $sql_sort_order";
|
and change here line:
AND t.msg_id = p.msg_id
|
in:
AND t.msg_id != p.msg_id
|
than you found the lost PMs and you can delete it. But its hard... with an STK option it will be better to solve it for all users.
Problems:
https://www.phpbb.com/community/viewtopic.php?f=46&t=1001785
https://www.phpbb.com/community/viewtopic.php?f=46&t=2123917
...