On upgrade from UBB classic 6.7 to Ubbt 7.1.1, Member #1's pms got pulled in.

Now i assume that they were there in ubb classic and just got grabbed for whatever reason. I know this doesn't happen for 6.5 threads --> ubbt 7.1.1

why not just ignore member #1 (as far as pms) in the import? or am i missing something?

:shrug:

query that shows if member #1 has pms and who are the PM hoarders is:

Code
select count(*) as PMs, 
t3.USER_DISPLAY_NAME 
from ubbt_PRIVATE_MESSAGE_USERS as t1,
ubbt_PRIVATE_MESSAGE_TOPICS as t2, 
ubbt_USERS as t3 
where t1.TOPIC_ID = t2.TOPIC_ID 
and t1.USER_ID = t3.USER_ID 
group by t1.USER_ID having PMs>99 
order by PMs desc

reason i used 99, was to find users who had a lot of PMs, so i could run a PM prune routine and Member #1 showed up with 1409 total PMs! smile