UBB.Developers Forums UBB.threads 7 Development How Do I? PM's missing after 6.2 upgrade

greetings all-
I just did the upgrade to 6.2 from 6.11 last night and this morning it appears that all historic PM's are missing. I can go in via phpmyadmin and see that all the messages are still there, but when a user logs into home, they can't see the old messages that have been read?

Is there an easy fix, any help would be greatly appreciated.

Thanks in advance
gt

This topic at the support forum will help you. That's a semi-known issue with the altertable in 6.2.

http://community.infopop.net/2/OpenTopic?a=tpc&s=729094322&f=6183028913&m=8023056096

Per that post, you can set the usernumbers on the PMs that have 0 to 1, so at least the messages will appear.

Thanks Josh, you are a wealth of threads knowledge.

Cross post from infopop forums:
I just upgraded from 6.11 to 6.2 last night, downloaded the .zip from the members area last night and did the upgrade according to directions.

I too have lost all historic PM's. Oddly enough, it appears the script overwrote the recipient field, M_Uid for all old PM's to a value of '1'. So the sql statement above really doesn't work for me.

I'm guessing the only way I can fix is to use my backup I created and find the proper M_Uid for each of the 3k + PM's ???? ouch.

Yes, if the recipient field is 0 then there's nothing you can do.

That "1" trick will only work with the Sender field.

You can try restoring from a backup and try again.

If you do leave it, then you can remove any of the "0" PMs and Address Book entries as they are unneeded.

If you restore and try again, try setting the maximum execution time higher in the php.ini file on your server. What happens, is if there are too many PMs to process, the server seems to time out and/or start over, which causes the 0 effect. If you are on a shared server, you probably won't have access to this.

Infopop's latest official advice is to remove as many old PMs as you can. Perhaps install the hack from here that allows users to transfer their PMs to them via email... and ask them to do some housecleaning before you blow out any messages over x days old.

Hope that helps.

makes sense, thanks again Josh. Unfortunately i'm on a shared server and i'm sure my host wouldn't let me modify php.ini so i'll install the PM->email mod soon.

btw, i installed your user group status mod from 6.X again, works just fine under 6.2

WORD!

Great!

i ended up searching through my backup of the message table and dumping message id's for the folks that wanted them and did a similar UPDATE statement to add in their user id's into the recipient field.

it wasn't pretty, but they are happy to have their PM's back, thanks again for all your help

Just so you don't feel so bad, I'm towards the end of fixing this with almost 10,000 PM's. It was not pretty.

yeouch. I actually had a pretty good system down, loaded my backup locally and would dump the message id numbers, it was mind numbing but not that bad.