I'm getting a bug whenever it attempts to download data for a card starting with AE before the great ligature update.
System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
at Gatherer_Extractor.FenetrePrincipale.Treatment_MAJ(Int32 nbre_tache, BackgroundWorker worker, DoWorkEventArgs e)
at Gatherer_Extractor.FenetrePrincipale.BWkMAJ_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
This is with the latest version, 4.1c, on Windows 10.
I have just uploaded a new release : v4.2.
With the latest gatherer update (Amonkhet), two issues were identified:
-- dual cards were not correctly extracted;
-- cards with alternates (typically basic lands) were not anymore extracted during full extraction.
Those issues are fixed in release 4.2. If you find other bugs, feel free to report. Thanks in advance!
Hi chaudakh! Thanks for all the work that you're doing with your app.
I've downloaded 4.2 but I'm still throwing the same error when trying to update legalities or update scans:
************** Exception Text **************
System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
at Gatherer_Extractor.FenetrePrincipale.Treatment_MAJ(Int32 nbre_tache, BackgroundWorker worker, DoWorkEventArgs e)
at Gatherer_Extractor.FenetrePrincipale.BWkMAJ_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Updating legalities the error appears to be on Abandoned Hope from Tempest. Updating scans it appears on Ahn-Crop Champion.
Thank you chaudakh for this awesome tool! I was just using it and have come across two errors.
1: Gatherer extractor keeps urging to be updated even though it is on the latest update.
2: Exporting the database to one .sql file works. Each statement ends with a semi-colon. When exporting the database as each .sql being a set name, the statements are not separated by a semi-colon. Instead the statements are separated by a comma which causes importing of those statements to a MySQL server to fail.
Hopefully the second error can be fixed so I can finish automating my setup. Until then I will be writing a small pre-interpreter to fix this problem.
Thank you again chaudakh. If you need any help with this project I will be more than happy to be of assistance.
EDIT: I just realized a 3rd problem I am having. When exporting the database as multiple .sql files the rulings does not convert the symbols to their proper notation. For example, in Aether Herder from Aether Revolt, the rulings have "xE2|x80" instead of {E}.
EDIT 2: This seems to only occur sporadically. The non-acii and non-printable icons are not removed from the rulings at what seems to be arbitrary positions when exported as separate .sql files.
Thank you chaudakh for this awesome tool! I was just using it and have come across two errors.
1: Gatherer extractor keeps urging to be updated even though it is on the latest update.
Thought I'd take a look at GE and see what's up and I get the same error as well. Gives me a message that I'm using 4.2 (20/04/2017) and to download 4.2 (29/04/2017). Following that rabbit hole ends up with the same installation file downloaded.
A've just got this error message when downloading the Ninth Edition Set. Could you please look into that? Thanks!
Public member 'endswith' on type 'DBNull' not found.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.MissingMemberException: Public member 'endswith' on type 'DBNull' not found.
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.GetMembers(String& MemberName, Boolean ReportErrors)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Gatherer_Extractor.FenetrePrincipale.Treatment_MAJ(Int32 nbre_tache, BackgroundWorker worker, DoWorkEventArgs e)
at Gatherer_Extractor.FenetrePrincipale.BWkMAJ_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
I've just found out that it does the same for 15th Anniversary set or Anthologies.
@Shinseiten: Without any further description in the errors that are raised during the import into you SQL database, I cannot help you, since I cannot reproduce the bug and I don't know what to track.
Indeed, since the last update of magiccards.info, foreign names raise an error in some specific conditions. Thanks for having reported. This is fixed in release 4.2c.
@Geretenk: Thanks for the report. see answer above for explanation & fix.
@swallowtail23: Those have been added in Amonkhet masterpiece set.
Hi, I'm on version 4.2c and the program stops all activity when it downloads "full data" and reaches the split cards in the new set (first occurrence is Appeal // Authority in HOU). Is this just me? It's halting at these points on two different Win10 systems. Is anyone else having this issue?
There may be some sort of file encoding mismatch between the generated .sql file and what MySQL is expecting, like it's using the first two bytes to figure out what file it's dealing with, which in turn truncates the first statement. I exported a valid .sql file, and you said your file is also correct, so I'm assuming the issue lies within MySQL.
Hi, I'm on version 4.2c and the program stops all activity when it downloads "full data" and reaches the split cards in the new set (first occurrence is Appeal // Authority in HOU). Is this just me? It's halting at these points on two different Win10 systems. Is anyone else having this issue?
Thanks.
This is happening with me as well. Hope it gets fixed soon. Matter of fact, it's doing this with Amonkhet split cards as well where it wasn't in previous versions. I'm not sure what was changed, but it won't allow me to get past Commit // Memory in Amonkhet either.
Just tried on Dragon's Maze cards, since I knew those split cards worked properly with the version I previously had, and it failed on the first split card there (Alive // Well).
I tried with older versions of Extractor (3.22 and 4.1) and both failed on Alive // Well as well. I'm guessing something changed with how the API to the Gatherer site (or magiccards.info) handles split cards that's breaking the program.
Thank you for your bug reports.
When a new set is released on the Gatherer, some slight adjustments & updates are always made on other cards. Wizards permanently changes the way complex cards (flipped cards, dual cards, split cards etc.) are handled, so that it may happen that Gatherer Extractor won't correctly extract the data. I need to see what has changed and update GEx. It will be done soon, and I will propose an update.
PS: The bug is from the last update of MagicCards.info. The way foreign names are handled for dualcards has changed. I will fix (and update !) GEx today. Thank you!
OK, I propose an update (release 4.3), but it has not been fully tested. Nevertheless, the program should no more be stuck when trying to extract foreign names from magiccards.info for dual cards or promos. I will launch many testings to see if everything is OK with the last massive update of the Gatherer from Ixalan (it should be). I will let you know. Feel free to report bugs, even if those are minor.
I'm running 4.3 and there seems to be an issue with the "Download all scans from the list" button. That button used to respect the filter that was chosen and only worried about the cards that were listed from the filter, but now it seems to process every card that has been loaded. The good thing is that it's not redownloading the images, but the really bad thing is that it's taking 2+ hours to download the images from Ixalan because it has to first process every other card.
Also, I second pulling images from a source other than magiccards.info as they seem to be quite slow at updating. Scryfall has a very nice looking API here https://scryfall.com/docs/api/images
Thanks!
Private Mod Note
():
Rollback Post to RevisionRollBack
--
Reliquary for iOS
Your Magic Collection Anywhere You Go reliquaryapp.com
This is with the latest version, 4.1c, on Windows 10.
With the latest gatherer update (Amonkhet), two issues were identified:
-- dual cards were not correctly extracted;
-- cards with alternates (typically basic lands) were not anymore extracted during full extraction.
Those issues are fixed in release 4.2. If you find other bugs, feel free to report. Thanks in advance!
Im using this excellent extractor for my app (DeckWins).
Ive spotted one error:
Never // Return is extracted as Never // Returned
Plus the extractor logo (in the software) is still showing 4.1
I've downloaded 4.2 but I'm still throwing the same error when trying to update legalities or update scans:
************** Exception Text **************
System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
at Gatherer_Extractor.FenetrePrincipale.Treatment_MAJ(Int32 nbre_tache, BackgroundWorker worker, DoWorkEventArgs e)
at Gatherer_Extractor.FenetrePrincipale.BWkMAJ_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Updating legalities the error appears to be on Abandoned Hope from Tempest. Updating scans it appears on Ahn-Crop Champion.
1: Gatherer extractor keeps urging to be updated even though it is on the latest update.
2: Exporting the database to one .sql file works. Each statement ends with a semi-colon. When exporting the database as each .sql being a set name, the statements are not separated by a semi-colon. Instead the statements are separated by a comma which causes importing of those statements to a MySQL server to fail.
Hopefully the second error can be fixed so I can finish automating my setup. Until then I will be writing a small pre-interpreter to fix this problem.
Thank you again chaudakh. If you need any help with this project I will be more than happy to be of assistance.
EDIT: I just realized a 3rd problem I am having. When exporting the database as multiple .sql files the rulings does not convert the symbols to their proper notation. For example, in Aether Herder from Aether Revolt, the rulings have "xE2|x80" instead of {E}.
EDIT 2: This seems to only occur sporadically. The non-acii and non-printable icons are not removed from the rulings at what seems to be arbitrary positions when exported as separate .sql files.
Thought I'd take a look at GE and see what's up and I get the same error as well. Gives me a message that I'm using 4.2 (20/04/2017) and to download 4.2 (29/04/2017). Following that rabbit hole ends up with the same installation file downloaded.
Are the Masterpiece HOU cards in, I can't see them?
I'm having the exact same error.
Indeed, since the last update of magiccards.info, foreign names raise an error in some specific conditions. Thanks for having reported. This is fixed in release 4.2c.
@Geretenk: Thanks for the report. see answer above for explanation & fix.
@swallowtail23: Those have been added in Amonkhet masterpiece set.
Thanks.
There may be some sort of file encoding mismatch between the generated .sql file and what MySQL is expecting, like it's using the first two bytes to figure out what file it's dealing with, which in turn truncates the first statement. I exported a valid .sql file, and you said your file is also correct, so I'm assuming the issue lies within MySQL.
This is happening with me as well. Hope it gets fixed soon. Matter of fact, it's doing this with Amonkhet split cards as well where it wasn't in previous versions. I'm not sure what was changed, but it won't allow me to get past Commit // Memory in Amonkhet either.
I tried with older versions of Extractor (3.22 and 4.1) and both failed on Alive // Well as well. I'm guessing something changed with how the API to the Gatherer site (or magiccards.info) handles split cards that's breaking the program.
When a new set is released on the Gatherer, some slight adjustments & updates are always made on other cards. Wizards permanently changes the way complex cards (flipped cards, dual cards, split cards etc.) are handled, so that it may happen that Gatherer Extractor won't correctly extract the data. I need to see what has changed and update GEx. It will be done soon, and I will propose an update.
PS: The bug is from the last update of MagicCards.info. The way foreign names are handled for dualcards has changed. I will fix (and update !) GEx today. Thank you!
Also, I second pulling images from a source other than magiccards.info as they seem to be quite slow at updating. Scryfall has a very nice looking API here https://scryfall.com/docs/api/images
Thanks!
Reliquary for iOS
Your Magic Collection Anywhere You Go
reliquaryapp.com
I have a small problem. When I download all prices from the list, they appear all as N/A. Is an issue that you know about, if so is there an easy fix?
Thankyou!