Country Code is invalid (Australia)

gcode-mirror / ai-contest

Automatically exported from code.google.com/p/ai-contest

0 stars 1 forks source link

Country Code is invalid (Australia) #62

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. Create an account, with country of Australia
2. Go to My Profile
3. Country will be 'unknown'
4. Click on 'unknown' and it says: Invalid Country ID

What is the expected output? What do you see instead?
Australia should be a valid country code

Original issue reported on code.google.com by zap...@gmail.com on 7 Sep 2010 at 11:45

GoogleCodeExporter commented 9 years ago

It happens because country_profile.php tries to select from non-existant 
contest_countries table. 
Correct table name is countries  (used by register.php).

Original comment by naktibalda@gmail.com on 11 Sep 2010 at 11:43

GoogleCodeExporter commented 9 years ago

I created a patch that discards contest_ prefix in all queries.

Original comment by naktibalda@gmail.com on 13 Sep 2010 at 6:32

Attachments:

discard_contest_prefix.patch

GoogleCodeExporter commented 9 years ago

I'll commit it this evening.

Original comment by danie...@gmail.com on 13 Sep 2010 at 6:37

Changed state: Accepted

GoogleCodeExporter commented 9 years ago

Issue 144 has been merged into this issue.

Original comment by danie...@gmail.com on 13 Sep 2010 at 7:57

GoogleCodeExporter commented 9 years ago

I didn't get this in until now. :( 

Thanks again for the patch.

Original comment by danie...@gmail.com on 16 Sep 2010 at 10:33

Changed state: Done