[APP] PinballX Database Manager 24.09.06.0 (supports Touch Play as well)

[johnwillsey]

Hi, for my Pinball X tables I get the message "Table doesn't have a primary key" and the media does not work on the cabinet to the right.

Any ideas?

 

4/21/2020 1:52:08 AM : PinballX Database Manager (Version: 1.4.0.0)
4/21/2020 1:52:08 AM : Diagnostics: Begin system enumeration...
4/21/2020 1:52:08 AM : OS: Microsoft Windows 10 Pro
4/21/2020 1:52:08 AM : Version: 10.0.18362
4/21/2020 1:52:08 AM : Build: 18362
4/21/2020 1:52:08 AM : Total RAM: 8150 MB
4/21/2020 1:52:08 AM : Available RAM: 5020 MB
4/21/2020 1:52:09 AM : CPU: Intel(R) Xeon(R) CPU E5-1660 0 @ 3.30GHz
4/21/2020 1:52:09 AM : Video Card: NVIDIA GeForce RTX 2070
4/21/2020 1:52:09 AM : Video Driver: 26.21.14.4141
4/21/2020 1:52:09 AM : Video RAM: 4095 MB
4/21/2020 1:52:09 AM : Sound Card: USB Audio Device
4/21/2020 1:52:09 AM : Sound Card: High Definition Audio Device
4/21/2020 1:52:09 AM : Sound Card: NVIDIA High Definition Audio
4/21/2020 1:52:09 AM : .NET: .NET Framework 2.0 Installed
4/21/2020 1:52:09 AM : .NET: .NET Framework 4.0 Installed
4/21/2020 1:52:09 AM : Diagnostics: System enumeration completed successfully!
4/21/2020 1:52:09 AM : Initialize Start : ...
4/21/2020 1:52:09 AM : Action Log Update - INFORMATION : Database Manager Log File 	E:\Emulator\Pinball_emu\PinballX\Log\DBManagerLog.txt
4/21/2020 1:52:09 AM : Desktop mode is set to False
4/21/2020 1:52:09 AM : DMD enabled mode is set to True
4/21/2020 1:52:09 AM : RealDMD enabled color mode is set to True
4/21/2020 1:52:09 AM : Topper enabled mode is set to True
4/21/2020 1:52:09 AM : Use Table Loading Media mode is set to True
4/21/2020 1:52:09 AM : EnableSystemsList mode is set to True
4/21/2020 1:52:09 AM : PinballX File matching is enabled. Media results may not match front end.
4/21/2020 1:52:09 AM : Action Log Update - WARNING : File matching is enabled in PinballX. Media results may not match what you see in the front end. Suggested action - Disable File Matching in PinballX
4/21/2020 1:52:09 AM : Found : in [Visual Pinball] file [Visual Pinball.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Pinball FX2] file [Pinball FX2.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Pinball FX3] file [Pinball FX3.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Pinball Arcade] file [Pinball Arcade.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Future Pinball] file [Future Pinball.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [MAME] file [MAME.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Visual Pinball PhysMod5] file [Visual Pinball PhysMod5.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [P-ROC] file [P-ROC.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Visual Pinball X] file [Visual Pinball X.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Bingogameroom3] file [BingoGameroom3.xml] With CustomType : [False]
4/21/2020 1:52:09 AM : Found : in [Future Pinball PinEvent] file [Future Pinball PinEvent.xml] With CustomType : [False]
4/21/2020 1:52:10 AM : Action Log Update - INFORMATION : PinballX version found 	 4.27 
4/21/2020 1:52:13 AM : No backup found for [Future Pinball.xml] 
4/21/2020 1:52:13 AM : XML file [E:\Emulator\Pinball_emu\PinballX\Databases\Future Pinball\Future Pinball.xml] reading duration: 39 ms
4/21/2020 1:52:13 AM : loading directory [E:\Emulator\Pinball emu\Future Pinball\Tables] duration: 12 ms
4/21/2020 1:52:17 AM : User cancelled recovery of file [Visual Pinball X.xml] 
4/21/2020 1:52:17 AM : XML file [E:\Emulator\Pinball_emu\PinballX\Databases\Visual Pinball X\Visual Pinball X.xml] reading duration: 40 ms
4/21/2020 1:52:17 AM : loading directory [E:\Emulator\Pinball emu\Tables] duration: 113 ms
4/21/2020 1:52:18 AM : ERROR: GetDirectoryInformation	Primary Key creation failed For DataTable [E:\Emulator\Pinball_emu\PinballX\Media\Visual Pinball X]
4/21/2020 1:52:18 AM : ERROR: DisplayMediaSummary	Failed for table name [- system -], table desc [SYSTEM LIST MEDIA] : Table doesn't have a primary key.
4/21/2020 1:52:22 AM : ERROR: DisplayMediaSummary	Failed for table name [24 (Stern 2009)], table desc [24 *(Stern 2009)] : Table doesn't have a primary key.
4/21/2020 1:52:23 AM : ERROR: DisplayMediaSummary	Failed for table name [3 Angels], table desc [3 Angels] : Table doesn't have a primary key.
4/21/2020 1:52:23 AM : ERROR: DisplayMediaSummary	Failed for table name [3 Angels], table desc [3 Angels] : Table doesn't have a primary key.
4/21/2020 1:52:24 AM : ERROR: DisplayMediaSummary	Failed for table name [4 Square (Gottlieb 1971)], table desc [4 Square *(Gottlieb 1971)] : Table doesn't have a primary key.
4/21/2020 1:52:24 AM : ERROR: DisplayMediaSummary	Failed for table name [4 Square (Gottlieb 1971)], table desc [4 Square *(Gottlieb 1971)] : Table doesn't have a primary key.
4/21/2020 1:52:24 AM : ERROR: DisplayMediaSummary	Failed for table name [Abra Ca Dabra (Gottlieb 1971)], table desc [Abra Ca Dabra *(Gottlieb 1971)] : Table doesn't have a primary key.
4/21/2020 1:52:24 AM : ERROR: DisplayMediaSummary	Failed for table name [Abra Ca Dabra (Gottlieb 1971)], table desc [Abra Ca Dabra *(Gottlieb 1971)] : Table doesn't have a primary key.
4/21/2020 1:52:26 AM : ERROR: DisplayMediaSummary	Failed for table name [24 (Stern 2009)], table desc [24 *(Stern 2009)] : Table doesn't have a primary key.
4/21/2020 1:52:26 AM : ERROR: DisplayMediaSummary	Failed for table name [24 (Stern 2009)], table desc [24 *(Stern 2009)] : Table doesn't have a primary key.
4/21/2020 1:53:49 AM : ERROR: DisplayMediaSummary	Failed for table name [24 (Stern 2009)], table desc [24 *(Stern 2009)] : Table doesn't have a primary key.
4/21/2020 1:53:49 AM : Bye, hope to see you next time. Scutters & Mike DA Spike

 

[Mike_da_Spike]

@johnwillsey Can you post your database file and your pinballx.ini (as attachment) ?

Properly you have double entries in it, but need to check

[scutters]

@johnwillsey

Please also check if you have any duplicated media in subfolders of your PinballX\Media\Visualk Pinball X\ media folders? (e.g.  PinballX\Media\Visualk Pinball X\Table Videos\Backup\ - where you have the same media in the backup folder as you do in the Table Videos folder). If you do please try moving the Backup (or whatever it's called) folder to another location. 

[johnwillsey]

Not on my machine for the DB files, but I do have the following setup per scutters ask in my Media folder...

Visual Pinball (Folder)

Visual Pinball PM5 (Sym link to Visual Pinball)

Visual Pinball X (Sym link to Visual Pinball)

Since they all share the same artwork and I didn't want triplicates, especially as almost weekly a vp9 table gets converted to vpx.

[scutters]

5 minutes ago, johnwillsey said:

Not on my machine for the DB files, but I do have the following setup per scutters ask in my Media folder...

Visual Pinball (Folder)

Visual Pinball PM5 (Sym link to Visual Pinball)

Visual Pinball X (Sym link to Visual Pinball)

Since they all share the same artwork and I didn't want triplicates, especially as almost weekly a vp9 table gets converted to vpx.

Not tried symbolic links, but off the top of my head they shouldn't be an issue - will test when i get chance.

In the Media\Visual Pinball folder do you have any sub folders below the main media type folders?

[scutters]

@johnwillsey

I played around with media folders and symbolic links.. the only way i  found to duplicate your error was to add files into media\Visual pinball and then create a new folder media\visual pinball\visual pinball and put the same files in it. There might be other ways i haven't found.. anyway, please give the attached a go when you get chance. It won't stop the error, but should give more info in the log / action log area on the cause for you so the files can be cleaned up.

Only the exe attahed in the zip, so just replace the V1.4.0 exe you're using.

 

Edited April 26, 2020 by scutters
attachment removed - changes included in v1.4.3

[johnwillsey]

Hi, thanks for the update.. new log and messages attached..

I removed the media files with the special character found in the logs and that fixed it.  I attached one for reference for you.

Thanks, looking forward to checking the software out!

DBManagerLog.txt

[johnwillsey]

Looking nice... another error that seems odd...  ERROR INFO    :    MediaFileUpdate    Object variable or With block variable not set.

 

[scutters]

2 hours ago, johnwillsey said:

Looking nice... another error that seems odd...  ERROR INFO    :    MediaFileUpdate    Object variable or With block variable not set.

Hi, can you post a new log when that error occurs?

Thanks.

[axeguitar21]

Hello to all,

 

first of all. Thanks for your hard work, i just tried your Database Manager Program and it is really nice to use. However, i have one problem. Adding VP9 tables is flawless, but when i want to add VPX tables, i get the following message:

"XMLComboList_SelectedIndexChanged    Executable [C:\Visual Pinball\VPinballX.exe] for directory [C:\Visual Pinball\Tables] is unknown. Cannot check for new/deleted tables"

Is there a problem, how i setup my tables folder ? Ich have VP9 and VPX tables in the same folder...

[scutters]

11 minutes ago, axeguitar21 said:

Hello to all,

 

first of all. Thanks for your hard work, i just tried your Database Manager Program and it is really nice to use. However, i have one problem. Adding VP9 tables is flawless, but when i want to add VPX tables, i get the following message:

"XMLComboList_SelectedIndexChanged    Executable [C:\Visual Pinball\VPinballX.exe] for directory [C:\Visual Pinball\Tables] is unknown. Cannot check for new/deleted tables"

Is there a problem, how i setup my tables folder ? Ich have VP9 and VPX tables in the same folder...

I think that message may be a warning only, but please attach DBManagerLog.txt from your pinballx\log folder, and your pinballx.ini file from your pinballx\config folder. Thanks.

Also, where is vpinballx.exe located in your setup, are  C:\Visual Pinball\VPinballX.exe and C:\Visual Pinball\Tables paths correct for the exe and the tables folder? 

[axeguitar21]

Wow, Thanks for that quick reply!!! Files attached.

Vpinballx.exe is Located in "C:/Visual Pinball/", so i think both are correct. Works fine, when i launch PinballX Frontend.

 

DBManagerLog.txt PinballX.ini

[scutters]

@axeguitar21

No problem.. I think i see the issue. 

Can you open pinballx settings.exe and under Other Systems for system2 (visual pinball x) remove the path from the Executable entry, so from "C:\Visual Pinball\VPinballX.exe" to "VPinballX.exe"

Let us know if that sorts it out. If it does we'll have a look at the code to see if we can sort it out to work either way by stripping off the path in the app.

[axeguitar21]

19 minutes ago, scutters said:

@axeguitar21

No problem.. I think i see the issue. 

Can you open pinballx settings.exe and under Other Systems for system2 (visual pinball x) remove the path from the Executable entry, so from "C:\Visual Pinball\VPinballX.exe" to "VPinballX.exe"

Let us know if that sorts it out. If it does we'll have a look at the code to see if we can sort it out to work either way by stripping off the path in the app.

That sorted it out, thanks so much!!!

We will be working on our pinball machine today and solder all the buttons and it, i am so excited to play the tables! Have a nice weekend!

[scutters]

Just now, axeguitar21 said:

That sorted it out, thanks so much!!!

We will be working on our pinball machine today and solder all the buttons and it, i am so excited to play the tables! Have a nice weekend!

Thanks for confirming.

Enjoy you pinballing weekend! 

[scutters]

@johnwillsey

Please give this version a go (just the exe again). Hopefully fixes your issue (based on my best guesses without the log). If that does the trick we'll get a patched version out officially. Thanks.

 

Edited April 26, 2020 by scutters
attachment removed - changes included in v1.4.3

[johnwillsey]

Thanks.  The log didn't have anything different than the screenshot.. v1.4.2 does not throw the same error as 1.4.1 was throwing...

Looks like the ftp now works correctly for me. 

Is there any way to do bulk multi-select, or to check all media?

 

Also, I've looked at the docs but keep missing where the mega sites are to configure.  haven't seen them listed anywhere on the forumns/sites I'm on...

 

Thanks for the relentless effort!

 

[Mike_da_Spike]

34 minutes ago, johnwillsey said:

Thanks.  The log didn't have anything different than the screenshot.. v1.4.2 does not throw the same error as 1.4.1 was throwing...

Looks like the ftp now works correctly for me. 

@scutters did a good job !

34 minutes ago, johnwillsey said:

Thanks.  The log didn't Is there any way to do bulk multi-select, or to check all media?

Already on our list is that we are planning  in a future release that we will add a button to recheck all tables and download (missing) media from GameEx FTP

34 minutes ago, johnwillsey said:

Also, I've looked at the docs but keep missing where the mega sites are to configure.  haven't seen them listed anywhere on the forumns/sites I'm on...

The mega links urls you can configure in the settings in the Mega tab. In the documentation I added an test URL.

@scutters provided 2 urls where he had the permission from the owner. (And 2 posts below  @joyrider3774also post some)

Searching on the internet /forums you can find multiple. Wheels, instructions, flyers etc. 

Thanks for my pal Scutters who worked hard on these bugs. Because of covid-19  it is pretty busy at my work and didn't have time this week, but have some days of coming week

[johnwillsey]

Doh.  Thanks. Found em'

 

[Mike_da_Spike]

Thanks to @scutterswho did the bug fixes this week , we just release 1.4.3
Because we only did bugfixes, we upgraded the version with only  patch version 3

Thanks @scutters for your work this week !
 

[Mike_da_Spike]

With the great help of @scutters we released version 1.5
See download section for new features  

[Mike_da_Spike]

Version 1.5.1 uploaded.
Small Bugfix for real DMD users (and added 2 buttons for easy filtering enabled/disabled tables)

[GAH1068]

@Mike_da_Spike - is there a way to determine why the new DB manager warns about the XML being modified outside program.     It appears only to be doing this on my main VPX list and one of my VP9 lists.      I attached them just in case.   Not sure if this is due to a invalid character in a table name or something stupid like that.     List appears to be fine in standard game manager.

 

 

 

Visual Pinball.xml Visual Pinball 9.xml

[johnwillsey]

Wow, fantastic improvements over the past few releases.  Nice work guys!

I have a question or two... I decided to re-record all my DMDs with the cool new feature to bulk record.

Are there any setting adjustments for this?

For instance, some of my stern DMDs are recorded at the full dimension set in my PinballX config.  Some are recorded at what appear to be the same width but with the top/bottom cropped off because it is all Black??  I'm wondering if there is an ffmpeg setting being used that tries to crop black sides/tops.  I checked my regex and the x,y,height,width are identical for ACDC and Avatar, but the recorded height dimensions are totally different. 

I have a full size LCD DMD and my ACDC has black area top/bottom so when played back it looks "normal" but avatar does not so during playback it gets vertically stretched.

If those settings were tweakable somewhere I wanted to experiment.

Thanks again for the great util. 

Oh, I used the obsolete flags to do some cleanup I didn't realize I needed to do and had missed about 15 table updates.  Totally Cool.

Then I did bulk FTP update and got a bunch of missing instructions I didn't know were available.  Fantastic!

 

[johnwillsey]

Advanced filtering to slice/dice is totally awesome.. Request there.. Could the bulk actions be applied to the current filtered list vs all enabled tables?