xpert Posted March 30, 2015 Share Posted March 30, 2015 we are loving CC6 so far! we are upgrading and migrating to CC6 from years old CC3. in customers data ,we noticed new CC6 database table has additional "salt" column for each customer is it possible if we map tables of new CC exactly using old CC3 table, our old customer can login using old passwords they have? or any other method to migrate CC3 to CC6 customers? any help/hint will really help Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 30, 2015 Share Posted March 30, 2015 Hi! Thanks for your enthusiasm. CubeCart v3 used an old fashioned basic way of storing passwords. The password column is literally just an MD5 hash of the password. e.g. pasword = 5f4dcc3b5aa765d61d8327deb882cf99 Try it here: http://www.miraclesalad.com/webtools/md5.php CubeCart v6 uses a much more sophisticated way to store a password where not only is the password encrypted but it is hashed which means adding text to the password the user doesn't know about to make it stronger. More info here: http://en.wikipedia.org/wiki/Salt_%28cryptography%29 If you copy the password from you v3 store into the v6 database table, leaving the salt with an empty value and "new_password" set to "0". On next login CubeCart will automatically convert the existing password into a more secure salted password. You can't use a v3 database table in v6. The only way you can do what you want is how I just described. Quote Link to comment Share on other sites More sharing options...
xpert Posted April 2, 2015 Author Share Posted April 2, 2015 Thanks it helped a lot ,now all cc3 customers can login in cc6 but with a problem system force them to update address book but thrown a MYSQL error [02-Apr-2015 10:37:07 UTC] PHP Notice: `hash` is not allowed as a key in 'CubeCart_addressbook' table! in /home/myweb/public_html/shop15/classes/db/database.class.php on line 849 [02-Apr-2015 10:37:07 UTC] PHP Notice: `status` is not allowed as a key in 'CubeCart_geo_country' table! in /home/myweb/public_html/shop15/classes/db/database.class.php on line 849 I realized as we migrated customers table from CC3 to CC6 , there is no entry make to CubeCart_addressbook and CubeCart_geo_country tables? do CC6 enter a record of customer in CubeCart_addressbook when they first signup? any work around or help in this will really help us speed up migration! Ranika Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted April 3, 2015 Share Posted April 3, 2015 Did you fully run the database upgrade when migrating from V3 ? Quote Link to comment Share on other sites More sharing options...
xpert Posted April 29, 2015 Author Share Posted April 29, 2015 ThanksI was able to fix finally.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.