Bonjour,
Suite à la migration qui semble s’être bien passée, plusieurs erreurs se produisent:
En Cliquant sur un client: J’ai l’erreur suivante :
Apparemment il manque une colonne.
Dolibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20130327181547
Dolibarr: 3.3.1
Level of features: 0
PHP: 5.2.17
Server: Apache/2.2.X (OVH)
Requested Url: /erp2/htdocs/societe/soc.php?socid=11
Referer: http://www.atwy.fr/erp2/htdocs/comm/list.php?leftmenu=customers
Menu manager: eldy_backoffice.php
Database type manager: mysql
Request for last database access in error: SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.tel as phone, s.fax, s.email, s.url, s.cp as zip, s.ville as town, s.note, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, s.mode_reglement, s.cond_reglement, s.tva_assuj, s.localtax1_assuj, s.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id WHERE s.rowid = 11
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column ‹ s.idprof5 › in ‹ field list ›
Message: Unknown column ‹ s.idprof5 › in ‹ field list ›
En cliquant sur une Devis déjà renseignée sous l’ancienne version:
This customer has no relative discount by default.
This customer still has credit notes for -1.00 Euros: Dolibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20130327181653
Dolibarr: 3.3.1
Level of features: 0
PHP: 5.2.17
Server: Apache/2.2.X (OVH)
Requested Url: /erp2/htdocs/comm/propal.php?id=13
Referer: http://www.atwy.fr/erp2/htdocs/index.php?mainmenu=home&leftmenu=
Menu manager: eldy_backoffice.php
Database type manager: mysql
Request for last database access in error: SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_facture_source FROM llx_societe_remise_except as re WHERE fk_soc = AND fk_facture IS NULL AND fk_facture_line IS NULL AND (fk_facture_source IS NULL) ORDER BY re.description ASC
Return code for last database access in error: DB_ERROR_SYNTAX
Information for last database access in error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ AND fk_facture IS NULL AND fk_facture_line IS NULL AND (fk_facture_source IS NUL › at line 1
This customer still has credit notes for -1.00 Euros.
Et un gros message en popup rouge. : Unknown column ‹ p.extraparams › in ‹ field list ›
En cliquant sur une Facture.
Dolibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20130327181843
Dolibarr: 3.3.1
Level of features: 0
PHP: 5.2.17
Server: Apache/2.2.X (OVH)
Requested Url: /erp2/htdocs/compta/facture.php?facid=5
Referer: http://www.atwy.fr/erp2/htdocs/index.php?mainmenu=home&leftmenu=
Menu manager: eldy_backoffice.php
Database type manager: mysql
Request for last database access in error: SELECT f.rowid,f.facnumber,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc,f.amount,f.tva, f.localtax1, f.localtax2, f.total,f.total_ttc,f.remise_percent,f.remise_absolue,f.remise, f.datef as df, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note as note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.fk_facture_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet, f.extraparams, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id WHERE f.entity = 1 AND f.rowid=5
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column ‹ f.extraparams › in ‹ field list ›
Message: Unknown column ‹ f.extraparams › in ‹ field list ›