Douglas W. McCratic

I have been unable to update my db, getting the message "Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. SQ: logic error no such table" Update_ComicIssues See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error no such table: Update_ComicIssues at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at System.Data.Common.DbCommand.ExecuteScalarAsync(CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ProjectX.ContentUpdates.VB$StateMachine_37_UpdaterSQLLoadedOKAsync.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() at ProjectX.ContentUpdates.VB$StateMachine_4_UpdateDatabaseAsync.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ProjectX.ContentUpdates.VB$StateMachine_1_DoContentUpdateAsync.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task) at ProjectX.Globals.VB$StateMachine_312_CheckForUpdatesAsync.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ProjectX.FrmMain.VB$StateMachine_167_CheckForUpdatesToolStripMenuItem_Click.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state) ************** Loaded Assemblies ************** mscorlib Assembly Version: 4.0.0.0 Win32 Version: 4.8.4121.0 built by: NET48REL1LAST_C CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll ---------------------------------------- ComicBase 2020 Archive Edition Assembly Version: 20.0.2.3360 Win32 Version: 20.0.2.3360 CodeBase: file:///C:/Program%20Files%20(x86)/Human%20Computing/ComicBase%202020%20Archive%20Edition/ComicBase%202020%20Archive%20Edition.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 10.0.0.0 Win32 Version: 14.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.8.4121.0 built by: NET48REL1LAST_C CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.8.4121.0 built by: NET48REL1LAST_C CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- System.Data.SQLite Assembly Version: 1.0.112.0 Win32 Version: 1.0.112.0 CodeBase: file:///C:/Program%20Files%20(x86)/Human%20Computing/ComicBase%202020%20Archive%20Edition/System.Data.SQLite.DLL ---------------------------------------- System.Data Assembly Version: 4.0.0.0 Win32 Version: 4.8.4121.0 built by: NET48REL1LAST_C CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Transactions Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.Net.Http Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll ---------------------------------------- System.Web.Services Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll ---------------------------------------- CrystalDecisions.CrystalReports.Engine Assembly Version: 13.0.3500.0 Win32 Version: 13.0.25.3158 CodeBase: file:///C:/windows/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine/13.0.3500.0__692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.dll ---------------------------------------- CrystalDecisions.Shared Assembly Version: 13.0.3500.0 Win32 Version: 13.0.25.3158 CodeBase: file:///C:/windows/assembly/GAC_MSIL/CrystalDecisions.Shared/13.0.3500.0__692fbea5521e1304/CrystalDecisions.Shared.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- log4net Assembly Version: 2.0.8.0 Win32 Version: 2.0.8.0 CodeBase: file:///C:/Program%20Files%20(x86)/Human%20Computing/ComicBase%202020%20Archive%20Edition/log4net.DLL ---------------------------------------- System.Windows.Forms.DataVisualization Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.DataVisualization/v4.0_4.0.0.0__31bf3856ad364e35/System.Windows.Forms.DataVisualization.dll ---------------------------------------- Newtonsoft.Json Assembly Version: 12.0.0.0 Win32 Version: 12.0.3.23909 CodeBase: file:///C:/Program%20Files%20(x86)/Human%20Computing/ComicBase%202020%20Archive%20Edition/Newtonsoft.Json.DLL ---------------------------------------- System.Numerics Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll ---------------------------------------- System.Runtime.Serialization Assembly Version: 4.0.0.0 Win32 Version: 4.8.4121.0 built by: NET48REL1LAST_C CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll ---------------------------------------- Accessibility Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- System.Management Assembly Version: 4.0.0.0 Win32 Version: 4.8.3761.0 built by: NET48REL1 CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- System.Web Assembly Version: 4.0.0.0 Win32 Version: 4.8.4075.0 built by: NET48REL1LAST CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll ---------------------------------------- ************** 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. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> 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 am currently running version 20.0.2.3360 but that is only because I just downloaded it after getting the same error on my previous build. I get the same error when Sidekick attempts to update as well.

I have tried to keep up with all of the FCBD issues, pulling together a set each year. I always struggled to get them organized to suit me in ComicBase but with the CB2020, there is a great way to do it while leaving each of them in their respective titles. In reality, it would have worked all along, but I can be kind of thick sometimes. What I propose is entering the title where it belongs, Savage Dragon #148 comes to mind, so it would go in the Savage Dragon title but instead of using #148, the issue number would be FCBD 2009. A really tough one for me to find was Free Comic Book Day: Aliens/Predator #1, I renumbered it from #1 to FCBD #2009 and voila! It's a quick and easy find. It would allow users to search for "FCBD 2009" and find all of the issues in one place. I know it's a big project but I would be willing to do the legwork if this is an acceptable idea, as I have been entering my books in this way. I guess what I am ultimately saying is that this is a system that works well for me, but is it worth submitting?

Thank you! It seems odd that the default isn't to show all columns available but as long as it's actually there, I guess it doesn't matter.

I know it came up in the beta discussions but have we revisited the idea of selecting an item by simply clicking on any field on that item rather than having to go to the far left? It seems like such a small thing, but it is really making me nuts. I get in a rhythm and panic when I look up and see one book shown in the top area while I'm working on another. Maybe it's something that could be an option?

I'm sorry if I've missed this discussion, but are there no art credits on magazines under the Magazine category? Some of these have some great covers by regular artists that aren't seen anywhere else, particularly the on the fanzines. I've bounced between Magazines and Comics repeatedly and shut down and restarted but there is nothing listed under magazines to the right of "writer." I would think editor would be an important field in magazines as well.

I've noticed the same problem. I'm guessing somewhere between 30 and 50 contributions without an update to my points. It's hard to be sure because I just assumed that they were waiting to be approved.

Found another one, Shazam #10 (4th Series) had preliminary art for Teen Titans Go! (2nd Series) #36

I'm having a similar problem with Sidekick. I begins with the arrow in the circle, makes it about 75% around and freezes. Nothing else happens until I get the message that the program is not responding and I shut it down. I've done this three times now, same each time.

Following the latest update, these are all still Preliminary Covers. All of the Basketful of Heads covers are Preliminary except #3. Fantastici Quattro (Edizioni Star) #16 is the cover for Fantastic Four (Vol. 1) #244 with Italian trade dress. You're saying yours don't have "Preliminary Cover" down the left side? Beyond that, they are slightly different covers, with different ones missing different things like UPC codes, price boxes, credits, and such. Fantastic Four (6th Series) #16 on Atomic Avenue has the Preliminary Cover as the thumbnail but the correct cover in the listing for the book.

Here's a few... Basketful of Heads #1 Berserker Unbound #3B & 4A Black Hammer 3 for $1 Black Hammer/Justice League #5B Captain America (9th Series) #16 Chrononauts: Futureshock #1C, 2A, 3A, and 4A DCeased #6A Doctor Doom #2 Fantastic Four (6th Series) #16 (not listed as Preliminary Artwork but lacks trade dress and title is shifted left on actual book) Fight Club 3 #10B Gideon Falls #18A Hazel and Cha Cha Save Christmas #1A & 1B The Infected: King Shazam #1 Manor Black #3A & 4 X-Man (5trh Series) #2

I've been noticing a ton of preliminary artwork being downloaded despite having "Don't download preliminary artwork" checked. I would say about 50% of my newest additions to my inventory last week are showing preliminary artwork. Is the checkbox working for others? Is there something I can do to correct it? On the same topic, once final art is released does CB replace the preliminary?

I can't resize the window enough to tell that I have made a change. Maybe a millimeter or two?

The latest version fixed it. Sorry it took a couple of days!

I had a similar problem with reading the tables or some such. As I recall, I uninstalled CB, downloaded the file again and installed the new file to fix it. I'm not 100% certain that was my fix but I think it was.

I was using my CDs to install pictures and movies. Disc 1 worked like a champ, no problem. Since then, they simply don't load. CB recognizes the disc and offers to import but then does nothing. I have directed it to the proper file and still nothing happens. I have restarted CB and my computer with no changes. I copied the compressed files to the desktop with no luck so I unzipped them and still nothing changed. It's like it worked once and never again. Any ideas?