Taggato: Database error
-
AutorePost
-
31 Luglio 2023 alle 21:57 #4887
Ciao Ho questo errore in dolibarr dà quando ho aggiornato alla versione 17.0.2.
Nel fare l’aggiornamento non ho visto messaggi di errore
Sapete dirmi come posso sistemare?
GrazieDolibarr has detected a technical error.
This information can be useful for diagnostic purposes (you can set option $dolibarr_main_prod to ‘1’ to hide sensitive information):
Date: 20230731193520
Dolibarr: 17.0.2 – https://www.dolibarr.org
Level of features: 0
PHP: 7.0.33-0ubuntu0.16.04.16
Server: Apache
OS: Linux ip-172-31-59-222 4.4.0-1128-aws #142-Ubuntu SMP Fri Apr 16 12:42:33 UTC 2021 x86_64
User Agent: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36Requested URL: /index.php?mainmenu=home
Referer: xxxx
Menu manager: eldy_menu.phpModules/Applications: user, api, receiptprinter, projet, banque, commande, expensereport, facture, fournisseur, holiday, margin, opensurvey, printing, salaries, societe, stripe, loan, tax, comptabilite, product, stock, notification, supplier_proposal, efattita, mailing, paymentbybanktransfer, fckeditor, workflow, timesheet, paypal, expedition, productbatch, webservices
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 gre_commande as c, gre_commandedet as tl, gre_product as product INNER JOIN gre_societe_commerciaux as sc ON c.fk_soc = sc.fk_soc AND sc.fk_user = 13 WHERE c.entity IN (1) AND c.rowid = tl.fk_commande AND tl.fk_product = product.rowid AND c.date_commande 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 ‘c.fk_soc’ in ‘on clause’-
Questo topic è stato modificato 2 anni, 4 mesi fa da
billyva.
8 Settembre 2023 alle 09:31 #4889Verifica che nella tabella gre_commande tu abbiamo il campo fk_soc di tipo int(11)
-
Questo topic è stato modificato 2 anni, 4 mesi fa da
-
AutorePost
- Devi essere connesso per rispondere a questo topic.
