phpBB3 to vbulletin 4 private message folders corrupt after import?

[MrKing]

after using impex to convert phpBB3 to vbulletin 4 the private messages that should be in the saved sent folder are showing in the inbox along with the received messages (folders are mixed)? and the saved sent folder is empty.

can this be fixed? is it a common problem?

Thanks

[MrKing]

is there a sql query i can use to move the messages created/sent by the inbox owner to the saved sent folder myself ? leaving only the received messages in the inbox.

Thanks

[Jake Bunce]

is there a sql query i can use to move the messages created/sent by the inbox owner to the saved sent folder myself ? leaving only the received messages in the inbox.

Thanks

Run this query on your database. Backup first:

UPDATE pm AS pm
SET pm.folderid = -1
WHERE pm.folderid = 0
AND pm.userid = (
	SELECT pmtext.fromuserid
	FROM pmtext AS pmtext
	WHERE pmtext.pmtextid = pm.pmtextid
);

That should do it. It works in my testing.