search

williamleonard / obblm

Automatically exported from code.google.com/p/obblm
1 stars 0 forks source link

Match submission problems- BIGINT UNSIGNED #525

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
1. Created new league, with fresh install of v0.9 rc1 along with divisions, 
coaches, tournaments etc.
2. Created 2 brand new teams via software.
3. Created match for both teams and submit results.
4. "Request Succeeded ; BIGINT UNSIGNED value is out of range in 
'(`sobbdata`.`mv_players`.`gf` - `sobbdata`.`mv_players`.`ga`)' "

{where sobbdata is the name of the SQL database.

5. Match is shown as submitted (ie. now in recent matches) yet player, and team 
stats are not updated.

can see website at grays.sytes.net/sobb/

Other Info:
-This had to be a fresh install as I deleted the previous SQL database, fresh 
install of database and then created teams.
-Game was a concession for one team, ie. 2 MVP for one team, extra winnings for 
one team, none for the other.
-Checking the SQL database, the item sobbdata.mv_players is null

Original issue reported on code.google.com by dahma...@gmail.com on 3 Jun 2011 at 9:58

GoogleCodeExporter commented 9 years ago 
More discovery:

I did the same above procedure for a new install of v0.8 and experienced the 
same error.

I thought it might have to do with the tournament ranking scheme I was using. 
Switched to the default and yet again experienced the same error.

This only leads me towards the manner in which I am submitting matches might be 
in error. If it's not that, then I'm stumped.

Original comment by dahma...@gmail.com on 4 Jun 2011 at 1:07

GoogleCodeExporter commented 9 years ago 
With the new install, did you use clean settings, or your own?

Original comment by Nimda...@gmail.com on 5 Jun 2011 at 6:50

GoogleCodeExporter commented 9 years ago 
The only settings I would have changed would be the database login info and the 
tournament rankings, which I then reset and still have the same error.

Original comment by dahma...@gmail.com on 6 Jun 2011 at 5:44

GoogleCodeExporter commented 9 years ago 
What is the version of MySQL?

Original comment by funnyfin...@hotmail.com on 7 Jun 2011 at 1:53

GoogleCodeExporter commented 9 years ago 
My friend who is hosting says the MySQL is version 5.0.7 with SQLlite version 
3.6.22

Original comment by dahma...@gmail.com on 7 Jun 2011 at 2:49

GoogleCodeExporter commented 9 years ago 
With a new match, I don't think you have to syncall after a change, but you can 
try a syncall.

Original comment by funnyfin...@hotmail.com on 7 Jun 2011 at 3:12

GoogleCodeExporter commented 9 years ago 
I just want to make sure... do you mean MySQL 5.0.77?

Original comment by funnyfin...@hotmail.com on 7 Jun 2011 at 3:15

GoogleCodeExporter commented 9 years ago 
Mysql 5.5.8 here and same problem :S

Original comment by Pencer...@gmail.com on 7 Jun 2011 at 8:50

Attachments:

GoogleCodeExporter commented 9 years ago 
I would very much like a dump of your database AND a screenshot of what you 
submitted on the match report page.

Original comment by Nimda...@gmail.com on 9 Jun 2011 at 12:11

GoogleCodeExporter commented 9 years ago 
The match report can be found at grays.sytes.net/sobb/ and is the only match on 
the main splash page (The Rad vs Da Krook'd Teef). It's been locked so nothing 
will have changed.

I have uploaded a dump of my SQL database.

Original comment by dahma...@gmail.com on 10 Jun 2011 at 8:28

Attachments:

GoogleCodeExporter commented 9 years ago 
Better yet, here's an htm of the match report.

Original comment by dahma...@gmail.com on 10 Jun 2011 at 8:31

Attachments:

GoogleCodeExporter commented 9 years ago 
Found the problem.

MySQL > 5.5.5 is more type strict, which means it produces errors where older 
versions did not. See 
http://dev.mysql.com/doc/refman/5.5/en/out-of-range-and-overflow.html

I'm working on this..

Original comment by Nimda...@gmail.com on 11 Jun 2011 at 9:07

GoogleCodeExporter commented 9 years ago 
I'm stuck. I can't reproduce at all. Can I get access to one of your webhotels 
and mysql db to debug further?

Original comment by Nimda...@gmail.com on 11 Jun 2011 at 10:55

GoogleCodeExporter commented 9 years ago 
..Also, could you please try with the new RC2 from the downloads section ?

Original comment by Nimda...@gmail.com on 11 Jun 2011 at 11:02

GoogleCodeExporter commented 9 years ago 
Oh, what points system are you guys using?
Please try a different one - does it make a difference?

Original comment by Nimda...@gmail.com on 14 Jun 2011 at 10:57

GoogleCodeExporter commented 9 years ago

Original comment by Nimda...@gmail.com on 14 Jun 2011 at 11:39

GoogleCodeExporter commented 9 years ago 
Will try the new RC2.

Originally had a custom point system but then I switched the settings.php back 
to default point system and still experienced error.

Will update after fresh RC2 install. Thanks

Original comment by dahma...@gmail.com on 14 Jun 2011 at 11:43

GoogleCodeExporter commented 9 years ago 
HUZZAH! Huge Success! http://grays.sytes.net/sobb/

Fresh install of RC2, only adjusted settings.php for database info. Still using 
default points ranking and settings_1.php.

Thank you everyone for working on this, you are incredible people.

One last question: if I want to now use my custom points ranking, do I simply 
change the settings.php file and then syncAll()? Even with the match submitted, 
it will correct itself?

Thanks again.

Original comment by dahma...@gmail.com on 15 Jun 2011 at 12:10

GoogleCodeExporter commented 9 years ago 
Great. 
Please let me know if you re-experience this - especially if it's due to your 
custom points def.

You simply define it in settings.php, and then modify your tournament under the 
admin menu so that the tours uses your new ranking system. In RC2 modifying the 
tour by the admin menu makes the appropriate syncs automatically.

Closing this.

Original comment by Nimda...@gmail.com on 15 Jun 2011 at 1:01