atatta
03-31-2009, 03:11 PM
I just updated from 1.07 to 1.08 beta 22 and no hands are importing, all new hands are considered duplicates and aren't imported into the database, both from iPoker and FTP, and almost certainly every other site. The same is true of beta 23, which I just tried.
I don't even know whether it's safe to downgrade again after the major database changes in 1.08. I need a fix or workaround quite urgently, as HEM is completely unusable now.
Looking at my postgresql log, there are many instances of 'prepared statement "pkhexecute" does not exist' and a few 'language "plpgsql" does not exist'. Did the database update perhaps fail because it couldn't create a function?
This happens even on a fresh database with any of the hands I've ever played.
After experimenting some more, I've found another error that seems to be the likely one, "there is no parameter $44", but I don't know what the query is so I don't know why this would be.
(Later) The actual statement (one of a series of PREPAREs including PKHExecute) causing the error is:
PREPARE PHTourneyKeyHeroExecute (integer,integer,timestamp without time zone,integer,integer,smallint,smallint,smallint,sm allint,smallint,
integer,integer,smallint,boolean,boolean,smallint, smallint,smallint,smallint,smallint,
smallint,smallint,smallint,smallint,smallint,boole an,boolean,boolean,boolean,smallint,boolean,boolea n,boolean,boolean,smallint,boolean,boolean,boolean ,boolean,smallint,character varying(20),smallint,smallint)
AS INSERT INTO playerhandstourneykeycolumns_hero
VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$1 5,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27, $28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$4 0,$41,$42,$43,$44);
And indeed there are only 43 parameters there. How is this even working for anyone?
The addition of one "int" after the character varying(20) would fix this, and this was done for the non-hero version of this prepared statement. However, I can't fix this myself as the statements are hardcoded into HEM afaics.
I don't even know whether it's safe to downgrade again after the major database changes in 1.08. I need a fix or workaround quite urgently, as HEM is completely unusable now.
Looking at my postgresql log, there are many instances of 'prepared statement "pkhexecute" does not exist' and a few 'language "plpgsql" does not exist'. Did the database update perhaps fail because it couldn't create a function?
This happens even on a fresh database with any of the hands I've ever played.
After experimenting some more, I've found another error that seems to be the likely one, "there is no parameter $44", but I don't know what the query is so I don't know why this would be.
(Later) The actual statement (one of a series of PREPAREs including PKHExecute) causing the error is:
PREPARE PHTourneyKeyHeroExecute (integer,integer,timestamp without time zone,integer,integer,smallint,smallint,smallint,sm allint,smallint,
integer,integer,smallint,boolean,boolean,smallint, smallint,smallint,smallint,smallint,
smallint,smallint,smallint,smallint,smallint,boole an,boolean,boolean,boolean,smallint,boolean,boolea n,boolean,boolean,smallint,boolean,boolean,boolean ,boolean,smallint,character varying(20),smallint,smallint)
AS INSERT INTO playerhandstourneykeycolumns_hero
VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$1 5,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27, $28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$4 0,$41,$42,$43,$44);
And indeed there are only 43 parameters there. How is this even working for anyone?
The addition of one "int" after the character varying(20) would fix this, and this was done for the non-hero version of this prepared statement. However, I can't fix this myself as the statements are hardcoded into HEM afaics.