Re: error 1054: Unknown column
Same here. I'm using ps_stats (a php script for collecting & displaying Counter-Strike stats) and after I've upgraded to mysql 5.x I'm getting:
[Local MySQL] ERROR 1054: Unknown column 'm.gamemapid' in 'on clause'
on the following statement (I've removed all extra stuff that does not change the problem so you may see that def is unused):
SELECT m.*
FROM cslan_gamemaps as m, cslan_defs_maps as def
LEFT JOIN cslan_gamemaps_cstrike as mm ON mm.gamemapid=m.gamemapid
If I remove the "cslan_defs_maps as def" clause, it kind of 'works', but that's not what I want.
Any ideas?
Subject
Written By
Posted
November 15, 2006 10:12AM
Re: error 1054: Unknown column
November 26, 2006 06:58AM
November 26, 2006 07:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.