About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Failed to create a create lead/opportunity in Odoo ERP Self Hosted

  • 23 May 2023
  • 5 replies
  • 132 views
blocktec

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.

icon

Best answer by ken.a 25 May 2023, 07:05

View original

5 replies

ken.a
Userlevel 7
Badge +6

Hi there @blocktec,

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! 😊

blocktec

 

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.

ken.a
Userlevel 7
Badge +6

Hi @blocktec,

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! 😊

blocktec

We are using this version. Thank you @ken.a !

ken.a
Userlevel 7
Badge +6

Hi @blocktec,

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! 😊

Reply


Terms & Conditions