No operator matches the given name and argument types. You might need to add explicit type casts.

[usUpal]

This error occured when seeding the database. My guess is that type mismatching is occuring but explicit type cast didn't solve the issue. A help would be much appriciated. Thanks @paulpierre
🌱 Seeding database ...
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: entity_status = integer
LINE 3: ...splay_name = 'project-pepetamine.md' AND document.status = 2
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

[SQL: SELECT document.id, document.uuid, document.organization_id, document.project_id, document.display_name, document.url, document.data, document.hash, document.version, document.status, document.created_at, document.updated_at
FROM document
WHERE %(param_1)s = document.project_id AND document.display_name = %(display_name_1)s AND document.status = %(status_1)s]
[parameters: {'param_1': 1, 'display_name_1': 'project-pepetamine.md', 'status_1': 2}]

[tienhung36]

comment line 815 in helper.py

[vassilevev]

did you manage to solve the problem?

[tienhung36]

yes,i have solved Vào Th 3, 26 thg 12, 2023 vào lúc 20:42 vassilevev < ***@***.***> đã viết:

…

did you manage to solve the problem? — Reply to this email directly, view it on GitHub <#62 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AZJ54NKZETOQT6YD2L5QRN3YLLH6DAVCNFSM6AAAAABAF4VXJGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNRZGU2TKOBXG4> . You are receiving this because you commented.Message ID: ***@***.***>

[usUpal]

I solved this issue:
step1: comment this line
step2: change the requirement.txt with below versions in here

langchain==0.0.319
uvicorn[standard]
python-multipart
psycopg2-binary
python-dotenv
fastapi[all]
SQLAlchemy==1.4.50
pgvector
tiktoken
aiofiles
sqlmodel==0.0.10
openai==0.28.1

if the issue still persists, let me know.

[vassilevev]

@usUpal its work!

[tienhung36]

Does it integrate with whatsapp? Vào Thứ Tư, 27 tháng 12, 2023, vassilevev ***@***.***> đã viết:

…

@usUpal <https://github.com/usUpal> its work! — Reply to this email directly, view it on GitHub <#62 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AZJ54NON6BJVWSKTTZEBVWLYLP3ONAVCNFSM6AAAAABAF4VXJGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZQGE3TSNJVHE> . You are receiving this because you commented.Message ID: ***@***.***>

[usUpal]

Does it integrate with whatsapp? Vào Thứ Tư, 27 tháng 12, 2023, vassilevev @.> đã viết:
…
@usUpal https://github.com/usUpal its work! — Reply to this email directly, view it on GitHub <#62 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AZJ54NON6BJVWSKTTZEBVWLYLP3ONAVCNFSM6AAAAABAF4VXJGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZQGE3TSNJVHE . You are receiving this because you commented.Message ID: @.>

I didn't try it. if you try, let me know.

[usUpal]

@usUpal its work!

ok then, I am closing this issue.