Introducing Pind: A Pinball Daemon

[freezy]

Table download is fixed - sorry about that.

For PinemHi I'd need a log, can't reproduce here.

Cheers!

[viriiguy]

Cool Thanks! I will check it out in a bit.. And get you a log.

[viriiguy]

Here is the error from PinemHi itself....

Description:
 Stopped working

Problem signature:
 Problem Event Name:	CLR20r3
 Problem Signature 01:	pinemhi.exe
 Problem Signature 02:	1.0.0.0
 Problem Signature 03:	5155d141
 Problem Signature 04:	Microsoft.VisualBasic
 Problem Signature 05:	8.0.0.0
 Problem Signature 06:	4ca2d138
 Problem Signature 07:	359
 Problem Signature 08:	52
 Problem Signature 09:	System.InvalidCastException
 OS Version:	6.1.7601.2.1.0.256.1
 Locale ID:	1033

Read our privacy statement online:
 http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
 C:\Windows\system32\en-US\erofflps.txt

Here is the last several screens from the console. The App keeps running, but never let's go of the High score update routine. I have to kill it and close the web browser, in order to make it stop.

info: [hiscore] [tmnt_104] Fetched, checking..
info: [announce] "console": {"msg":"Reading high scores from \"tmnt_104\" (Teena
ge Mutant Ninja Turtles)","timeout":5000}
? event:channels:[admin] console
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='champ' AND `hiscores`.`t
ableId`=345 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`points`,`player`,`createdAt`,`upda
tedAt`,`userId`,`tableId`) VALUES ('champ','11000000',5,'JEK','2013-09-17 23:13:
45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=152
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=345 AND `hiscores`.`rank`=1 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','10000000',1,4,'R+N','2013-0
9-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=153
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=345 AND `hiscores`.`rank`=2 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','9000000',2,3,'KVD','2013-09
-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=154
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=345 AND `hiscores`.`rank`=3 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','8000000',3,2,'BLS','2013-09
-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=155
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=345 AND `hiscores`.`rank`=4 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','7000000',4,1,'NBW','2013-09
-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=156
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=345 AND `hiscores`.`rank`=5 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','6000000',5,0,'P G','2013-09
-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=157
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='special' AND `hiscores`.
`tableId`=345 AND `hiscores`.`title`='Loop Record' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`points`,`title`,`player`,`createdA
t`,`updatedAt`,`userId`,`tableId`) VALUES ('special','7',2,'Loop Record','CHP','
2013-09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=345,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=158
info: [hiscore] [teedoff3] Fetched, checking..
info: [hiscore] [teedoff3] Matched high score 5: RJW (160698970)
info: [announce] "console": {"msg":"Reading high scores from \"teedoff3\" (Tee'd
Off)","timeout":5000}
? event:channels:[admin] console
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='champ' AND `hiscores`.`t
ableId`=340 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`points`,`player`,`createdAt`,`upda
tedAt`,`userId`,`tableId`) VALUES ('champ','320000000',5,'OEX','2013-09-17 23:13
:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=340,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=159
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=340 AND `hiscores`.`rank`='2' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','280000000','2',3,'DOW','201
3-09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=340,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=160
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=340 AND `hiscores`.`rank`='3' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','240000000','3',2,'NEY','201
3-09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=340,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=161
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=340 AND `hiscores`.`rank`='4' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','200000000','4',1,'SPX','201
3-09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=340,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=162
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=340 AND `hiscores`.`rank`='5' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','160698970','5',0,'RJW','201
3-09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=340,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=163
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `userId`=1,`updatedAt`='2013-09-17 23:13:45' WHERE `
id`=163
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='special' AND `hiscores`.
`tableId`=340 AND `hiscores`.`title`='The Most Holes-In-One' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`points`,`title`,`player`,`createdA
t`,`updatedAt`,`userId`,`tableId`) VALUES ('special','10',2,'The Most Holes-In-O
ne','CEN','2013-09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=340,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=164
info: [hiscore] [taxi_l4] Fetched, checking..
info: [announce] "console": {"msg":"Reading high scores from \"taxi_l4\" (Taxi)"
,"timeout":5000}
? event:channels:[admin] console
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=339 AND `hiscores`.`rank`='1' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','4500000','1',4,'SJO','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=339,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=165
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=339 AND `hiscores`.`rank`='2' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','4000000','2',3,'DLB','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=339,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=166
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=339 AND `hiscores`.`rank`='3' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','3500000','3',2,'LED','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=339,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=167
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=339 AND `hiscores`.`rank`='4' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','3000000','4',1,'P J','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=339,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=168
info: [hiscore] [totan_14] Fetched, checking..
info: [announce] "console": {"msg":"Reading high scores from \"totan_14\" (Tales
of the Arabian Nights)","timeout":5000}
? event:channels:[admin] console
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='champ' AND `hiscores`.`t
ableId`=357 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`points`,`player`,`createdAt`,`upda
tedAt`,`userId`,`tableId`) VALUES ('champ','9250000',5,'KOZ','2013-09-17 23:13:4
5','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=357,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=169
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=357 AND `hiscores`.`rank`='1' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','9000000','1',4,'POP','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=357,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=170
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=357 AND `hiscores`.`rank`='2' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','8750000','2',3,'MAX','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=357,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=171
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=357 AND `hiscores`.`rank`='3' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','8500000','3',2,'SKA','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=357,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=172
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=357 AND `hiscores`.`rank`='4' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','8000000','4',1,'ZAB','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=357,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=173
info: [hiscore] [tftc_303] Fetched, checking..
info: [announce] "console": {"msg":"Reading high scores from \"tftc_303\" (Tales
from the Crypt)","timeout":5000}
? event:channels:[admin] console
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='champ' AND `hiscores`.`t
ableId`=338 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`points`,`player`,`createdAt`,`upda
tedAt`,`userId`,`tableId`) VALUES ('champ','500000000',5,'J B','2013-09-17 23:13
:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=338,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=174
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=338 AND `hiscores`.`rank`=1 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','450000000',1,4,'KVD','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=338,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=175
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=338 AND `hiscores`.`rank`=2 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','400000000',2,3,'K A','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=338,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=176
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=338 AND `hiscores`.`rank`=3 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','350000000',3,2,'JWC','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=338,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=177
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=338 AND `hiscores`.`rank`=4 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','300000000',4,1,'J L','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=338,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=178
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=338 AND `hiscores`.`rank`=5 LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','281209640',5,0,'TAM','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=338,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=179
info: [hiscore] [swrds_l2] Fetched, checking..
info: [announce] "console": {"msg":"Reading high scores from \"swrds_l2\" (Sword
s of Fury)","timeout":5000}
? event:channels:[admin] console
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=337 AND `hiscores`.`rank`='1' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','5000000','1',4,'AMK','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=337,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=180
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=337 AND `hiscores`.`rank`='2' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','4500000','2',3,'DKL','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=337,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=181
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=337 AND `hiscores`.`rank`='3' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','4000000','3',2,'DTW','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=337,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=182
info: SELECT * FROM `hiscores` WHERE `hiscores`.`type`='hiscore' AND `hiscores`.
`tableId`=337 AND `hiscores`.`rank`='4' LIMIT 1;
info: INSERT INTO `hiscores` (`type`,`score`,`rank`,`points`,`player`,`createdAt
`,`updatedAt`,`userId`,`tableId`) VALUES ('hiscore','3500000','4',1,'BLS','2013-
09-17 23:13:45','2013-09-17 23:13:45',NULL,NULL);
info: PRAGMA foreign_keys = ON;
info: UPDATE `hiscores` SET `tableId`=337,`updatedAt`='2013-09-17 23:13:45' WHER
E `id`=183
error: [hiscore]  killed=false, code=-532459699, signal=null

[viriiguy]

Download is still not working either. If I tell it just to download the table. It does. But if I tell it to add it to Hyperpin and/or get the extra files.. It crashes.

Here is my latest error.

info: [announce] "transfer.transferUpdated": {"id":7}
? event:channels:[admin] transfer.transferUpdated
info: [transfer] Starting post processing of transfer "Bronco Buster rev3.0 FS B
2S (flippered version)".
info: SELECT * FROM `vpf_files` WHERE `vpf_files`.`id`=95 LIMIT 1;
warn: [transfer] Unable to retrieve extracted file from result: {"extract":{},"s
kip":{},"ignore":[]}
info: [transfer] Got verified original game, continuing.
info: [transfer] Matching table in HyperPin by source reference ID 95.
info: SELECT * FROM `tables` WHERE `tables`.`ref_src`=95 LIMIT 1;
info: PRAGMA foreign_keys = ON;
info: UPDATE `tables` SET `id`=389,`key`='oxa',`name`='Bronco Buster rev3.0',`ty
pe`='OG',`edition`='standard',`platform`='VP',`hpid`='Bronco Buster rev3.0 (unde
fined undefined)',`hpenabled`=0,`ref_src`=95,`table_file`=0,`rom_file`=0,`media_
table`=0,`media_backglass`=0,`media_wheel`=0,`media_video`=0,`enabled`=0,`create
dAt`='2013-09-18 00:03:02',`updatedAt`='2013-09-18 00:03:50' WHERE `id`=389
info: PRAGMA foreign_keys = ON;
info: UPDATE `tables` SET `id`=389,`key`='oxa',`name`='Bronco Buster rev3.0',`ty
pe`='OG',`edition`='standard',`platform`='VP',`hpid`='Bronco Buster rev3.0 (unde
fined undefined)',`hpenabled`=1,`ref_src`=95,`table_file`=0,`rom_file`=0,`media_
table`=0,`media_backglass`=0,`media_wheel`=0,`media_video`=0,`enabled`=1,`create
dAt`='2013-09-18 00:03:02',`updatedAt`='2013-09-18 00:03:50' WHERE `id`=389
info: SELECT t.*, v.fileId FROM tables t LEFT JOIN vpf_files v ON t.ref_src = v.
id WHERE platform = "VP" ORDER by t.name ASC
info: ? rpc:34 transfer.all
info: SELECT *, 1 AS s, failedAt as sAsc, 1 as sDesc FROM transfers WHERE failed
At IS NOT NULL UNION SELECT *, 2 AS s, startedAt as sAsc, 1 as sDesc FROM transf
ers WHERE startedAt IS NOT NULL AND completedAt IS NULL AND failedAt IS NULL UNI
ON SELECT *, 3 AS s, sort as sAsc, 1 as sDesc FROM transfers WHERE startedAt IS
NULL AND completedAt IS NULL AND failedAt IS NULL UNION SELECT *, 4 AS s, 1 as s
Asc, completedAt as sDesc FROM transfers WHERE completedAt IS NOT NULL ORDER BY
s ASC, sAsc ASC, sDesc DESC LIMIT 10 OFFSET 0
error: =========================================================================
=======
error: Error: Bad Parameter
   at Error (unknown source)
   at strval (c:\Games\node-pind\node_modules\xml-writer\lib\xml-writer.js:12:1
4)
   at Object.XMLWriter.text (c:\Games\node-pind\node_modules\xml-writer\lib\xml
-writer.js:234:19)
   at Object.XMLWriter.writeAttribute (c:\Games\node-pind\node_modules\xml-writ
er\lib\xml-writer.js:180:42)
   at HyperPin.writeTables (c:\Games\node-pind\server\modules\hyperpin.js:280:1
1)
   at EventEmitter.emit (events.js:96:17)
   at module.exports.onSuccess (c:\Games\node-pind\node_modules\sequelize\lib\d
ialects\sqlite\query.js:144:10)
   at Statement.module.exports.Query.run.database.serialize.executeSql (c:\Game
s\node-pind\node_modules\sequelize\lib\dialects\sqlite\query.js:39:55)
--> in Database#all('SELECT t.*, v.fileId FROM tables t LEFT JOIN vpf_files v ON
t.ref_src = v.id WHERE platform = "VP" ORDER by t.name ASC', [Function])
   at module.exports.Query.run.database.serialize.executeSql (c:\Games\node-pin
d\node_modules\sequelize\lib\dialects\sqlite\query.js:35:52)
   at Statement.module.exports.Query.run (c:\Games\node-pind\node_modules\seque
lize\lib\dialects\sqlite\query.js:54:13)
error: =========================================================================
=======
info: Bye bye, cruel world.
info: SELECT count(*) as `count` FROM `transfers`;
info: [db] [transfer] Returning 1 rows from a total of 1.
info: ? rpc:34 transfer.all (33ms)

c:\Games\node-pind>

[freezy]

Hmm that all seems to work on the 3 platforms I have here, so I'll have a try with node 0.8 later.

[freezy]

Alright, the first error you've posted is PINemHi crashing. This is probably due to some unexpected .nvram format. Node hanging was due to a missing callback, that's fixed now.

The last error posted however is difficult to debug since it's happening in the XML writer module that is not mine. Would it be possible to post or PM me your Visual Pinball.xml file?

[viriiguy]

Sure thing I will PM it to you.

[freezy]

Thanks!

Did you configure your unrar binary correctly? I suspect that the value at pind.unrar points to a non-existing file. I'll add a config checker soon.

Fixed the crash though, if you update.

Cheers!

[viriiguy]

I thought I did. But maybe not. And thanks ! I'll try it when I get home.

[viriiguy]

Ok We are closer.. But it still crashes.

It made it thru a download of a table.. But it was mismatched data. I was downloading Bronco Buster and it got that table and Boe Buster's rom and media.

Then later I told it to download missing Media.. and it crashes everytime.

At`='2013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:50' WHERE `id`=21
info: [transfer] [vpf] Updating database with new filename "Big Daddy HPMP.zip"
for id 21.
info: [transfer] [vpf] Updating database with new filename "Big Daddy HPMP.zip"
for id 21.
info: [transfer] [vpf] Updating size of transfer 21 to 6355403.
info: [announce] "transfer.transferSizeKnown": {"id":21,"size":"6355403","displa
ySize":"6.4M"}
? event:channels:[admin] transfer.transferSizeKnown
info: [transfer] [vpf] Updating size of transfer 21 to 6355403.
info: [announce] "transfer.transferSizeKnown": {"id":21,"size":"6355403","displa
ySize":"6.4M"}
? event:channels:[admin] transfer.transferSizeKnown
info: [transfer] [vpf] Updating size of transfer 21 to 6355403.
info: [announce] "transfer.transferSizeKnown": {"id":21,"size":"6355403","displa
ySize":"6.4M"}
? event:channels:[admin] transfer.transferSizeKnown
info: PRAGMA foreign_keys = ON;
info: PRAGMA foreign_keys = ON;
info: PRAGMA foreign_keys = ON;
info: PRAGMA foreign_keys = ON;
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`filename`='Big Daddy HPMP.zip',`url`='http://www.vpforums.org/index.ph
p?app=downloads&showfile=7150',`type`='mediapack',`engine`='vpf',`ref_src`=765,`
postAction`='{}',`startedAt`='2013-09-19 22:08:46',`sort`=1379628526551,`created
At`='2013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:50' WHERE `id`=21
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`filename`='Big Daddy HPMP.zip',`url`='http://www.vpforums.org/index.ph
p?app=downloads&showfile=7150',`type`='mediapack',`engine`='vpf',`ref_src`=765,`
postAction`='{}',`startedAt`='2013-09-19 22:08:46',`sort`=1379628526551,`created
At`='2013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:50' WHERE `id`=21
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7150',`
type`='mediapack',`engine`='vpf',`ref_src`=765,`postAction`='{}',`size`='6355403
',`startedAt`='2013-09-19 22:08:46',`sort`=1379628526551,`createdAt`='2013-09-19
22:08:46',`updatedAt`='2013-09-19 22:08:50' WHERE `id`=21
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7150',`
type`='mediapack',`engine`='vpf',`ref_src`=765,`postAction`='{}',`size`='6355403
',`startedAt`='2013-09-19 22:08:46',`sort`=1379628526551,`createdAt`='2013-09-19
22:08:46',`updatedAt`='2013-09-19 22:08:50' WHERE `id`=21
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7150',`
type`='mediapack',`engine`='vpf',`ref_src`=765,`postAction`='{}',`size`='6355403
',`startedAt`='2013-09-19 22:08:46',`sort`=1379628526551,`createdAt`='2013-09-19
22:08:46',`updatedAt`='2013-09-19 22:08:50' WHERE `id`=21
info: [announce] "console": {"msg":"VPF: Downloading \"Stars HPMP.zip\"","timeou
t":300000}
? event:channels:[admin] console
info: [vpf] Downloading Stars HPMP.zip at http://www.vpforums.org/index.php?app=
downloads&module=display&section=download&do=do_download&hash=72e03f1381d3cc8b3c
2b8f85699ccd29&id=14795...
info: [announce] "transfer.transferProgress": {"id":21,"totalSize":"6355403","do
wnloadedSize":2846392}
? event:channels:[admin] transfer.transferProgress
info: [announce] "transfer.transferProgress": {"id":22,"totalSize":"5841009","do
wnloadedSize":2957356}
? event:channels:[admin] transfer.transferProgress
info: [announce] "console": {"msg":"VPF: 5841009 bytes downloaded.","timeout":20
00}
? event:channels:[admin] console
info: [vpf] Downloaded 5841009 bytes to C:/temp/Stars HPMP.zip.
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=22,`title`='Stars (Stern 1978) [HP MEDIA PACK]
',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7163',`type`='
mediapack',`engine`='vpf',`ref_src`=878,`postAction`='{}',`size`=5841009,`starte
dAt`='2013-09-19 22:08:46',`completedAt`='2013-09-19 22:08:55',`result`='{"downl
oaded":"C:/temp/Stars HPMP.zip"}',`sort`=1379628526612,`createdAt`='2013-09-19 2
2:08:46',`updatedAt`='2013-09-19 22:08:55' WHERE `id`=22
info: [announce] "transfer.transferUpdated": {"id":22}
? event:channels:[admin] transfer.transferUpdated
info: [extract] Got 24 entries, preparing extraction...
info: [extract] "C:/HyperPin/Media/HyperPin/Flyer Images/Front/Stars (Stern 1978
).jpg" already exists, skipping.
info: [extract] "C:/HyperPin/Media/HyperPin/Instruction Cards/Stars (Stern 1978)
.swf" already exists, skipping.
info: [extract] "C:/HyperPin/Media/Visual Pinball/Backglass Images/Stars (Stern
1978).png" already exists, skipping.
info: [extract] "C:/HyperPin/Media/Visual Pinball/Table Images/Stars (Stern 1978
).png" already exists, skipping.
info: [extract] "C:/HyperPin/Media/Visual Pinball/Wheel Images/Stars (Stern 1978
).png" already exists, skipping.
warn: [extract] Unknown HyperPin file(1): "HyperPin/UltraVP/Stars (Stern 1978).u
vp"
info: [extract] [unzip] Skipping "HyperPin/".
info: [extract] [unzip] Skipping "HyperPin/Media/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Back/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Front/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Front/Sta
rs (Stern 1978).jpg".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside1/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside2/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside3/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside4/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside5/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside6/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Instruction Cards/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Instruction Cards/Star
s (Stern 1978).swf".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Backglass Images
/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Backglass Images
/Stars (Stern 1978).png".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Table Images/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Table Images/Sta
rs (Stern 1978).png".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Wheel Images/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Wheel Images/Sta
rs (Stern 1978).png".
info: [extract] [unzip] Skipping "HyperPin/UltraVP/".
info: [extract] [unzip] Skipping "HyperPin/UltraVP/Stars (Stern 1978).uvp".
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=22,`title`='Stars (Stern 1978) [HP MEDIA PACK]
',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7163',`type`='
mediapack',`engine`='vpf',`ref_src`=878,`postAction`='{}',`size`=5841009,`starte
dAt`='2013-09-19 22:08:46',`completedAt`='2013-09-19 22:08:55',`result`='{"extra
ct":{},"skip":{"HyperPin/Media/HyperPin/Flyer Images/Front/Stars (Stern 1978).jp
g":{"src":"HyperPin/Media/HyperPin/Flyer Images/Front/Stars (Stern 1978).jpg","d
st":"C:/HyperPin/Media/HyperPin/Flyer Images/Front/Stars (Stern 1978).jpg"},"Hyp
erPin/Media/HyperPin/Instruction Cards/Stars (Stern 1978).swf":{"src":"HyperPin/
Media/HyperPin/Instruction Cards/Stars (Stern 1978).swf","dst":"C:/HyperPin/Medi
a/HyperPin/Instruction Cards/Stars (Stern 1978).swf"},"HyperPin/Media/Visual Pin
ball/Backglass Images/Stars (Stern 1978).png":{"src":"HyperPin/Media/Visual Pinb
all/Backglass Images/Stars (Stern 1978).png","dst":"C:/HyperPin/Media/Visual Pin
ball/Backglass Images/Stars (Stern 1978).png"},"HyperPin/Media/Visual Pinball/Ta
ble Images/Stars (Stern 1978).png":{"src":"HyperPin/Media/Visual Pinball/Table I
mages/Stars (Stern 1978).png","dst":"C:/HyperPin/Media/Visual Pinball/Table Imag
es/Stars (Stern 1978).png"},"HyperPin/Media/Visual Pinball/Wheel Images/Stars (S
tern 1978).png":{"src":"HyperPin/Media/Visual Pinball/Wheel Images/Stars (Stern
1978).png","dst":"C:/HyperPin/Media/Visual Pinball/Wheel Images/Stars (Stern 197
8).png"}},"ignore":["HyperPin/UltraVP/Stars (Stern 1978).uvp"]}',`sort`=13796285
26612,`createdAt`='2013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:56' WHERE
`id`=22
info: [announce] "transfer.transferUpdated": {"id":22}
? event:channels:[admin] transfer.transferUpdated
info: [transfer] Starting post processing of transfer "Stars (Stern 1978) [HP ME
DIA PACK]".
info: [transfer] Next download is ready, starting.
info: SELECT * FROM `transfers` WHERE startedAt IS NULL ORDER BY sort ASC;
info: [transfer] [vpf] Starting download of http://www.vpforums.org/index.php?ap
p=downloads&showfile=6579
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=23,`title`='Centigrade 37 (Gottlieb 1977) [HP
MEDIA PACK]',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=657
9',`type`='mediapack',`engine`='vpf',`ref_src`=905,`postAction`='{}',`startedAt`
='2013-09-19 22:08:56',`sort`=1379628526682,`createdAt`='2013-09-19 22:08:46',`u
pdatedAt`='2013-09-19 22:08:56' WHERE `id`=23
info: [announce] "statusUpdated": undefined
? event:channels:[admin] statusUpdated
info: [announce] "console": {"msg":"VPF: Initializing download ","timeout":60000
}
? event:channels:[admin] console
info: ? rpc:19 pind.status
info: SELECT count(*) as `count` FROM `tables`;
info: SELECT * FROM `users` WHERE `users`.`user`='rjw' LIMIT 1;
info: ? rpc:19 pind.status (4ms)
info: [announce] "console": {"msg":"VPF: 6355403 bytes downloaded.","timeout":20
00}
? event:channels:[admin] console
info: [vpf] Downloaded 6355403 bytes to C:/temp/Big Daddy HPMP.zip.
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7150',`
type`='mediapack',`engine`='vpf',`ref_src`=765,`postAction`='{}',`size`=6355403,
`startedAt`='2013-09-19 22:08:46',`completedAt`='2013-09-19 22:08:56',`result`='
{"downloaded":"C:/temp/Big Daddy HPMP.zip"}',`sort`=1379628526551,`createdAt`='2
013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:56' WHERE `id`=21
info: [announce] "transfer.transferUpdated": {"id":21}
? event:channels:[admin] transfer.transferUpdated
info: [extract] Got 23 entries, preparing extraction...
info: [extract] "C:/HyperPin/Media/HyperPin/Flyer Images/Front/Big Daddy (Willia
ms 1963).jpg" already exists, skipping.
info: [extract] "C:/HyperPin/Media/HyperPin/Instruction Cards/Big Daddy (William
s 1963).swf" already exists, skipping.
info: [extract] "C:/HyperPin/Media/Visual Pinball/Backglass Images/Big Daddy (Wi
lliams 1963).png" already exists, skipping.
info: [extract] "C:/HyperPin/Media/Visual Pinball/Table Images/Big Daddy (Willia
ms 1963).png" already exists, skipping.
info: [extract] "C:/HyperPin/Media/Visual Pinball/Wheel Images/Big Daddy (Willia
ms 1963).png" already exists, skipping.
info: [extract] [unzip] Skipping "HyperPin/".
info: [extract] [unzip] Skipping "HyperPin/Media/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Back/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Front/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Front/Big
Daddy (Williams 1963).jpg".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside1/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside2/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside3/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside4/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside5/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Flyer Images/Inside6/"
.
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Instruction Cards/".
info: [extract] [unzip] Skipping "HyperPin/Media/HyperPin/Instruction Cards/Big
Daddy (Williams 1963).swf".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Backglass Images
/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Backglass Images
/Big Daddy (Williams 1963).png".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Table Images/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Table Images/Big
Daddy (Williams 1963).png".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Wheel Images/".
info: [extract] [unzip] Skipping "HyperPin/Media/Visual Pinball/Wheel Images/Big
Daddy (Williams 1963).png".
info: [extract] [unzip] Skipping "HyperPin/UltraVP/".
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=21,`title`='Big Daddy (Williams 1963) [HP MEDI
A PACK]',`url`='http://www.vpforums.org/index.php?app=downloads&showfile=7150',`
type`='mediapack',`engine`='vpf',`ref_src`=765,`postAction`='{}',`size`=6355403,
`startedAt`='2013-09-19 22:08:46',`completedAt`='2013-09-19 22:08:56',`result`='
{"extract":{},"skip":{"HyperPin/Media/HyperPin/Flyer Images/Front/Big Daddy (Wil
liams 1963).jpg":{"src":"HyperPin/Media/HyperPin/Flyer Images/Front/Big Daddy (W
illiams 1963).jpg","dst":"C:/HyperPin/Media/HyperPin/Flyer Images/Front/Big Dadd
y (Williams 1963).jpg"},"HyperPin/Media/HyperPin/Instruction Cards/Big Daddy (Wi
lliams 1963).swf":{"src":"HyperPin/Media/HyperPin/Instruction Cards/Big Daddy (W
illiams 1963).swf","dst":"C:/HyperPin/Media/HyperPin/Instruction Cards/Big Daddy
(Williams 1963).swf"},"HyperPin/Media/Visual Pinball/Backglass Images/Big Daddy
(Williams 1963).png":{"src":"HyperPin/Media/Visual Pinball/Backglass Images/Big
Daddy (Williams 1963).png","dst":"C:/HyperPin/Media/Visual Pinball/Backglass Im
ages/Big Daddy (Williams 1963).png"},"HyperPin/Media/Visual Pinball/Table Images
/Big Daddy (Williams 1963).png":{"src":"HyperPin/Media/Visual Pinball/Table Imag
es/Big Daddy (Williams 1963).png","dst":"C:/HyperPin/Media/Visual Pinball/Table
Images/Big Daddy (Williams 1963).png"},"HyperPin/Media/Visual Pinball/Wheel Imag
es/Big Daddy (Williams 1963).png":{"src":"HyperPin/Media/Visual Pinball/Wheel Im
ages/Big Daddy (Williams 1963).png","dst":"C:/HyperPin/Media/Visual Pinball/Whee
l Images/Big Daddy (Williams 1963).png"}},"ignore":[]}',`sort`=1379628526551,`cr
eatedAt`='2013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:56' WHERE `id`=21
info: [announce] "transfer.transferUpdated": {"id":21}
? event:channels:[admin] transfer.transferUpdated
info: [transfer] Starting post processing of transfer "Big Daddy (Williams 1963)
[HP MEDIA PACK]".
info: [transfer] Next download is ready, starting.
info: SELECT * FROM `transfers` WHERE startedAt IS NULL ORDER BY sort ASC;
info: [transfer] [vpf] Starting download of http://www.vpforums.org/index.php?ap
p=downloads&showfile=6887
info: PRAGMA foreign_keys = ON;
info: UPDATE `transfers` SET `id`=24,`title`='Corvette FS',`url`='http://www.vpf
orums.org/index.php?app=downloads&showfile=6887',`type`='mediapack',`engine`='vp
f',`ref_src`=920,`postAction`='{}',`startedAt`='2013-09-19 22:08:56',`sort`=1379
628526723,`createdAt`='2013-09-19 22:08:46',`updatedAt`='2013-09-19 22:08:56' WH
ERE `id`=24
info: [announce] "statusUpdated": undefined
? event:channels:[admin] statusUpdated
info: [announce] "console": {"msg":"VPF: Initializing download ","timeout":60000
}
? event:channels:[admin] console
info: ? rpc:20 pind.status
info: SELECT count(*) as `count` FROM `tables`;
info: SELECT * FROM `users` WHERE `users`.`user`='rjw' LIMIT 1;
info: ? rpc:20 pind.status (4ms)
info: [vpf] Updating description for download 905
info: SELECT * FROM `vpf_files` WHERE `vpf_files`.`id`=905 LIMIT 1;
error: =========================================================================
=======
error: TypeError: Expected a String
   at Object.exports.decode (c:\Games\node-pind\node_modules\ent\index.js:36:15
)
   at VPForums.download.jsdom.env.done (c:\Games\node-pind\server\modules\vpfor
ums.js:486:48)
   at EventEmitter.emit (events.js:96:17)
   at module.exports.QueryInterface.queryAndEmit (c:\Games\node-pind\node_modul
es\sequelize\lib\query-interface.js:698:17)
   at EventEmitter.emit (events.js:96:17)
   at module.exports.onSuccess (c:\Games\node-pind\node_modules\sequelize\lib\d
ialects\sqlite\query.js:144:10)
   at Statement.module.exports.Query.run.database.serialize.executeSql (c:\Game
s\node-pind\node_modules\sequelize\lib\dialects\sqlite\query.js:39:55)
--> in Database#all('SELECT * FROM `vpf_files` WHERE `vpf_files`.`id`=905 LIMIT
1;', [Function])
   at module.exports.Query.run.database.serialize.executeSql (c:\Games\node-pin
d\node_modules\sequelize\lib\dialects\sqlite\query.js:35:52)
   at Statement.module.exports.Query.run (c:\Games\node-pind\node_modules\seque
lize\lib\dialects\sqlite\query.js:54:13)
error: =========================================================================
=======
info: Bye bye, cruel world.

c:\Games\node-pind>

Thanks!

[freezy]

More accurate media matching is next on the plan. As mentioned before, if the Bronco Buster media pack is listed under "M" because its title is "Mediapack Bronco Buster", it's hard to find.

I'll probably come up with something similar to the current VPF<-> IPDB matching routine, which seems to be running fine.

For your error I've just committed a fix, although it's just fixing the crash and probably not the cause of the bug. Will investigate this weekend.

Thanks for your patience so far, it's really making Pind more stable.

Cheers!

[freezy]

Committed fix that makes Pind continue searching on first mismatch. Your XML runs now through, viriiguy.

[viriiguy]

You are the man! I will check it out in a little bit!

[viriiguy]

IT seems to work a lot better now. But it still crashes from time to time when I tell it to download missing media. I can at least start it back up and it will keep going now. But it feels like it is spamming itself into oblivion with the downloads.

[MisterB]

I agree, there is still a a fair amount of instability in the media downloads. If I am doing a sync, I wrap the execution of app.js in a batch script wrapper that restarts the process after it dies. I've always been able to get the download in question to work on a subsequent attempt. It's dead simple, if you want it.

[viriiguy]

Thanks. For now I don't need it as I am mostly just testing and not really requiring it to do it's job.. Otherwise I Would make it a service and put it on infinite restart.

Currently I am working on manually changing ALL my tables to use B2S. Man what a load of work!! 120 down... 268 to go!

Keep up the GREAT work Freezy!

[freezy]

Well, there is also prod.js that auto-relaunches on crash.

Spent the week-end on fixing media downloads. Nothing concrete yet, but I now have all VPF media linked to an IPDB number. This will be useful very soon.

@viriiguy: Automatic/batch controller setup is on the plan. You might hang on to that huge manual task, it'll be one click when it's done.

[viriiguy]

Nice!! That would be sweet to have!

[freezy]

Since you seem to more expert on that topic than me, could you create a GitHub issue and put that feature request in there?

Would be interesting to know if you'd like just to be able to set the controller for all tables, or do you want to apply it to a subset based on some filtering rule? Also are there other options you'd like to be able to batch-set? I suppose rotation setting would be interesting too.

[viriiguy]

Sure I can do that later. As for the rotation.. That would really need to be a per table or not at all. Most tables do not need any rotation tweaks for a cabinet. So if you rotated them all... IT would break more than it fixed. But for tables.. With the new Direct Output program that uses B2S for triggering the LEDWiz, ALL tables need to have the controller set to B2S.Server.

[Itchigo]

This is probably easy for you guys, but it looks daunting to me. Can you guys help/walk me through installation?

I have node-v0.10.18-x64 and Git-1.8.4-preview20130916 installed. (Tittles from shortcuts). Stock installation- haven't changed anything.

[freezy]

https://github.com/freezy/node-pind/blob/master/INSTALL.md

[Itchigo]

That's the page I started with. About step 5 is where I lose things. I don't have a great knowledge in this area. I'm also wondering how much benefit there is for me as my setup is 90% done. I have 325 tables, probably need about 25 wheels, many of which don't exist yet. Pinball X will handle all my screenshots, and backglass images via screen capture. Will this notify me of new files uploaded?

[freezy]

You need to be more specific than that. Which step under step 5 would be interesting for instance. What happens, what's written on the console, after doing what exactly.

If it's of any benefit, I can't decide for you. Personally it takes me 10min adding a new table for browsing through VPF, find the table, the media, the roms, the videos, extract everything to the right place, update the XML. In Pind it takes one second for the click, the rest is done automatically.

[Gilrock]

I got this installed and running today. It was fairly easy to follow the instructions. For the Windows SDK I wasn't sure if I needed to check any of the add-on since one of them was SQL related but I just unchecked them all and it worked.

I didn't get the automatic startup method to work. I got the service to install and I see the Pinball Daemon listed in services as started but when I goto localhost I get a 404 error. I can goto c:\Games\node-pind and type "node app" and then refresh the page and it works.

My list of tables doesn't look as nice as what you have on your webpage. Mine is basically the same except the Hyperpin pinball icon beside each file is like 3" in diameter for every file listed.

I get a blank entry at the top of the listing with no name and no associated files and I don't see anything wrong in the XML except maybe my Future Pinball list is empty right now.

Some of my media and tables were renamed using the Hyperpin Manager program so I don't know if I will end up with doubles from my name being a little different. And it doesn't look like I can navigate it to a missing media file.

I use a lot of videos for the backglass...would be nice to have that as an additional media item....as well as B2S server files.

I must say it was kinda scary when you execute "npm install -d". I could swear it looked like hackers were installing a porn server...lol.

Finally....this looks like it was a boatload of work...thanks for all your efforts.