MySQL Forums
Forum List  »  Install & Repo

Re: error 1054: Unknown column
Posted by: Andrew Zabolotny
Date: November 26, 2006 06:58AM

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?

Options: ReplyQuote


Subject
Written By
Posted
July 06, 2006 01:29AM
October 18, 2006 06:17PM
November 15, 2006 10:12AM
Re: error 1054: Unknown column
November 26, 2006 06:58AM


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.