Friday, July 19, 2024
4 changes · saas-17.2
Resolved issues and error corrections
This fix helps Odoo recover when many browser sessions are waiting for live notifications at the same time. It reduces overload on the connection pool and spaces out reconnection attempts, lowering the risk of users being disconnected during busy periods or server restarts.
Original PR description
When no cursor is available to fetch bus notifications, websockets retry up to 10 times to acquire one. However, when many websockets try to acquire a cursor, the chances of getting one are very slim. Some will disconnect and will need a cursor to reconnect, worsening the cursor drought. As a result, there is minimal chance of recovery when the connection pool is full. This PR fixes this issue by wrapping cursor acquisition with a semaphore. This way, trying to acquire a cursor when none is available will make the caller wait until one is available.
The spreadsheet component was updated to the latest version for this Odoo release. This fixes an issue where COUNTIF did not correctly handle dates, helping users get more reliable spreadsheet calculations.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/9e0ea2429 [REL] 17.2.17 Task: 0 https://github.com/odoo/o-spreadsheet/commit/f82ac1750 [FIX] functions: COUNTIF does not handle dates Task: 4045506 Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com> Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com> Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com> Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com> Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com> Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com> Co-authored-by: Rémi Rahir (rar) <rar@odoo.com> Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com> Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>
The Point of Sale now handles cases where a sale order includes products that are not available in the PoS and the user lacks product editing rights. This prevents the order loading process from failing, helping staff continue sales workflows without needing extra permissions.
Original PR description
Before this commit, attempting to load a sale order into the PoS with products not available in the PoS would fail if the user lacked write access to the product, preventing the sale order from being loaded. opw-4057869 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Restaurant staff can now scroll through the floor view when there are more tables than fit on the screen. This restores access to hidden tables, making it possible to select and manage all tables in larger restaurant layouts.
Original PR description
Currently, if a restaurant has so many table that some are hidden down the screen, it is impossible to scroll down to select the hidden table. Steps to reproduce: ------------------- * Open the **Poin of sale** App * Open restaurant session * Switch floor view * Edit plan * Add many tables such as some are not visible on the screen * Try scrolling > Observation: Unable to scroll Why the fix: ------------ For some reason, the ability to scroll in the floor view was removed with this commit https://github.com/odoo/odoo/commit/b42b0f8b541a13621b671b0b7e57812ef11fc1b2 The value changed from `overflow-auto` to `overflow-hidden` here https://github.com/odoo/odoo/blob/fb4d758ed78211a61ea797759e1fb3b02b51be60/addons/pos_restaurant/static/src/app/floor_screen/floor_screen.xml#L66 opw-4051308