Odoo BigCommerce Integration Issues

[liamcjones]

Select Topic Area

Bug

Body

Hey everyone, I am very inexperienced when it comes to coding, as I just started to learn at the beginning of this year when implementing our Odoo .SH project. We are currently working on v17.
That said, I have installed some custom code from the Odoo App Store, which works fine for a bit, but then I start to get server errors, specifically:

RPC_ERROR
Odoo Server Error
Traceback (most recent call last):
File "/home/odoo/src/odoo/odoo/http.py", line 1783, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/home/odoo/src/odoo/odoo/service/model.py", line 133, in retrying
result = func()
File "/home/odoo/src/odoo/odoo/http.py", line 1810, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/home/odoo/src/odoo/odoo/http.py", line 2014, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/home/odoo/src/odoo/odoo/addons/base/models/ir_http.py", line 222, in _dispatch
result = endpoint(**request.params)
File "/home/odoo/src/odoo/odoo/http.py", line 759, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/home/odoo/src/odoo/addons/web/controllers/dataset.py", line 24, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/home/odoo/src/odoo/addons/web/controllers/dataset.py", line 20, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/home/odoo/src/odoo/odoo/api.py", line 464, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/home/odoo/src/odoo/odoo/api.py", line 435, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/home/odoo/src/odoo/addons/web/models/models.py", line 237, in web_read_group
groups = self._web_read_group(domain, fields, groupby, limit, offset, orderby, lazy)
File "/home/odoo/src/odoo/addons/web/models/models.py", line 263, in _web_read_group
groups = self.read_group(domain, fields, groupby, offset=offset, limit=limit,
File "/home/odoo/src/odoo/odoo/models.py", line 2740, in read_group
rows = self._read_group(domain, annoted_groupby.values(), annoted_aggregates.values(), offset=offset, limit=limit, order=orderby)
File "/home/odoo/src/odoo/odoo/models.py", line 1919, in _read_group
self.env.cr.execute(SQL("\n").join(query_parts))
File "/home/odoo/src/odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.SyntaxError: each UNION query must have the same number of columns
LINE 106: -MIN(l.id) AS id,
^

The above server error caused the following client error:
OwlError: An error occured in the owl lifecycle (see this Error's "cause" property)
Error: An error occured in the owl lifecycle (see this Error's "cause" property)
at handleError (https://liamcjones-all-safety-staging-bc-15908263.dev.odoo.com/web/assets/d15dee8/web.assets_web.min.js:916:101)
at App.handleError (https://liamcjones-all-safety-staging-bc-15908263.dev.odoo.com/web/assets/d15dee8/web.assets_web.min.js:1548:29)
at ComponentNode.initiateRender (https://liamcjones-all-safety-staging-bc-15908263.dev.odoo.com/web/assets/d15dee8/web.assets_web.min.js:1006:19)

Caused by: RPC_ERROR: Odoo Server Error
RPC_ERROR
at makeErrorFromResponse (https://liamcjones-all-safety-staging-bc-15908263.dev.odoo.com/web/assets/d15dee8/web.assets_web.min.js:2893:163)
at XMLHttpRequest. (https://liamcjones-all-safety-staging-bc-15908263.dev.odoo.com/web/assets/d15dee8/web.assets_web.min.js:2897:13)

Can anyone assist as to what this issue could be related to?
I have inquired with the developer, however they are relatively slow to respond due to timezone differences.

Thanks in advance

[github-actions[bot]]

💬 Your Product Feedback Has Been Submitted 🎉

Thank you for taking the time to share your insights with us! Your feedback is invaluable as we build a better GitHub experience for all our users.

Here's what you can expect moving forward ⏩

• Your input will be carefully reviewed and cataloged by members of our product teams. 
  • Due to the high volume of submissions, we may not always be able to provide individual responses.
  • Rest assured, your feedback will help chart our course for product improvements.
• Other users may engage with your post, sharing their own perspectives or experiences. 
• GitHub staff may reach out for further clarification or insight. 
  • We may 'Answer' your discussion if there is a current solution, workaround, or roadmap/changelog post related to the feedback.

Where to look to see what's shipping 👀

• Read the Changelog for real-time updates on the latest GitHub features, enhancements, and calls for feedback.
• Explore our Product Roadmap, which details upcoming major releases and initiatives.

What you can do in the meantime 💻

• Upvote and comment on other user feedback Discussions that resonate with you.
• Add more information at any point! Useful details include: use cases, relevant labels, desired outcomes, and any accompanying screenshots.

As a member of the GitHub community, your participation is essential. While we can't promise that every suggestion will be implemented, we want to emphasize that your feedback is instrumental in guiding our decisions and priorities.

Thank you once again for your contribution to making GitHub even better! We're grateful for your ongoing support and collaboration in shaping the future of our platform. ⭐

[BhathiyaPrasad]

This error message indicates that the UNION SQL query being generated in and executed in Odoo , UNION query must have same number and structure of columns you have to check what type of columns used in the custom module and what column types are in your Odoo application