[bug]: PostgreSQL database expects numeric IDs for the up_users table, instead of a string documentId

[woontsoudev]

Bug Description

Issue Description

When using the Strapi Client to update user profiles, the client passes string IDs to the Strapi API, but the PostgreSQL database expects numeric IDs for the up_users table. This causes the following error in the Strapi server:

[2025-04-27 23:52:56.480] error: select "t0".* from "public"."up_users" as "t0" where (("t0"."id" = $1)) limit $2 - invalid input syntax for type integer: "vkdx5e0javerx298j9a98r4n"

Root Cause

1. The Strapi Client library's TypeScript interface for the update() method expects a string documentId, as documented in the official Strapi documentation.
2. However, Strapi's PostgreSQL implementation for the users collection expects numeric IDs.
3. The frontend is passing a string ID (vkdx5e0javerx298j9a98r4n) to the update method, which is being passed directly to the database as a parameter for an integer column.

Steps to Reproduce

1. Use the strapiClient().collection('users') to get the users collection
2. Call update(documentId, payload) with a string documentId
3. The error occurs when the query is executed against the PostgreSQL database

Expected Behavior

• Update the collection items using a documentId

Version

1.3.0

Operating System

MacOS

Runtime Environment

Node.js

Logs

[2025-04-28 12:49:16.634] error: select "t0".* from "public"."up_users" as "t0" where (("t0"."id" = $1)) limit $2 - invalid input syntax for type integer: "d478fn4m2xx7yuzkkcavx8bk"
error: select "t0".* from "public"."up_users" as "t0" where (("t0"."id" = $1)) limit $2 - invalid input syntax for type integer: "d478fn4m2xx7yuzkkcavx8bk"
    at Parser.parseErrorMessage (/Users/woontsou/projects/enterprise-cms/backend/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/Users/woontsou/projects/enterprise-cms/backend/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/Users/woontsou/projects/enterprise-cms/backend/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/Users/woontsou/projects/enterprise-cms/backend/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:518:28)
    at Socket.emit (node:domain:489:12)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
[2025-04-28 12:49:16.634] http: PUT /api/users/d478fn4m2xx7yuzkkcavx8bk (4 ms) 500

Media

No response

Confirmation Checklist

• I have checked the existing issues
• I agree to follow this project's Code of Conduct
• I would like to work on this issue