[Dolibarr-bugtrack] [bug #15427] Unknown column 'p.rowid' in 'on clause'

[anonymous]

URL:
  <http://savannah.nongnu.org/bugs/?func=detailitem&item_id=15427>

                 Summary:  Unknown column \'p.rowid\' in \'on clause\'
                 Project: Dolibarr
            Submitted by: None
            Submitted on: jeu 12.01.2006 à 09:37
                Severity: 3 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
                 Release: 2.0.0-alpha2
        Platform Version: Microsoft Windows

    _______________________________________________________

Details:

telechargement de la release 2.0.0.beta 1 
install vierge 
version de la base 5.0.15-nt

commande client

Lorsque les 2 modules: commande client et compta sont activés pour le compte
admin voici l\'erreur: visiblement il manque un champs dans une table.


Server: Apache/2.0.55 (Win32) mod_autoindex_color mod_ssl/2.0.55
OpenSSL/0.9.8a PHP/5.0.5
Url sollicitée: /erp/compta/index.php?mainmenu=accountancy
QUERY_STRING: mainmenu=accountancy
Referer:
http://192.168.0.12/erp/user/perms.php?id=1&action=addrights&module=compta

Type gestionnaire de base de donnée: mysql
Requete dernier acces en base: SELECT sum(f.total) as tot_fht,
sum(f.total_ttc) as tot_fttc ,s.nom, s.idp, p.rowid, p.ref, p.total_ht,
p.total_ttc FROM llx_commande AS p, llx_societe AS s LEFT JOIN llx_co_fa AS
co_fa ON co_fa.fk_commande = p.rowid LEFT JOIN llx_facture AS f ON
co_fa.fk_facture = f.rowid WHERE p.fk_soc = s.idp AND p.fk_statut >=1 AND
p.facture=0 GROUP BY p.rowid
Code retour dernier acces en base: DB_ERROR_NOSUCHFIELD
Information sur le dernier accès en base: Unknown column \'p.rowid\' in \'on
clause\'






    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?func=detailitem&item_id=15427>

_______________________________________________
  Message posté via/par Savannah
  http://savannah.nongnu.org/