We had deleted a user from the JomSocial GUI, who had link to some content and this user is now re-created to resolve the problem. Unfortunately, his id needs to be changed in the database ti have the old ID.

you can see this when you click on any article in the system.

Would you be kind to provide an SQL to correct the new user id with the old id so that we do not get the error
on the system that is constantly throwing this error (see screen shot)



We appreciate your support on this as we spent a lot of time in creating the structure of our website before go live.

thanks.

HI, M Chabbani

You can do it in two ways:

0. Make a safe copy first!

1. Enter your database via phpMyAdmin
2. Find table _community_users
3. You can identify your user by looking in "alias" column that will contain user name alias.
4. Edit your user record and change value in "userid" field

You can also enter a SQL query:

UPDATE `your_database_name`.`your_prefix_community_users` SET `userid` = '572' WHERE `your_prefix_community_users`.`userid` = current_user_id;

thanks Michal for your excellent support, I did the following

mysql> UPDATE `xrisma`.`xrisma_community_users` SET `userid` = '572' WHERE `xrisma_community_users`.`userid` = 591;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

but when I do this

mysql> select userid from `xrisma`.`xrisma_community_users`
-> ;
+

Hi, Mar.

Please add to your first post access to your database. Paste it to "Miscellaneous" field.

We decided to re-install the whole site for another reason. I will let you know if we decided otherwise. anyway thanks very much for your support for now.