How "large" is "large," exactly? I'm usually front and center for beta releases but due to a shortage of poker time lately I had been holding off. Now I'm anxious to install 1.10 but the issues I'm seeing with b7 are worrying me.
My DB has ~86K players and ~62K hands (I recently purged old hands, but kept the players). I'd rather avoid a restore from backup or other such time wasters if you guys think my DB is large enough to cause a problem. If beta8 is about to land and it fixes this issue, then I'll keep waiting.
Just hold off until beta 8 tomorrow night which will have this resolved
Roy
Galoper, are you sure you reinstalled Beta 6 properly?
Please check the auto-import settings.
It should work, at least after a reboot.
Another solution would be to stay with beta 7 and make the database changes manually before starting it again.
Start pgadminII, connect to the database and open the query tool.
Run the following commands:
ALTER TABLE gametypes Add Column Currency_ID smallint default 1;
ALTER TABLE bonuses Add Column Currency_ID smallint default 1;
ALTER TABLE playervsplayer Add Column Currency_ID smallint default 1;
ALTER TABLE playervsplayer_hero Add Column Currency_ID smallint default 1;
INSERT into Settings (SettingName,SettingValue) Values ('DefaultCurrency', '1');
ALTER TABLE tourneydata Add Column Currency_ID smallint default 1;
ALTER TABLE tourneyplayerdata Add Column Currency_ID smallint default 1;
CREATE TABLE currency
(
currency_id integer,
currency_name character varying(20),
currency_symbol character varying(4),
current_rate_in_usd numeric (6,4)
)
WITHOUT OIDS;
ALTER TABLE currency OWNER TO postgres;
INSERT INTO Currency Values (1, 'USD', '$', 1.0000);
INSERT INTO Currency Values (2, 'EUR', '', 0.6989);
INSERT INTO Currency Values (3, 'GBP', 'Ģ', 0.6278);
Yes, the software works, but i cant import.
Manual setting donīt work too.
What do you thing. I must wait Beta8 or i must do this manual pgadmin changes?
If i must to modify the database manually, i really apreciate a TeamView session. Now iīm avaiable.
Last edited by Galoper; 01-14-2010 at 10:45 AM.
I am now concerned. My database is pretty large too. 160k players last time I checked and I just tried DLing the 1.10 Beta 7. Twice I tried to skip the Database Update which this release bought and both times the program froze (said not responding). I therefore just agreed to run that databse update and it says it may take "many minutes". Any idea roughly how long this is and if I am still likely to have futher problems?
Now frozen twice at the multi currency support stage.
What do I do?
I am in same boat as other guy. Just want something working ASAP. Already should be playing and this holding me up so would apreciate help ASAP.