We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

User Transfer | Forum

We The People United We Stand
Hello,


I transferred the users from one Ox-wall to another via  PHP Admin.  



Now they cannot use their password and it does not show them in the user roles section.


however, I do see them in the user list page and I can pull them up on the website.


What step did I miss?


Thxs

Paul
Paul May 27 '20
Did you only transfere the base_user table?

You need the ow_base_authorization_role and specialy the ow_base_authorization_user_role table alswell

Patricia Zorrilla Leader
Patricia Zorrilla May 27 '20

No, that's not it. You have to open the file /ow_includes/config.php from the origeb website and copy the line that says


define('OW_PASSWORD_SALT', '52b234567891ba6');


(The number will be different)


and replace the one on the new website.


The passwords are encoded with this key number which is assigned new and different for each installation


We The People United We Stand
Patricia, Yes I saw that. It was the salt value.  thank you guys.
We The People United We Stand
the other issue I am having is I cannot add a new video.  That to I transfered


We The People United We Stand
Message:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null
We The People United We Stand
Ok I figured it out.  


I originally exported the video sql as data only when I needed the complete file.


Now i imported the complete sql file.  


And now it works great


Thxs for everyone's help.