Issues with private messages : wpforo 1.4.3

Addon doesn't delete any data in database without calling delete action by user. This is something impossible. This is a hosting service problem or database tables have been damaged. Also you may clicked on delete button accidentally. There is no way to delete messages on plugin update or activate/deactivate process.

In any case if you have database backup, you can restore the two PM tables.

With so many of my users having this issue, what do you suggest I do to prevent it in the future?

As a sidenote, I updated from wpforo 1.3.1 to 1.4.3 around the time these problems began. I also updated to the private messages v.1.0.3 to 1.0.5 after updating wpforo. 

The update doesn't matter. If you don't see the messages in database, it means they are deleted, that's it. if you're sure that messages don't exist in _wpforo_pms table you should follow to my suggestion above. Just restore the two table of PM addon from old backup files. There is no other suggestion here. Data are deleted in your database and the reason is not the addon. Ive already mentioned reasons above.

But what about the "last pm date" in the wpforo dashboard? For me, it shows that my last message was 9 months ago when I know that's not true. Other users, who are actively posting private messages show 2 months or 9 months (and in between) as their last PM date when I know that messages are being sent recently (confirmed by looking at the database). 

Something must be off somewhere for these inconsistencies. 

Would uninstalling/reinstalling the private messages addon help?

Hi Eric,

We are sure that You deleted Your message, because wpForo couldn't delete messages, as Tom mentioned.

For "last pm date" please overwrite "wpforopm_stat_widget()" function

function wpforopm_stat_widget()<br />{<br /> ?><br /> <div class="postbox" id="wpforo_dashboard_widget_pm"><br /> <button aria-expanded="true" class="handlediv button-link" type="button"><br /> <span class="screen-reader-text">Toggle panel: Personal Messages</span><br /> <span class="toggle-indicator"></span><br /> </button><br /> <h2 class="hndle ui-sortable-handle"><span><?php _e('Personal Messages', 'wpforo'); ?></span></h2><br /> <div class="inside"><br /> <div class="main"><br /> <table style="width:98%; margin:0px auto; text-align:left;"><br /> <tbody><br /> <?php<br /> //Total number of PMs<br /> $sql = "SELECT COUNT(pmid) FROM `" . WPF()->db->prefix . "wpforo_pms`";<br /> $stat['pm_count'] = WPF()->db->get_var($sql);<br /> ?><br /> <tr class="wpf-dw-tr"><br /> <td class="wpf-dw-td"><br /> <?php _e('Total PM Count', 'pm_count') ?><br /> </td><br /> <td class="wpf-dw-td-value"><br /> <?php echo intval($stat['pm_count']) ?><br /> </td><br /> </tr><br /> <?php<br /> //PM Tables Size<br /> $sql = "SHOW TABLE STATUS LIKE '%wpforo_pms'";<br /> $pmtbl = WPF()->db->get_row($sql, ARRAY_A);<br /> $stat['pm_size'] = wpforo_print_size($pmtbl['Data_length'] + $pmtbl['Index_length']);<br /> ?><br /> <tr class="wpf-dw-tr"><br /> <td class="wpf-dw-td"><br /> <?php _e('PM Database Size', 'pm_count') ?><br /> </td><br /> <td class="wpf-dw-td-value"><br /> <?php echo $stat['pm_size'] ?><br /> </td><br /> </tr><br /> <?php<br /> //Active PM Senders<br /> $sql = "SELECT `fromuserid`, COUNT(`fromuserid`) AS `pm_count`, MAX(`date`) AS `date` FROM `" . WPF()->db->prefix . "wpforo_pms` GROUP BY `fromuserid` ORDER BY pm_count DESC LIMIT 10";<br /> $active_pm_senders = WPF()->db->get_results($sql, ARRAY_A);<br /> if (!empty($active_pm_senders)) {<br /> ?><br /> <tr class="wpf-dw-tr" style="padding-top:10px;"><br /> <td class="wpf-dw-td" colspan="2" style="padding-top:10px;"><br /> <?php _e('Most Active Personal Message Senders'); ?><br /> </td><br /> </tr><br /> <tr class="wpf-dw-tr"><br /> <td class="wpf-dw-td-value" colspan="2"><br /> <table width="100%" border="0" cellspacing="0" cellpadding="0"><br /> <tbody><br /> <tr class="wpf-dw-tr"><br /> <td class="wpf-dw-td"<br /> style="border-bottom:2px solid #ddd;border-top:2px solid #ddd;"><?php _e('Member', 'wpforo_pm'); ?></td><br /> <td class="wpf-dw-td"<br /> style="border-bottom:2px solid #ddd;border-top:2px solid #ddd;"><?php _e('PM Count', 'wpforo_pm'); ?></td><br /> <td class="wpf-dw-td"<br /> style="border-bottom:2px solid #ddd;border-top:2px solid #ddd;"><?php _e('Last PM Date', 'wpforo_pm'); ?></td><br /> </tr><br /> <?php foreach ($active_pm_senders as $sender) { ?><br /> <?php $member = WPF()->member->get_member($sender['fromuserid']); ?><br /> <tr class="wpf-dw-tr"><br /> <td class="wpf-dw-td-value" style="border-bottom:1px dotted #ddd;"><br /> <a<br /> href="<?php echo esc_url($member['profile_url']) ?>"<br /> target="_blank"><?php echo esc_html($member['display_name']) ?></a><br /> </td><br /> <td class="wpf-dw-td-value"<br /> style="border-bottom:1px dotted #ddd;"><?php echo intval($sender['pm_count']) ?></td><br /> <td class="wpf-dw-td-value"<br /> style="border-bottom:1px dotted #ddd;"><?php echo wpforo_date($sender['date']) ?></td><br /> </tr><br /> <?php } ?><br /> </tbody><br /> </table><br /> </td><br /> </tr><br /> <?php } ?><br /> </tbody><br /> </table><br /> </div><br /> </div><br /> </div><br /> <?php<br />}

in function.php file, which is in " /wp-content/plugins/wpforo-private-messages/includes/ " direction.

We already fixed this issue and it will appear during the next update.