Uploaded image for project: 'Support Team Tools'
  1. Support Team Tools
  2. STT-322

PM resync

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Support Toolkit
    • None

      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
      ...

            Unassigned Unassigned
            Kostenloses-Forum Kostenloses-Forum [X] (Inactive)
            Archiver:
            Noxwizard Patrick Webster

              Created:
              Updated:
              Archived: