I have this strange situation, i have 4 users, two of them has the label "owner" other two has the label "admin" and its data seems consistent, but for some reason one user is a "ghost" for any search term, im using php to get list of users, examples:
if i do this: var_dump($usersow->list()); appwrite return my 4 users if i do this: var_dump($usersow->list([],'admin')); appwrite return the two users that has "admin" label but, if i do this: var_dump($usersow->list([],'owner')); appwrite only return one user that has the 'owner' label, but there are two users with 'owner' label any other valid search term return the user but not the same user that do no list with the 'owner' label, in resume one user (user 3 in array) do not return with any search term, here is the array data of the two users with 'owner' label:
User 2:
$id: "xxxxxx"
$createdAt: "2024-01-25T19:36:38.934+00:00"
$updatedAt: "2024-01-25T20:52:43.031+00:00"
name: "Demo"
password: [Hashed Password]
hash: "argon2"
hashOptions: [Array of Hash Options]
registration: "2024-01-25T19:36:38.932+00:00"
status: true
labels: ["owner"]
passwordUpdate: "2024-01-25T19:36:38.932+00:00"
email: "t@t.com"
phone: "+229876543210"
emailVerification: false
phoneVerification: false
prefs: [Empty Array]
accessedAt: ""
User 3:
$id: "yyyyyyyyyyyyyyyyy"
$createdAt: "2024-02-02T03:48:03.150+00:00"
$updatedAt: "2024-02-02T03:48:03.239+00:00"
name: "demo80"
password: [Hashed Password]
hash: "argon2"
hashOptions: [Array of Hash Options]
registration: "2024-02-02T03:48:03.148+00:00"
status: true
labels: ["owner"]
passwordUpdate: "2024-02-02T03:48:03.148+00:00"
email: "f@f.com"
phone: "+221234567890"
emailVerification: false
phoneVerification: false
prefs: [Empty Array]
accessedAt: ""
in this case, user 3 is the "ghost" all users are returned with any real search term, but is not possible to list user 3 with any valid search terms like "f@f.com", "+521234567890", "demo80", "owner", the user 3 is only listed if i do a empty list().... why? my appwrite version is 1.4.13 using latest php-sdk
actually, appwrite dashboard console do not return the user neither if i search for it, it only show it without any search term
maybe you can look at the user in the database. there should be a search column. what's that value for the users?
i manually re-edited (in appwrite console) both demo users, and now i cant search for any of them
users are here
but if i search for them they are not returned
where is exactly the search column? i cant see it on the auth (in console)
i search directly on mariadb and the search column of the problematic users shows this: user 3: search: xxxxxxxxxxxxxxxxxxx testuser@google.com Usuario Demo +229876543210 label:owner user 4: search: yyyyyyyyyyyyyyyyyyy f@f.com demo80 +221234567890 label:owner
so, search column is not empty for any of those users
Recommended threads
- Invalid query: Query on attribute has gr...
I cannot view the table within the Console
- 1:1 relationship doesn’t sync after re-a...
Hi, I’m trying to use a two-way one-to-one relationship. It works fine when I create a record with the relationship set, and it also works when I unset it. But ...
- Upsert with setting permissions
Hi there, I am using self-hosted appwrite v1.7.4 and trying to use the bulk update stuff that was released with 1.7.x. Unfortunally I found that there is an ser...