• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 MP crypted on my VB3.6

oloman

Active member
#1
Hi

My old webmaster crypted all VB 3.6 private messages. Like password.

Is the import will convert mp? Or members will see @"é!@aaaa ?

Regards
 

Jake Bunce

XenForo moderator
Staff member
#2
They are encrypted in the database? They would have to be decrypted for the import.

Ideally you should get with your old webmaster and have him decrypt the PM records. Then they will import normally.
 

oloman

Active member
#3
Ok, yes in the base:/

I contacted old webmaster but it did not answer yet.

The Code to read the PMs in the base is:

SELECT
pm.*, pmtext.*,UNCOMPRESS(pmtext.message) AS message,

Do you know if I can uncompress directly the base using SSH ? I did not find informations on Google
 

Jake Bunce

XenForo moderator
Staff member
#4
Oh it's compressed. That's easy. Run this query on the vB database before you import to XF:

Code:
UPDATE pmtext
SET message = UNCOMPRESS(message);
If you wish to compress the PMs again after the import then run this query:

Code:
UPDATE pmtext
SET message = COMPRESS(message);