'Bad Request'

[ghost]

Hi, my game sends a request like so: http://gamestats2.gs.nintendowifi.net/pokemondpds/worldexchange/info.asp?pid=21296&hash=fc4c546e3b0cd442a56b7066e166e4a5c6b0df90&data=Sjssnn8KCZ4=

And I always get "Bad Request" I never used to get this - I'm using the latest. Thanks, Poke

[mm201]

I'm not seeing anything in my logs. Are you using the production server or a private one?

[mm201]

To get you started, the only thing that request does is update a "last active" timestamp on your profile record in the database.

[ghost]

It's a private server. As it's on Linux, all I done was edit the DB for pokemon_form_stats to pokemon_form_Stats.

[mm201]

Check that all the columns in GtsProfiles4 other than pid, TimeAdded, and TimeUpdated allow nulls.

[mm201]

And sorry about the capitalization of table names. OSX is perfectly happy with it... This is something I'm in the process of changing.

[ghost]

It's fine, don't worry about doing it - Just remember not every OS likes them :P

[ghost]

They all allow nulls. http://prntscr.com/8ottk5 It seems like the script iself is refusing, yet there's a 500 in my logs from the 3DS doing it.

(127.0.0.1 occurs because I use SSH Tunnel to access it)

[ghost]

@mm201 any ideas?

[ghost]

.................................

[ghost]

@mm201 I done a packet dump, here's the 500 response I get from Mono: http://prntscr.com/8pte7h

[mm201]

Now that's interesting. The crash is in the GamestatsBase library. Could you provide the request data?

[ghost]

What do you mean by request data?

[ghost]

Do you mean packet dump?

[ghost]

If you mean by what I request:

86.145.181.49 - - [10/Oct/2015:15:15:16 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296 HTTP/1.1" 200 285 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:15:15:16 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296&hash=7733e60db6ef9dc5ed00ba75aa55c0173bd8f5d4&data=Sjssnn8KCZ4= HTTP/1.1" 500 5017 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:15:16:24 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296 HTTP/1.1" 200 285 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:15:16:24 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296&hash=24f8b76ecfb596a34de599e39ea226a5f682551d&data=Sjssnn8KCZ4= HTTP/1.1" 500 5017 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:15:43:16 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296 HTTP/1.1" 200 285 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:15:43:17 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296&hash=d80278b66d6ff63f907a2276739ff4e0320ceee3&data=Sjssnn8KCZ4= HTTP/1.1" 500 5017 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:18:48:39 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296 HTTP/1.1" 200 285 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:18:48:42 +0200] "GET /pokemondpds/worldexchange/info.asp?pid=21296&hash=769910e243af17e4ba534de524c5aaffcf76b68d&data=Sjssnn8KCZ4= HTTP/1.1" 500 5017 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:19:28:06 +0200] "GET /pokemondpds/battletower/info.asp?pid=21296 HTTP/1.1" 200 285 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:19:28:08 +0200] "GET /pokemondpds/battletower/info.asp?pid=21296&hash=9f2ad5949c69d4a8daadbea7df6e396713c12f31&data=Sjssnn8KCZ4= HTTP/1.1" 500 5017 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:19:32:01 +0200] "GET /pokemondpds/battletower/info.asp?pid=21296 HTTP/1.1" 200 285 "-" "GameSpyHTTP/1.0" 86.145.181.49 - - [10/Oct/2015:19:32:03 +0200] "GET /pokemondpds/battletower/info.asp?pid=21296&hash=11eb83b98f81780c5aed440e37c74a1859fc3dbc&data=Sjssnn8KCZ4= HTTP/1.1" 500 5017 "-" "GameSpyHTTP/1.0"

[ghost]

I've just added you on Skype, so we could continue ourdiscussion there.

[mm201]

Is the setProfile.asp request succeeding?

[ghost]

There's no setProfile.asp request at all. I've connected to yours before, but that shouldn't affect it, right?

[ghost]

Another question - why not consider porting this to PHP?

[ghost]

Question: Any fixes for mono yet?