1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by oloman, Mar 21, 2012.

  1. oloman

    oloman Active Member


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

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

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
  3. oloman

    oloman Active Member

    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:

    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
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Oh it's compressed. That's easy. Run this query on the vB database before you import to XF:

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

    UPDATE pmtext
    SET message = COMPRESS(message);
    oloman likes this.
  5. oloman

    oloman Active Member

    Oh thank you :) Yes, my skills are bad :eek:

Share This Page