Fault (code operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. ) occurred. Message: Traceback (most recent call last): File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 60, in xmlrpc_1 response = self._xmlrpc(service) File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 49, in _xmlrpc result = dispatch_rpc(service, method, params) File "/opt/odoo12/odoo/odoo/http.py", line 120, in dispatch_rpc result = dispatch(method, params) File "/opt/odoo12/odoo/odoo/service/model.py", line 36, in dispatch security.check(db,uid,passwd) File "/opt/odoo12/odoo/odoo/service/security.py", line 16, in check return res_users.check(db, uid, passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 663, in check self._check_credentials(passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 312, in _check_credentials self.env.cr.execute( File "/opt/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/opt/odoo12/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params) psycopg2.errors.UndefinedFunction: operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Failed to create a create lead/opportunity in Odoo ERP Self Hosted
- Beginner
Best answer by ken.a
Hi
Thank you for the screenshot!
It looks like any version from 8 onwards is not yet supported by the Zapier Odoo integration. It's something other users have asked for and is currently logged as a Feature request. What I've done is added your vote for this Feature request. That does a few things:
- Bring this to the attention of the integration developers
- Help track interest in this feature being implemented
- Allows us to notify you via email if this feature becomes available in the future
While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!
I apologize if we don’t support Odoo version 8 above at the moment. If you have any other questions, please don’t hesitate to ask in the Community. We’re always happy to help! 😊
+6- Zapier Staff
Hi there
Welcome to the Community! 🎉
Before we dig deeper into this, would you mind sharing some additional information? It would be really helpful if you could provide a detailed screenshot of how your Zap is configured. Additionally, if you could include a screenshot of the error message and the specific step where you're encountering the error, that would be great! This will allow us to better understand the issue and provide you with the most accurate assistance.
Thanks! 😊
- Beginner
Im connecting chatbot to Odoo Self Hosted CRM. I successfully connected the chatbot but there’s an error on Odoo Self Hosted CRM.
The error:
Fault (code operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. ) occurred. Message: Traceback (most recent call last): File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 60, in xmlrpc_1 response = self._xmlrpc(service) File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 49, in _xmlrpc result = dispatch_rpc(service, method, params) File "/opt/odoo12/odoo/odoo/http.py", line 120, in dispatch_rpc result = dispatch(method, params) File "/opt/odoo12/odoo/odoo/service/model.py", line 36, in dispatch security.check(db,uid,passwd) File "/opt/odoo12/odoo/odoo/service/security.py", line 16, in check return res_users.check(db, uid, passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 663, in check self._check_credentials(passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 312, in _check_credentials self.env.cr.execute( File "/opt/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/opt/odoo12/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params) psycopg2.errors.UndefinedFunction: operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
+6- Zapier Staff
Hi
It seems like the issue you're experiencing could be connected to the version of Odoo you're using. Our current support extends up to version 7. Are you perhaps using a higher version? If so, please let me know, and I'll gladly include you in our feature request to add support for version 8 and above.
Please keep us posted! 😊
+6- Zapier Staff
- Answer
Hi
Thank you for the screenshot!
It looks like any version from 8 onwards is not yet supported by the Zapier Odoo integration. It's something other users have asked for and is currently logged as a Feature request. What I've done is added your vote for this Feature request. That does a few things:
- Bring this to the attention of the integration developers
- Help track interest in this feature being implemented
- Allows us to notify you via email if this feature becomes available in the future
While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!
I apologize if we don’t support Odoo version 8 above at the moment. If you have any other questions, please don’t hesitate to ask in the Community. We’re always happy to help! 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.