plugin is not working?

  • noahmaes

    (@noahmaes)


    11 years, 8 months ago

    The plugin is not working (yet), maybe it is because I did not the sql action as mentioned in the code: ALTER TABLE wp_xxxxx CHANGE user_pass user_pass VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ”

    I do not exacly understand what the risc/need for this sql code is and what table i do need to take in my situation

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author curlybracket

    (@veganist)

    11 years, 3 months ago

    Hil

    as written in the README, unfortunately WP limits the size of the passwords in the database. Magento though uses very long strings, so you need to manually alter the table and then ask your old users to log in.

    This plugin is meant as a developer plugin, for migrating users from Magento to WordPress.

    You need to alter the table before inserting the old values from the DB, otherwise, they will not be copied in total.

    fatboyjim

    (@fatboyjim)

    11 years, 3 months ago

    Hi CB – i’m really hoping this is the silverbullet I think it is and appreciate you having taken the time to write it.

    apart from the wp_xxxx part is there any other bit of that string which needs to be amended? when I entered this query (in myphpadmin) it gave an error.

    fatboyjim

    (@fatboyjim)

    11 years, 3 months ago

    Hey mate.

    So for some reason myphpadmin accepted that query today.

    I’ve cleaned the user dbase out and imported it again. Still the password are truncated (or at least changed).

    example:

    the password hash in the original csv is bc9750f15df47f41859d2a2775629f99:Lm
    after import into the user dbase it reads vn838njCYgQr
    the dbase does support the larger password as i can cut and paste it in manually.

    when I do that – the plug-in works perfectly allowing me to log-in using the original password!

    any idea how i can get the passwords to import correctly as curring and pasting a few thousand passwords hashes into a dbase is a depressing prospect!

    cheers

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘plugin is not working?’ is closed to new replies.