[Problem when trying to update the database; what is this error, and how do I fix it?]

I noticed you have CB 2021. Any reason you haven't updated to CB 2022? (it if free if you have a valid subscription (which you must have if you are doing updates)).

I would upgrade and see if you still have a problem.

[Slightly better thumbnail processing.]

Good point.

Probably should have went into more detail.
When checking for Publisher/Title, it if find the actual Issue numbers of the covers in the folder.

It then checks the thumbnail folder for the Grid Cover Icon size/Publisher/Title and Issue number of covers it found.
If there is no Issue number cover in Picture folders, it won't look for those numbers in Thumbnails.

So, even though the Thumbnail has images, if there are no covers in Pictures, then they are ignored (as if they don't exist).

As an extreme test, I changed picture folder location to the default (not my normal Picture folder). This folder has NO covers.
Checked Thumbnails folder and it has all the thumbnails.

Ran rebuild Lists for Pictures.

CB displays NO covers and Thumbnails has all the images still there.

 

[Guy Gardner: Warrior #29/SC]

The cover opens from the center with 'hinges' on both sides (like a double door). Internet search comes up with different names.

Gate/Double fold

Closed Gate fold

Tri-Fold

Of the ones I found, Closed Gate fold looks good to me.

 

[Slightly better thumbnail processing.]

Thumbnails are not deleted by the program.
Currently, the only way to delete them is to navigate to C:\Users\Public\Documents\Human Computing\Thumbnails and manually delete what you want (at the grid cover icon size, publisher, title levels or individual thumbnails).

The way CB process is something like:

Go to a Title.
Look for Publisher/Title Name folder in Pictures.
Does the folder exist?
If No, no covers are displayed
If Yes, does Publisher/Title Name/Grid Cover Icon Size folder exist in Thumbnails?
If No, created Thumbnails and display them.
If Yes, display them.

[Flashback #18 Item Description]

I submitted a correction that will (hopefully) clean up the entries on that issue.

[2022 Advanced Find Item Description]

Can you explain your steps?  I just found a potential bug.

If you are in type Books when you open Advanced Find, Item Description will show up.

However, If you are in type Comic Books or Magazines, open Advanced Find, then change the type on the Advanced Find window the Fields drop-down box list does NOT change to match the type you changed to.

Sorry, I forgot Item Description is for all three types and should show up (as opposed to certain Type specific columns.

Just trying to determine if this is the problem or if it doesn't show up when you are in the correct type in CB.

[Advanced Find ComicBase sorting]

Understood. Just suggesting a work-around for now.

[Advanced Find ComicBase sorting]

While waiting for that, you can type that sort in the Order By once, Save it, then Load it to start and Advanced Find with that as a beginning.

[Missing Issues]

After the current update, I have both of those issues you listed as missing.

PS I just check a database not yet updated and it also has both of the issues.

You can try checking Atomic Avenue and see if they are listed there if you think they are missing.

[Cover Scan Maintenance 2022-01-19]

Delete or Move 6.jpg
From: Pictures\M\Marvel\S\Space Worlds
To: Pictures\A\Atlas\Space Worlds

Delete or Move FCBD 2010.jpg
From: Pictures\R\Red 5\Atomic Robo-Neozoic-Box
To: Pictures\R\Red 5\Atomic Robo-Neozoic-Box 13

Delete or Move 1.jpg
From: Pictures\I\Idea + Design Works\Nick Fury Agent of S.H.I.E.L.D.- Artisan Edition (Steranko...)
To: Pictures\I\Idea + Design Works\Nick Fury Agent of S.H.I.E.L.D.- Artisan Edition (Steranko's-)

Delete or Move 1.jpg
From: Pictures\M\Marvel\S\Silver Surfer- Rebirth
To: Pictures\M\Marvel\S\Silver Surfer Rebirth

Delete or Move MMPB-6.jpg
From: Pictures\D\Del Rey\Star Wars (Del Rey)
To: Pictures\D\Del Rey\Star Wars- From the Adventures of Luke Skywalker
(Note: If you have a MMPB with a blue Star Wars logo and a Yellow diagonal strip on the cover, it is NOT a 1st printing and should be deleted (it is at least a 6th printing when this yellow strip with the text 'The Year's best Movie!' - Time Magazine' on it.))

[Color Overflow in Simplistic Theme]

I am getting the same error when I select the Simplistic theme.

Error in the Theme file: Arithmetic operation resulted in an overflow of value cellbackcolor.

[How to Find? Star Wars Comic Pack #56 (Dark Horse)]

It depends on the 'pack'. For #56, that is Yes. One a story from "Star Wars: Visionaries" and the other from "Star Wars Tales". Others could reprint the whole comic book story.

[Advanced Searches]

Correct. I like functions and was glad you posted about it. I was just writing something up on that...

While the Year component may not be as efficient, it can be used for Month, Day of Month, and (possibly) Day of Week. For example

If you want all items put out in a particular Month (January in the example):

strftime('%m', I.CoverDate) = '01'

You can also constrain it to a Year range (Month January between 2010 and 2019):

strftime('%m', I.CoverDate) = '01' and I.CoverDate Between '2010-01-01' and '2019-01-01'

The Day of Month and Day of Week are probably most useful for Street Date as Cover Dates normally have Day of 1 (with bi-monthly or weekly being some exceptions)
Not sure if they are useful or not but if you need them:

All items with a Day of '15':

strftime('%d', I.StreetDate) = '15'

All items that came out on a Wednesday (Sunday = 0, Saturday = 6):

strftime('%w', I.StreetDate) = '3'

NOTE: the % value is case-sensitive. %m works. %M does not.

[Advanced Searches]

While strftime('%Y',I.[CoverDate]) = '2022' does work, using:

I.CoverDate BETWEEN '2022-01-01' AND '2022-12-31'

is easier to remember and more efficient.

Query with function strftime takes 23 seconds to process while Between takes 1.75 seconds.
(Ran each query several times and got the same results each time. For those interested, the reason is the function has to be applied to every row before the comparison is made. The Between just has to compare.)

PS In case someone hasn't found it, there is an Advanced Find Guide/Manual (work in progress) for those who need a little more information about Advance Find.

[Cover Scan Maintenance 2022-01-13]

Delete or Move 1.jpg
From: Pictures\P\Peachtr\Disney Mickey Mouse
To: Pictures\P\Peachtree Playthings\Disney Mickey Mouse

Delete or Move ALL (1.jpg - 699.jpg)
From: Pictures\W\W.G\Walt Disney's Giant (G Series)
To: Pictures\W\W.G. Publications\Walt Disney's Giant (G Series)

Delete or Move 1.jpg
From: Pictures\M\Marvel\C\Captain America- The Great Gold Steal
To: Pictures\P\Pocket\Captain America- The Great Gold Steal

Delete or Move ALL (MMPB 1.jpg - MMPB 11.jpg)
From: Pictures\M\Marvel\M\Marvel Comics Novel (Pocket)
To: Pictures\P\Pocket\Marvel Comics Novel (Pocket)

Delete or Move HC.jpg
From: Pictures\M\Marvel\G\Guardians of the Galaxy- Collect Them All
To: Pictures\M\Marvel\G\Guardians of the Galaxy- Collect Them All Prose Novel
(NOTE: The 'To' Title has incorrect Item # of TPB. I have notified the editors about this and it should be changed with the next update.)

Delete 1.jpg
From: Pictures\I\Image\S\Spawn- Scorched

Also, these covers need to be swapped:
Rename HC 1-A-4.jpg to HC 2-A-3.jpg
Rename HC 2-A-3.jpg to HC 1-A-4.jpg
From: Pictures\D\Del Rey\Belgariad, The (Del Rey)

[How to Find? Star Wars Comic Pack #56 (Dark Horse)]

I don't think it is in CB yet.

Attached is the indicia. If it can't be read it is:

Star Wars Comic Pack #56: Star Wars Visionaries "Old Wounds," Star Wars Tales "Marked," November 2008. Published by Dark Horse Comics, Inc...

I also found this information:

This story is reprinted in Star Wars Comic Pack #56 which came in a 2010 Sandiego Comic-Con exclusive boxed set with a Darth Maul and Owen Lars action figure.

It appears there are a whole set of these. A Star Wars comic reprint of one sort or another along with 2 action figures.

http://www.rebelscum.com/darkhorse_hasbro2packs.asp has some information about these.

I think this should be a new Title "Star Wars Comic Pack". These were put out by Hasbro with a Star Wars Comic (most if not all by Dark Horse).

[When I scan an Identification label barcode, I get a different title each time]

You can open Notepad and scan into that to see the numbers the scanner outputs.

[Printed Barcodes on Labels not scanning correctly]

Not sure what you are asking.

If you have a barcode and you want to see that it is, you can open Notepad and scan it in to that. You should see the numbers that decodes for the bar code.

[Marked/Unmarked Not displaying indicator in 2022]

In my CB 2022 database, the Marked check mark does show up in the grid.

Not sure why you are not seeing it.

What Theme settings are you using (in case there is a problem with one of them)?

Is this a problem for all types (Comic Books, Books, and Magazines)?

Can you include a screen print of what you are seeing?

PS Here is what I see (with issues 1 and 3 Marked:

[How to Submit Title Corrections (not issue corrections)]

Not a bad question but it is fairly easy.

First, Rename the *.jpg cover scan to the same as the Item #. The only thing to keep in mind is replace any slash ( / ) with a dash ( - ). (because Windows won't allow a slash in a file name.

Some examples:

Item #        Filename

1                   1.jpg

1/A               1-A.jpg

HC 1/A-2     HC 1-A-2

After that, drag and drop it anywhere in the 'grid' area (where the data is).

(If you have multiple covers for the same title, you can drag/drop them all at one time.)

[How to Submit Title Corrections (not issue corrections)]

The best way is to add them to CB, then select the Issue ( s ), right-click and select Submit New or Corrected data from the pop-up menu.

If you have a larger scan, it will ask if you want to send it, also.

However, if you have a replacement scan (replacing an incorrect one) and it won't ask you to send it, you can post it here with an explanation.

Or, you can send it to Support with an explanation.

[Convention Programs - Format for Submission]

Look at 'Wizard World Chicago Convention Program' or 'Baltimore Comic-Con Program' to see an example of what you could do.

 

[Cherry #1]

Can you supply a little more information (and maybe a cover scan or link to it somewhere)?

I think, this Title is Cherry by Kitchen Sink. But it has a convoluted history.

Issues #1-2, with a Title of Cherry Poptart, was published by Last Gasp.

Issues #3-19, with a Title of Cherry, were published by Kitchen Sink

Issues #20-23 were published by Cherry Comics.

However, Cherry Comics also appears to have reprinted the earlier issues with the Cherry Comics Logo.

If all this is correct, I am not sure if Cherry as printed by Cherry Comics deserves its own Title or  to keep every thing in the Kitchen Sink Cherry title with a Note on Publication change and the various reprints.

Either way, based on the logos on the covers, some clean-up work looks like it is needed.

[Cover Scan Maintenance 2022-01-06]

Delete or Rename 4-C.jpg to 1-C.jpg then Move
From: Pictures\Z\Zenescope\Myths & Legends Quarterly- Dragon Clan
To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Dragon Clan

Delete or Rename 2-A.jpg to 1-A.jpg then Move
From: Pictures\Z\Zenescope\Myths & Legends Quarterly- Gretel
To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Gretel Witch Hunter

Delete or Move 1-A.jpg and 1-C.jpg
From: Pictures\Z\Zenescope\Myths and Legends Quarterly- Dark Princess
To: Pictures\Z\Zenescope\Grimm Fairy Tales Myths & Legends Quarterly- Dark Princess

Delete or Move 1.jpg
From: Pictures\S\Storm King\Night Terrors- Graveyard Moon (John Carpenter'-)
To: Pictures\S\Storm King\Night Terrors- Graveyard Moon (John Carpenter's-)

Delete or Move 1.jpg
From: Pictures\S\Storm King\Night Terrors- Second Nature (John Carpenter's- )
To: Pictures\S\Storm King\Night Terrors- Second Nature (John Carpenter's-)

Delete or Move 1.jpg
From: Pictures\T\Tokyopop\Secretary Love
To: Pictures\B\BLU\Secretary's Love

[Some label questions]

Here are a couple of thoughts. They may or may not help depending on what and how many you are processing. I am looking at the Price Labels report.

I am assuming you have one Issue with a Qty 10 (as an example).

One thing you can do is duplicate the issue and have (up to) 10 individual issues instead of 1.

Then, when you process labels, you can select the Title and only the issues you want labels for and not the others.

Another possibility, if you are not selling all of your comics, is to create 2 databases. One for your collection and for for sales.

In the Sales database, you can just list the 2 or 3 issues you want to sell (if you want to print all labels at this point, you don't have to duplicate the issue but you can if it helps).

As for the Price, you can change the Price in CB.  There is an option to Lock Price so CB doesn't change it (although some have reported that it could still get changed under certain circumstances).