Doug MedicAR Posted January 30, 2022 Posted January 30, 2022 (edited) I have spent quite awhile now trying to change the pic for Plunge #1-A. I went through the normal process of deleting the pic that was there and drug the new pic into CB. It didn't work, as when I clicked the thumbnail, the thumbnail returned to the Preliminary Artwork as did the full sized pic. I deleted the Preliminary Artwork pic, deleted the thumbnail and put in the new pic. This time, I opened the Picture File and placed the new pic directly into it with the correct name. I closed the file and changed to a different title then returned to Plunge. The original Preliminary Artwork returned. After several attempts, the thumbnail finally changed but no matter what I do, the full size pic goes back to the Preliminary Artwork. The Preliminary Artwork is 505 x 752 and 70.5 KB, my new pic is 900 x 1411 and 157 KB, and both are jpg files. I tried to change my update settings but couldn't. I came up with the idea to change the setting in Sidekick which I was able to do but it still didn't change the outcome of my efforts to change the picture. I exited CB, confirmed the changes in SK and reopened CB. My new thumbnail was there but the full pic had returned to the Preliminary Artwork. Any ideas? The new pic is below. Edited January 30, 2022 by Douglas W. McCratic
Steven L. Dasinger Posted January 30, 2022 Posted January 30, 2022 Here is something you can try. Run File-File Tools Rebuild Lists and select 'Pictures File List (slow)'. Warning: This will take a very long time (a few hours). Alternately, if you want to test if this will work, you can try these steps. Use File-File Tools Manage Pictures and Movies and change the 'location for Pictures and Movies' to some other location. Download the preliminary cover for Plunge 1/A. This should set up the same situation you have but with only 1 cover in the pictures folder. Run through the same steps you did to replace the cover to prove this is still a problem. If it is, then run the Rebuild Lists (having only 1 cover will let it complete quickly) and see if that fixed the problem. If it did, switch the Location for Pictures and Movies back to the original location and run the Rebuild for 'Pictues File List'. Check to see if this fixed the problem. If that wasn't the problem, what are you settings? In Setup->Preferences, at the bottom, do you have 'Automatically download larger pictures when viewing items' checked?
Doug MedicAR Posted February 1, 2022 Author Posted February 1, 2022 Is 28 hours too long to wait on the Rebuild Pictures File List? I'm at 12% now. I know I have done this before but I'm sure it was more in the 4-6 hour range.
Steven L. Dasinger Posted February 1, 2022 Posted February 1, 2022 Yeah, I was thinking 4-6 myself (maybe a little more but not over a day). Not sure why it is taking so long.
Doug MedicAR Posted February 1, 2022 Author Posted February 1, 2022 I'm lost too. My computer is set to not sleep and only go to a screen saver so that any process running can continue. It's never been an issue before, but as I sit here surfing around, it's now up to 32%. Again, never an issue before but clearly some energy/screen saving function is at work here.
Doug MedicAR Posted February 2, 2022 Author Posted February 2, 2022 Up to 68%! I'm hoping to play around long enough to let it finish tonight.
Doug MedicAR Posted February 2, 2022 Author Posted February 2, 2022 Ok, it's done. The rebuild alone didn't work. I put delete the old file, put the new file in and then try to look at the pic and mysteriously the old pic returned. I moved the pictures file to my desktop, downloaded the pic again and went back into the file and replaced it. I went to another title and cam back. My new pic remained in place until I selected the book then it gave me the preliminary art again. The only way I have been able to keep the correct pic is to disconnect from wi-fi. No matter what I do, CB goes back to the Preliminary Art.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 Just noticed another tidbit. The file I have been trying to replace the Preliminary Artwork with was a jpeg file, not a jpg. I converted it, kept the same size on all of it, and had the same result. No matter what I do, CB pulls the Preliminary Artwork back in.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 But wait, there's more! I went out and found me gigantic file to replace the Preliminary Artwork. It's 1988 x 3056 and 763kb. CB pulls the Preliminary Artwork in again.
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 In Setup->Preferences, do you have 'Automatically download Larger pictures when viewing items' checked?
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 (edited) I did, yes. I unchecked it and the change finally stuck! I'm sure I've submitted new and larger pics before and never had this happen. Weird. Re-checked the "Automatically download" box and the old pic is back again. Edited February 3, 2022 by Douglas W. McCratic Re-checked the box
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 You are going to have to contact support to see if they can figure out why it is doing what it is. Here is what is happening (I think). The way the Automatic download is supposed to work is it check the Picture column information in your database with the size of the cover scan at HC. If the value is smaller, it automatically downloads the cover from HC (the pre-lim). The Rebuild List Picture information is supposed to populate these columns but something is preventing this (hence the 2-3 day processing time). Since that information is NOT getting updated, it always looks like the HC cover scan is 'larger' and it gets downloaded. The question (that support will have to answer) is why the Picture column information is not getting updated.
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 To take my guess and stretch it to complete speculation... When you ran Rebuild List for Picture information, it might be trying to update the columns but can't (for some unknown reason) and times out. This is repeated for each cover scan in the Pictures folder. While the time-out my not be very long, multiply it by a LOT of cover scans and you get a very big number (days...). Just curious can you run these in Advanced Find? I.[PictureWidth] IS NULL AND I.Title = 'Plunge' I.[PictureWidth] > 0 AND I.Title = 'Plunge' I am most interested in which Find your problem cover (1-A.jpg) is in.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 (edited) Ok, I am going to need some help on this one. I gave up trying to use the Advanced Find way back around 2008. Do I run each individually? One in each field? All together? Use Load Search? Save Search? Or Find? Edited February 3, 2022 by Douglas W. McCratic Needed still more clarification
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 Just paste (one at at time), in the Items Where... box.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 (edited) It came up under: I.[PictureWidth] > 0 AND I.Title = 'Plunge' The books came up in this order: 1 1-A 2 2-A 3 3-A 4 4-A 1-B 1-C Edited February 3, 2022 by Douglas W. McCratic Because I'm editing everything I do tonight
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 Hmm, not what I expected. That means there is 'something' in the picture width column. It could be this information was set sometime in the past but now it isn't changing. If you want to you could change it to: I.[PictureWidth] Between 0 AND 500 AND I.Title = 'Plunge' AND I.[ItemNumber] = '1/A' and altering the 0 and 500 until you get a range that displays the row. For example between 0 and 500 IF not found, change to 500 and 1000. If found, change to 500 and 750, etc. until you get close to the value in the column. for that issue, (it will probably be 505 since it is a pre-lim cover). This is totally optional but it will let get you the value in the column.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 Sure enough, it narrowed down to between 505 and 506 and only brought up #1-A. I dropped the Item Number from the search, used 505 and 506 again and came up with #1-A and #3. #3 doesn't appear to be Preliminary Artwork.
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 The fact that #3 (which in my database has a width of 1578) tends to indicate the Rebuild Picture information did NOT update the values. That seems to be the main problem and one I can't help you with. If you have the time or are interested, you can try this: Use File->New Database... and create another database (just for testing). You don't have to copy anything over when asked. Go to a Title without pictures. (Plunderer one Title back from Plunge works in my database). Run Advanced Find: I.[PictureWidth] IS NOT NULL AND I.Title = 'Plunderer' This should return none of the Issues as the Picture information should not exist. Drag/Drop any cover scan into this Title (with the name matching one of the issues without covers. Run the Advance Find again. What should happen is the one issue for the cover you added should be displayed. At least that is what happened with my database. If this works, that means there is something 'wrong' with you original database. PS You delete the temporary database you created. It is located at: C:\Users\<logon-id>\Documents\Human Computing\ComicBase Databases And the Test Cover Scan you added to the 'Plunderer' Title. PPS You can run the same test on your real database and see if it works as it should (the Issue is found after adding) or not.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 I started to do as you suggested but it hit me before I did it, "What if #3 really is 505 wide?" I looked, and it is. I tried to download the cover again but it tells me no larger cover is available.
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 Well, #3 is a pre-lim cover even though it is not obviously marked. Look at the UPC and you see it is all 0's.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 Mysteriously, Plunderer has Preliminary Artwork in it that returns similarly to Plunge #1-A. I poked around until I found "Poets Prosper: Rhyme & Revelry" and followed your instructions. It worked in that it came up empty before I added a cover and found the title after I added the cover. I deleted the cover file and ran it again out of curiosity. It still brought up the title even though no pic is present. I'm guessing that this happened because I had an item in that position, removed it, and didn't rebuild lists?
Steven L. Dasinger Posted February 3, 2022 Posted February 3, 2022 You assumption is correct. Since the cover scan was manually deleted (outside of CB) it has no reason to change the value. I would still contact support and see if they can figure out why your original database isn't updating the Picture Information. 1
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 1 hour ago, Steven L. Dasinger said: Well, #3 is a pre-lim cover even though it is not obviously marked. Look at the UPC and you see it is all 0's. I don't know that I ever would have caught that.
Doug MedicAR Posted February 3, 2022 Author Posted February 3, 2022 As much as we have talked about this, have you tried to replicate it?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now