Highscores problem

Ben · **Posted:** July 25th, 2007, 10:02 am

Quote:

MySQL ERROR 1054: Unknown column 'd.guthixXP' in 'field list'
Line 652 in file '/home/rsbandb/public_html/subdomains/highscores/index.php'
Arguments: 'SELECT SQL_CALC_FOUND_ROWS `u`.`name`, `ru`.`rank_id`, `d`.`guthixXP` AS `xptotal`, `d`.`added` FROM ((`hs_users` `u` JOIN `hs_users_gain_data` `d` ON `u`.`user_id` = `d`.`user_id`) JOIN `hs_rankusers` `ru` ON `u`.`user_id` = `ru`.`user_id`) JOIN (SELECT `rank_id` FROM `hs_ranks` WHERE (`clan_id` = '1' OR `clan_id` = '0') ORDER BY `rank_priority` ASC) AS `r` ON `ru`.`rank_id` = `r`.`rank_id` WHERE `d`.`inactive` = '0' AND `d`.`clan_id` = '1' AND `u`.`guthixXP` != '0' GROUP BY `u`.`user_id` ORDER BY `d`.`guthixXP` DESC LIMIT 0, 30',

Here's a screenshot:

The error message continued far to the right of the page, I hope I got it all in the quote.
Url was http://highscores.rsbandb.com/runescape_bits_and_bytes/full_high_scores/total_experience_gain/guthix

Adbot · **Posted:** July 25th, 2007, 10:02 am

Gontcha · **Posted:** July 25th, 2007, 10:22 am

None of the gods rankings works.

Ben · **Posted:** July 25th, 2007, 10:43 am

Gontcha wrote:

None of the gods rankings works.

So... The logical way to solve the problem would be to remove the references to them from the page until they are fixed?

Dan · **Posted:** July 25th, 2007, 10:56 am

BTBBBJL wrote:

So... The logical way to solve the problem would be to remove the references to them from the page until they are fixed?

Or you could stop complaining and ignore it.

Ben · **Posted:** July 25th, 2007, 11:10 am

Dan wrote:

Or you could stop complaining and ignore it.

I just don't want somebody else to complain about it before I do. This way, it's a known problem and will save people the time of making a topic like this one. We want to get all of the bugs out as soon as possible, don't we?

Anubis · **Posted:** July 25th, 2007, 1:14 pm

Look at your options. You've selected "experience gain total" and "guthix".

You can't measure the total experience gained for an average of a group of skills. I wouldn't expect it takes that data, just the levels of each skill, and averages it out. If it did, for that particular god, you'd just get the overall experience gained anyway. So it would be pretty pointless.

Adbot · **Posted:** July 25th, 2007, 1:14 pm

Ben · **Posted:** July 25th, 2007, 1:29 pm

Anubis wrote:

Look at your options. You've selected "experience gain total" and "guthix".

You can't measure the total experience gained for an average of a group of skills. I wouldn't expect it takes that data, just the levels of each skill, and averages it out. If it did, for that particular god, you'd just get the overall experience gained anyway. So it would be pretty pointless.

So the link to that page should be removed! My point exactly!

Anubis · **Posted:** July 25th, 2007, 1:52 pm

Well.. no.. maybe instead of the code which comes up, it should say "You can't do this, try selecting another option." or something similar.

Ben · **Posted:** July 25th, 2007, 1:58 pm

That might work even better.

Gzpro · **Posted:** July 25th, 2007, 2:26 pm

Dan wrote:

BTBBBJL wrote:

So... The logical way to solve the problem would be to remove the references to them from the page until they are fixed?

Or you could stop complaining and ignore it.

Aren't we nice. Send a pm to mike

Mike · **Posted:** July 25th, 2007, 3:12 pm

Thanks, it's been fixed... I forgot to remove those selections for that page.