Can't Validate Invoice

Just tried to Invoice my first invoice on V10
Got the error. Upgraded to V12
Still the same error.

Can someone help ?

Dolibarr has detected a technical error.
This information can be useful for diagnostic purposes (you can set option $dolibarr_main_prod to ‘1’ to remove such notices):
Date: 20200720140055
Dolibarr: 12.0.1 -
Level of features: 0
PHP: 7.2.32
Server: LiteSpeed
OS: Linux 3.10.0-962.3.2.lve1.5.36.el7.x86_64 #1 SMP Mon May 18 02:16:06 EDT 2020 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36

Requested URL: /compta/facture/card.php?facid=1&action=confirm_valid&confirm=yes&token=%242y%2410%24TJ08Jf.LP9GPWv5ijcPyw.qv6FzA0lABORnaIqlg2.V02KWvHaK.W
Menu manager: eldy_menu.php

Modules/Applications: api, user, prelevement, modulebuilder, externalrss, subtotal, paypal, forceproject, listexportimport, contrat, webservices, customersowed, importpropallines, visualquery, fckeditor, propal, bookmark, ficheinter, tax, loan, banque, margin, product, stock, projet, categorie, workflow, import, export, ticket, blockedlog, myinventory, dolibaseinstaller, agenda, barcode, cron, concatpdf, commande, ecm, fournisseur, holiday, salaries, societe, service, facture, notification, socialnetworks, supplier_proposal, kanprospects, incoterm, multicurrency
Database type manager: mysqli
Latest database access request error: SELECT facnumber as ref FROM llx_facture WHERE rowid=1
Return code for latest database access request error: DB_ERROR_NOSUCHFIELD
Information for latest database access request error: Unknown column ‘facnumber’ in ‘field list’

@ksar or @eldy can you help ?


facnumber was changed to ref in V10.
So if you have a facnumber in the SQL querry, means that either :

  1. You have old PHP files => Replace all the files
  2. You have an old custom module that is not up to date.

If you do not succeed to solve your issue, I recommend a fresh install.

1 Like