hello,
i'm migrating data from my php / mysql community to dolphin.
i didn't succedd to:
-
import passwords
i see that there is an encrypted password in the Profile table, and a salt field... how can i encrypt my user's old passwords to make it work with dolphin?
-
import votes
i pupolated the fields Rate and RateCount in the Profile table, and i also populated the sys_profile_voting_track table...
i still see 0 votes on my profiles
thanks,
see you soon for other problems :D
|
Possible problem with #2. Empty the contents of your cache folder except for the .htaccess file. Dolphin caches quite a bit of database info to speed things up. When doing manual database changes, the cache does not get updated. Removing the files from the cache forces dolphin to rebuild them.
Now for your passwords. This procedure will only work if your current passwords are unhashed clear text.
Create a php loop to loop through all the member id's. In that loop use the following mysql querys to create the salt and password.
UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10,
36) WHERE `ID`='memberid';
UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('Password'),
`Salt`)) WHERE `ID`='memberid';
https://www.deanbassett.com |
https://dolphin-techs.com - Skype: Dolphin Techs |
i love you.
it works on most cases, but sometimes i can't login...
maybe when the username has some special characters
|
Possible. Dolphin user names are only suppose to contain the standard latin char set.
https://www.deanbassett.com |
hi guys i found other problems:
-
Avatars... sometimes they work, sometimes they don't:
this girl has not an avatar: http://www.ostiachat.com/franCesChina87
this guy has an avatar: http://www.ostiachat.com/cangurott8
i imported all images in the same way, i have all the images in the avatar folder and also in the photo folder
-
Albums: why the album preview is using the _rt image? http://www.ostiachat.com/GiGo it's 32x32
-
logins: very often they are not working, also if i click on forgot password... than i'm not able to login
-
Nicknames: if i change nicknames on the Profiles table... i can't see them changed online
-
login by email: i can't login using email instead of the ID
thanks for your help!
|
Have you emptied the cache, cache_public and tmp directories?
This needs to be done anytime you manually make changes to the database.
That might solve some of your problems. https://www.deanbassett.com |
