Forcing UID value

[Simos]

@julian said in Forcing UID value:

getSortedSetScore

getSortedSetScore doesn't exist it's sortedSetScore
https://github.com/NodeBB/NodeBB/blob/master/src/user/index.js#L129

[Simos]

plugin.getUidByAUid = function(auid, callback) {
	if (!auid) {
		return callback(null, 0);
	}
    db.sortedSetScore('auid:uid', auid, callback);
};

return always null , so i've checked if the function was working and i've try to change db.sortedSetScore('auid:uid', auid, callback) to db.sortedSetScore('email:uid', '[email protected]' , callback) and it work .

At this point i've also checked using redis-cli for 'auid' field, it exist and has the right value.

I really don't understand what's wrong, it look db.sortedSetScore can't find 'auid' for some reason

[Simos]

I'm still blocked here any suggestion ?

[baris]

What is the type of auid:uid ? Is it a sorted set or hash? Run this in mongo shell db.objects.find({_key: "auid:uid"});

[Simos]

@baris i'm using Redis not mongoDB

127.0.0.1:6379> HGET user:1 auid
"3074"

[PitaJ]

@Simos the equivalent code would be

ZSCORE auid:uid 1

[Simos]

@PitaJ @baris

127.0.0.1:6379> HGET user:1 auid
"3074"
127.0.0.1:6379> ZSCORE auid:uid 1
(nil)
127.0.0.1:6379>

it say nil

[baris]

run this type auid:uid

[Simos]

@baris said in Forcing UID value:

type auid:uid

127.0.0.1:6379> type auid:uid
none
127.0.0.1:6379>

[baris]

That means auid:uid doesn't exist so your code doesn't actually write anything into it.

[Simos]

@baris so why i can get it in the hash ? auid exist ...

127.0.0.1:6379> HGETALL user:1

1. "username"
2. "Simos"
3. "userslug"
4. "simos"
5. "email"
6. "[email protected]"
7. "joindate"
8. "1542893552374"
9. "lastonline"
10. "1543850453258"
11. "picture"
12. ""
13. "fullname"
14. ""
15. "location"
16. ""
17. "birthday"
18. ""
19. "website"
20. ""
21. "signature"
22. ""
23. "uploadedpicture"
24. ""
25. "profileviews"
26. "2"
27. "reputation"
28. "0"
29. "postcount"
30. "1"
31. "topiccount"
32. "1"
33. "lastposttime"
34. "1542893552974"
35. "banned"
36. "0"
37. "status"
38. "online"
39. "gdpr_consent"
40. "0"
41. "acceptTos"
42. "0"
43. "uid"
44. "1"
45. "password"
46. "XXXXXXXXXXXXXXXXXXXXXXXXXX"
47. "passwordExpiry"
48. "0"
49. "groupTitle"
50. "["administrators"]"
51. "auid"
52. "3074"

[baris]

@Simos said in Forcing UID value:

"auid"
"3074"

It exists as part of the user hash, but if you don't save it into auid:uid then sortedSetScore will always return null. You need to set it into auid:uid as well with db.sortedSetAdd('auid:uid', uid, auid, callback);

[Simos]

@baris i'm losing my self again ... i've already added that value to user hash on user create, in wich part of plugin now i've to save it into auid:uid with the function you have mentioned ?
I'm new to redis ... pheraps i'm confused because i usually use mysql , but i 've understand that is completly different.

[baris]

Gotto do it when you create the user, so same place as you set it in user hash.

[Simos]

@baris
I suppose after user creation ... as i don't understand how i should pass uid before having it ...

[baris]

Yes, you should be able to do it in action:user.create

[Simos]

@baris how can i do for already existent user who already have auid but only in hash ?

[baris]

You need to load the value from the user hash and call db.sortedSetAdd('auid:uid', uid, auid, callback);

[Simos]

@baris my problem problem is :

how i can call db.sortedSetAdd('auid:uid', uid, auid, callback); on action:user.create ? i don't have uid until user is already created.

@baris said in Forcing UID value:

You need to load the value from the user hash and call db.sortedSetAdd('auid:uid', uid, auid, callback);

i mean some command to do it using redis-cli

[baris]

@Simos said in Forcing UID value:

action:user.create

This hook is fired after user is created, if you need to set it for users that are already in the database you need to go through them with a script and call it.