Event:
# 1066: Not unique table/alias: 'mMenu'
SQL:
SELECT mMenu.pName AS aliasParent,mMenu.pID,mMenu.pName,mMenu.pParent,mMenu.pSub,mMenu.pUser,mMenu.pStamp FROM mMenu LEFT JOIN mMenu ON mMenu.pParent=mMenu.pID ORDER BY pStamp DESC LIMIT 0,5
Is this query at all possible, or are you not allowed to LEFT JOIN the same table you are selecting from?
I realize the "mMenu.pName as aliasParent" is pointless in the sql at this point, but this seems to be one bug i've just encountered in my system and i'm trying to work out a fix for it.
What the sql was suppose to do in the left join was to "replace" the pParent with the corresponding pName from the same table.
Anyone care to shed some light on the actual problem and a possible fix?
