Comments (5)
I've had this problem as well. It's caused by a query building routing in mail_activity.py (in version 13.0).
The query uses implicit and explicit joins mixed, which causes the error. Rewriting the query to only use implicit joins in the same scope works around the error. I have not extensively tested if this works for all modules that use the activity progress mixin.
Appying the following patch does this:
diff --git a/addons/mail/models/mail_activity.py b/addons/mail/models/mail_activity.py
index 1eb68e1486b..dfaa7041f1d 100644
--- a/addons/mail/models/mail_activity.py
+++ b/addons/mail/models/mail_activity.py
@@ -766,8 +766,8 @@ class MailActivityMixin(models.AbstractModel):
tz = self._context.get('tz') or self.env.user.tz or 'UTC'
select_query = """
SELECT 1 AS id, count(*) AS "__count", {fields}
- FROM {from_clause}
- JOIN (
+ FROM {from_clause} ,
+ (
SELECT res_id,
CASE
WHEN min(date_deadline - (now() AT TIME ZONE COALESCE(res_partner.tz, %s))::date) > 0 THEN 'planned'
@@ -780,8 +780,8 @@ class MailActivityMixin(models.AbstractModel):
JOIN res_partner ON (res_partner.id = res_users.partner_id)
WHERE res_model = '{model}'
GROUP BY res_id
- ) AS "_last_activity_state" ON ("{table}".id = "_last_activity_state".res_id)
- WHERE {where_clause}
+ ) AS "_last_activity_state"
+ WHERE ("{table}".id = "_last_activity_state".res_id) AND {where_clause}
GROUP BY {group_by}
""".format(
fields=', '.join(select_terms),
from fleet.
ping @rodrigonevest
from fleet.
There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.
from fleet.
@rodrigonevest are you can check please ?
from fleet.
There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.
from fleet.
Related Issues (17)
- Fleet maintenance and service planner HOT 1
- Migration to version 17.0
- [RFC] Proposal for vechicle repair shop modules, maybe a new vertical repo HOT 6
- Migration to version 14.0 HOT 3
- [RFC] Fleet Inspection Report HOT 12
- Module fleet_analytic_account HOT 3
- Weblate translation HOT 11
- [14.0] runbot: requested access to the resource is denied. HOT 1
- [14.0] fleet_vehicle_service_kanban: state or stage_id HOT 10
- [RFC] Proposal for new modules HOT 12
- [RFC] fleet: fleet.vehicle.log.fuel using the US liquid gallon unit of measure HOT 1
- Problem PR 61
- Odoo Client Error after click "Aprove/Refuse" buttons in inspection_line_ids HOT 3
- branch 11.0 HOT 1
- Migration to version 15.0 HOT 1
- Migration to version 16.0 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from fleet.