Home › Forums › Main › Tech Support

Problems accessing roster

5 replies [Last post]
Mon, 04/17/2006 - 09:54
meboom
meboom's picture
Offline
Joined: 07/09/2002

I get the following message when i try to access the roster.

Unknown column 'ro.officer_id' in 'on clause'

Meboom Mebigg, 75 Conqueror

Top
Mon, 04/17/2006 - 09:58
#1
Boad
Boad's picture
Online
Joined: 03/20/2002
Problems accessing roster

Thanks, I'll check on it.

-Boad

Boad Redblades
KOTG Webmaster and badly dressed retired Ranger

Top
Tue, 04/18/2006 - 18:47
#2
Wolfmanjack
Offline
Joined: 05/16/2005
Problems accessing roster

Same problem: Unknown column 'ro.officer_id' in 'on clause'

My Magelo link>>>Rogue

My Magelo link>>>

Top
Tue, 04/18/2006 - 23:26
#3
Boad
Boad's picture
Online
Joined: 03/20/2002
Problems accessing roster

Should be fixed now. The upgrade from MySQL 4.1 to 5.0 changed how they handle joins (it follows the standard now). This affected the crazy query I had for the roster. I changed the mixed joins (natural and left) to just be all left to make it easier.

-Boad

Boad Redblades
KOTG Webmaster and badly dressed retired Ranger

Top
Wed, 04/19/2006 - 09:18
#4
Wolfmanjack
Offline
Joined: 05/16/2005
Problems accessing roster

Thank You Boad your great Laughing out loud

My Magelo link>>>Rogue

My Magelo link>>>

Top
Thu, 04/20/2006 - 09:06
#5
meboom
meboom's picture
Offline
Joined: 07/09/2002
Problems accessing roster

Thanks Boad

Meboom Mebigg, 75 Conqueror

Top