XF 1.1 MP crypted on my VB3.6

oloman

Active member
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
 
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.
 
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
 
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);
 
Top Bottom