PDA

View Full Version : 65,000 player tournament not supported



itdoesntwork
07-20-2009, 02:02 AM
I was trying to update details for the PokerStars Guinness World Record attempt that I played in today. It had 65000 players. However, trying to save that data gave a popup box "The following error occurred: ERROR: 22003: Smallint out of range". I had to pretend the field size was 32000.

netsrak
07-20-2009, 04:35 AM
Which HM Version?
Did you try a manual update or importing summaries?

SteveCut
07-20-2009, 07:56 AM
Netsrak, that's not the point. The problem is that the database field that is used to store tournament size is of too small a type. The type is "SMALLINT" and needs to be changed to "INT". It is a software bug as you did not envisage such large fields.

fozzy71
07-20-2009, 08:17 AM
Can you please zip and email the hand histories to support@holdemmanager.net with a link to this thread.

Kaizen2000
07-20-2009, 08:24 AM
Thats not a question of HH or vers#. You use 'SMALLINT' for your database, which means 2byte=16bit integer data = -32768 to 32767

netsrak
07-20-2009, 08:28 AM
Why can't you just answer the questions and let us decide whether it matters or not. But anyway i'll forward it to Roy.

SteveCut
07-20-2009, 09:07 AM
Why can't you just answer the questions and let us decide whether it matters or not. But anyway i'll forward it to Roy.
Today 03:24 PM

Because, as a support person, you made a standard response, which is fair enough, if you're not a techy.

But to anyone with a little programming knowledge the reason for the error is blatantly obvious (very dangerous assumption btw :) ), so why should we waste everyone's time responding to what we, with our specialist knowledge, can see is a pointless request?

We were actually trying to help.

netsrak
07-20-2009, 09:51 AM
I was already aware of it but i wanted to clearify the situation.

But never mind thanks for the info. ;)

LostCause
07-20-2009, 02:26 PM
I had a similar issue with Full Tilt's Record Breaker tourney. 50,000 entrants.

Here is the text from the error log:

C:\Poker\FullTilt\HandHistory\xxxxxxx\FT20090719 The Record Breaker - (99219444) - Summary.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Contents of Summary.txt

Full Tilt Poker Tournament Summary The Record Breaker (99219444) Hold'em No Limit
Buy-In: $5 + $0
Buy-In Chips: 1555
50000 Entries
Total Prize Pool: $500,000
Tournament started: 2009/07/19 15:20:15 ET
Tournament is still in progress

pmania
07-20-2009, 07:14 PM
I played both too and itm :)
HMimport is stuck, slowin the computer down.
What's the best way, move the 2 hand histories temporarily ?

famke7
07-20-2009, 07:37 PM
I played both too and itm :)
HMimport is stuck, slowin the computer down.
What's the best way, move the 2 hand histories temporarily ?

thanks! you fixed my problem with my HMimport. it was at 95% too, wasn't sure what the problem was. i had played in that FT 50k tourney, and it was still in my FT import folder. i moved the "record breaker" hand history file from c:\program files\full tilt pokier\handhistory to my desktop, and HMimport started working again. please fix this issue! i really want to add the results to my total.

pmania
07-20-2009, 07:44 PM
Yes it was only the summary file from Full Tilt they were still playing, the pokerstars tournament did get imported but not good.

Rvg72
07-21-2009, 01:46 PM
In Postgresql you could do this:

ALTER TABLE tourneydata ALTER COLUMN tourneysize TYPE int;

I'll change the data type within HM as well for new DB's that are created
Roy