~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Rapport d'erreur
Date : 01/08/2010 à 07h 08m 50s
Version :2.5 2004.10.27
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Source de la requête :
Page : /home/www/galopspatial/eve/arbo.php
Ligne : 38

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message d'erreur:
Impossible d'exécuter la requête

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dernière requête SQL:
SELECT count(c.marketGroupID) as nb,a.marketGroupID as pi,a.marketGroupName as pn,b.marketGroupID as fi,b.marketGroupName as fn
FROM invmarketgroups a,invmarketgroups b left join invmarketgroups c on(c.parentGroupID=a.marketGroupID)
WHERE a.parentGroupID is null
AND a.marketGroupID=b.parentGroupID group by a.marketGroupID,a.marketGroupName,b.marketGroupID,b.marketGroupName
ORDER BY 3,5

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Erreur SQL:
1054 : Unknown column 'a.marketGroupID' in 'on clause'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Page precédente