search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.29k stars 2.74k forks source link

Bug stats on project tasks #11856

Closed sam-anam1 closed 3 years ago

sam-anam1 commented 5 years ago

Dolibarr: 10.0.1 Level of features: 0 PHP: 7.2 Server: Apache/2.4.25 OS: Linux htdocs/projet/class/tasksstats.class.php

Bug

it shows for external users end with read user project permission .

Dolibarr has detected a technical error Requested URL: /htdocs/projet/tasks/stats/index.php?leftmenu=projects Referer: /htdocs/projet/index.php?mainmenu=project&leftmenu= Menu manager: eldy_menu.php

Modules/Applications: user, product, accounting, service, stock, projet, resource, ecm, categorie, multicurrency, bookmark, workflow, export, opensurvey, notification, mailing, emailcollector, cron, socialnetworks, paypal, clicktodial, holiday, expensereport, adherent, societe, propal, commande, contrat, ficheinter, ticket, agenda, fournisseur, supplier_proposal, facture, tax, salaries, loan, banque, prelevement, margin Database type manager: mysqli Latest database access request error: SELECT date_format(t.datec,'%m') as dm, COUNT(t.rowid) as nb FROM llx_projet_task as t INNER JOIN llx_projet as p ON p.rowid = t.fk_projet INNER JOIN llx_societe_commerciaux as sc ON sc.fk_soc=t.fk_soc AND sc.fk_user=2 WHERE t.entity IN (1) AND p.fk_soc=2 AND t.datec BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' GROUP BY dm ORDER BY dm DESC

Return code for latest database access request error: DB_ERROR_NOSUCHFIELD Information for latest database access request error: Unknown column 't.fk_soc' in 'on clause'

byque commented 4 years ago

It also shows for non-admin users with read user project permission. I found a bypass by activating the user permission to extend access to third parties. dolibarr_fix

github-actions[bot] commented 3 years ago

This issue is stale because it has been open 1 year with no activity. If this is a bug, please comment to confirm it is still present on latest stable version. if this is a feature request, please comment to notify the request is still relevant and not yet covered by latest stable version. This issue may be closed automatically by stale bot in 10 days (you should still be able to re-open it if required).

aweher commented 1 year ago

Same here after upgrading to from 16.0.3 to 16.0.4

Modules/Applications: user, contrat, supplier_proposal, tax, categorie, fckeditor, multicurrency, product, mailing, geoipmaxmind, oauth, receiptprinter, gravatar, propal, partnership, paymentbybanktransfer, prelevement, productbatch, stock, expedition, projet, eventorganization, bookmark, notification, ficheinter, reception, agenda, banque, barcode, cron, ecm, expensereport, opensurvey, printing, resource, salaries, service

Database type manager: mysqli

Latest database access request error: SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM erp_propal as p, erp_propaldet as tl, erp_product as product INNER JOIN erp_societe_commerciaux as sc ON p.fk_soc = sc.fk_soc AND sc.fk_user = 2 WHERE p.entity IN (1) AND p.rowid = tl.fk_propal AND tl.fk_product = product.rowid AND p.datep BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC

Return code for latest database access request error: DB_ERROR_NOSUCHFIELD

Information for latest database access request error: Unknown column 'p.fk_soc' in 'on clause'