This topic is: not resolved

Taggato: 

Stai visualizzando 2 post - dal 1 a 2 (di 2 totali)
  • Autore
    Post
  • #4887
    billyva
    Partecipante
    Post count: 2

    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?
    Grazie

    Dolibarr 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.36

    Requested URL: /index.php?mainmenu=home
    Referer: xxxx
    Menu manager: eldy_menu.php

    Modules/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 1 anno, 3 mesi fa da billyva.
    #4889
    Avatar photoaschio_19
    Amministratore del forum
    Post count: 400

    Verifica che nella tabella gre_commande tu abbiamo il campo fk_soc di tipo int(11)

Stai visualizzando 2 post - dal 1 a 2 (di 2 totali)
  • Devi essere connesso per rispondere a questo topic.