Pages: [1]
Jnargus
 
BAM!ID: 29497
Joined: 2007-06-28
Posts: 60
Credits: 238,344,862
World-rank: 6,425

2012-06-24 13:59:44

The overtake stats for a project from within a country generate the following sql errors. Overtake stats for Boinc Overall work but not for individual projects. I checked out a different country and got the same results. Below are the results from two of my projects, Constellation and Seti.

http://boincstats.com/en/stats/104/user/detail/284
http://boincstats.com/en/stats/104/user/list/0/0/Canada#2
http://boincstats.com/en/stats/104/user/overtake/284/1/Canada
Column 'Name' in where clause is ambiguous SELECT `constellation_countries`.`id`, `constellation_countries`.`Name`, `name_short` FROM `constellation_countries` LEFT jOIN `boinc_countries` ON `constellation_countries`.`Name` = `boinc_countries`.`Name` WHERE `Name` = 'Canada' LIMIT 1


http://boincstats.com/en/stats/0/user/overtake/38229/1/Canada
Column 'Name' in where clause is ambiguous SELECT `sah_countries`.`id`, `sah_countries`.`Name`, `name_short` FROM `sah_countries` LEFT jOIN `boinc_countries` ON `sah_countries`.`Name` = `boinc_countries`.`Name` WHERE `Name` = 'Canada' LIMIT 1

Thanks for all your hard work Willy.

jna
[BOINCstats] Willy
 
Forum moderator - Administrator - Developer - Tester - Translator
BAM!ID: 1
Joined: 2006-01-09
Posts: 9442
Credits: 353,172,950
World-rank: 4,885

2012-06-24 14:17:42

Fixed, but due to caching some pages may only show correct data after the daily update!
Please do not PM, IM or email me for support (they will go unread/ignored). Use the forum for support.
Pages: [1]

Index :: BOINCstats Bug Report :: SQL error in country Overtake Stats for a project
Reason: