vb.org Archive - Delete all members PM's

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Delete all members PM's (https://vborg.vbsupport.ru/showthread.php?t=150252)

powerful_rogue

06-21-2007 04:59 AM

Delete all members PM's

Hi,

Ive just used ImpEX to move everything over from 3.6.3 to 3.6.7.

On the homepage its showing members as having PM's that arnt in there inbox. Is there a way to refresh/clear this so it sets the total down to zero?

EG:

Private Messages: Unread 0, Total 66.

I currently have 0 pms - How can I reset this counter?

Many Thanks

Shazz

06-21-2007 05:04 AM

AdminCP >> Maintenance > Execute SQL Query

Code:

TRUNCATE pm

TRUNCATE pmreceipt

TRUNCATE pmtext

powerful_rogue

06-21-2007 01:02 PM

Hi,

Thanks for your reply.

I tried that but it comes up with this error

Quote:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUNCATE pmreceipt
TRUNCATE pmtext' at line 2

TheHeartSmasher

06-21-2007 01:16 PM

Code:

TRUNCATE pm

TRUNCATE pmreceipt

TRUNCATE pmtext

Make sure the tables names are correct for example:

Code:

 TRUNCATE vb_pm

TRUNCATE vb_pmreceipt

TRUNCATE vb_pmtext

powerful_rogue

06-21-2007 01:54 PM

Hi,

Thanks for your reply. Ive carried that out and it all went well, however its still showing PM's that dont exist.

Inbox contains 0 messages.
You have 70 messages stored, of a total 100 allowed

However there is no PM's at all. This is the same for all users.

Any other sugesstions at all?

powerful_rogue

07-23-2007 12:23 PM

Im still suffering with the same problem.

I Impexed from phpbb3 to VB3.6.7 and its showing members they have unread messages when they havent.

I cleared the database for PM's, but the still show when theres nothing there.

Any suggestions?

nexialys

07-23-2007 12:51 PM

you have to rebuilt users informations... in the maintenance part of your admincp

Marco van Herwaarden

07-23-2007 01:10 PM

Quote:

Originally Posted by Shazz (Post 1272960)

AdminCP >> Maintenance > Execute SQL Query

Code:

TRUNCATE pm

TRUNCATE pmreceipt

TRUNCATE pmtext

He is asking how to fix the PM Counts of his members, and you advice him to delete all PM's???

The counts should be correct. Please note that the count of the PM's include PM's in folders like Sent and/or saved PM's.

If you think that ImpEx does not do a correct count, then please open a support ticket.

All times are GMT. The time now is 02:06 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01067 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: