[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Dolibarr-bugtrack] [Bug #1336] postgresql cast compta/bank/class/accoun

From: Doliforge
Subject: [Dolibarr-bugtrack] [Bug #1336] postgresql cast compta/bank/class/account.class.php:615
Date: Sun, 06 Apr 2014 00:55:12 +0200

Is this email not displaying correctly?
update email preferences.

postgresql cast compta/bank/class/account.class.php:615


Submitted by:  Yann Verry (yverry) Submitted on:  2014-04-06 00:55
Last Modified On:  2014-04-06 00:55 
Summary:  postgresql cast compta/bank/class/account.class.php:615
Description:  Bonjour,

Récemment migré en pg avec dolibarr je ne peut pas afficher l'onglet de banques/caisses en raison d'un erreur SQL:

=> SELECT ba.rowid, ba.ref, ba.label,, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state FROM llx_bank_account as ba LEFT JOIN llx_c_pays as p ON ba.fk_pays = p.rowid LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid WHERE entity IN (1) AND ba.rowid = 1;
ERROR: operator does not exist: character varying = integer
LINE 1: ...LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid ...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

La solution est d'ajouté un CAST(ba.state_id as numeric) dans la requête. Évidemment cela n'est pas compatible avec MySQL

Step to reproduce bug:  Afficher l'onglet banques/caisses avec une installation PG
Detected in version:  3.5.1 Category:  Module: Banks and Cash
Severity:  2 OS Type/Version:  Debian
PHP version:  5.5.10 Database type and version:  PG9.3
Status:  Open Assigned to:  None
Resolution:  None 

Answer now

reply via email to

[Prev in Thread] Current Thread [Next in Thread]