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
- Failed to generate functions SSL
```appwrite-worker-certificates | Cannot renew domain (functions.domain.com) on attempt no. 9 certificate: Failed to verify domain DNS records. appwrite-worker...
- Dart 3.10 runtime on self-host 1.8.1
I added dart-3.10 runtime in .env file, applied the changes, but cannot see such option on console. is dart 3.10 not supported by self hosted 1.8.1? if not, whe...
- Guideline of AI
Hello everyone, I’m planning to specialize in Artificial Intelligence (AI) and I’m currently looking for guidance from someone with strong experience in the fi...