Primary Images Disappearing Issue
 

Chuck,

Some members alerted me to a problem in our classifieds where some ads that have multiple photos have had their primary photo disappear along with the associated thumbnail. Some of these ads are ads marked as sold, others are not, so it doesn't seem to be tied to that. Here are links to some ads where this is true:

2011 CPO Cayman 2.9L, 100k Warranty or until 3/31/2016! LSD Equipped! - Classifieds

2010 Cayman S Interseries Race Car - Classifieds

(Please note in these first 2 ads placed 5 months apart that the primary photo has a .jpg file name of http://www.planet-9.com/classifieds/data/2/808244.jpg and http://www.planet-9.com/classifieds/data/2/808244.jpg which are IDENTICAL file names. How is that even possible???)

here is a third that is also missing its primary photo and is in a different category from the other ads:

2006 Cayman S Damaged - Classifieds

It has the same missing filename for its primary photo as well. How is that even possible??? Something is very wrong here Chuck, and I haven't done anything to our Classifieds code/files in months since the last upgrade, people have just been using the Classifieds that's all.

Please help me fix ASAP, I should be around all day Monday if you need my help troubleshooting and you have admin access to my site still per our last troubleshooting sessions.

Your site is not loading for me at all but I would definately need more info here and have to see the issue.

Also I do not keep site data so I would not have any access info.

Chuck the site is up, I'm looking at it right now, please try again. Do you still remember your site password or do I need to email you a password?

The site is up this morning. Comes right up but did not last night for whatever reason. Your scripting stopped and it tried to download the PHP files.

Anyway yes you would need to send any login data as I have no info for your site.

I just emailed you your account information, please let me know if you need anything else.

Okay will respond via email. I will post an ad or so to try and get an issue but if not I will definately need more info on this.

Chuck I saw your sample ads. Did you notice that all of the ads not showing thumbnails that actually have photos and should have a thumbnail are now all pointing to the following missing image:

http://www.planet-9.com/classifieds/data/24/380689.jpg

That is DIFFERENT from what it was yesterday when I posted this topic (see message above in this thread with the jpg listed)

What, other than the cron job, would change the URL on all these ads for the image??

Let's see what happens to your test ads after the cron job runs tonight...
BTW there is an ad that was listed a couple of days ago that today was marked sold by the seller and shows up as sold, I want to see if in 2 days the ad disappears as it should. :)

One other thing I took an ad missing it's thumbnail and went to edit the ad:

Login - Classifieds

In edit mode it shows that bogus 380689.jpg as the first photo and it is of course missing. All the rest of the photos are there though, such as:

http://www.planet-9.com/classifieds/..._6427.jpg?6341
(what's the 6341 after the jpg represent btw?)
http://www.planet-9.com/classifieds/..._6430.jpg?5008
etc. down to CAP_6442.jpg

So I fired up my FTP program and went and looked at my /classifieds/data/24/thumbs/ directory and in it I found a CAP_6425.jpg which I can guarantee you is the thumb from the original photo uploaded when the ad was posted.

This means the thumbs aren't being deleted (probably true for the photo as well but I haven't checked) but that SOMETHING is mucking up the database to change the pointer for the primary photo from the proper link to the bogus link that then displays a red X because no such photo exists.

Since there have been 2 ads with photos uploaded AFTER your test ads and your test ads are still fine right now, I suspect it doesn't have to do with new ads hurting existing ads, but rather I'm still thinking something in Cron has gone haywire... just to be specific I have no new mods, no new code, no new cron activities or anything recently and this problem only started recently.

Users can replace there image maybe they tried cant say but thats why an image direct url would change in an ad.

Your talking about 2 different ads here out of 517

The cron task does not delete files at all it does two things. updates the status field from 0 to a timestamp and sends an email. That is all it does.

Ads are deleted for good when you visit the admin panel and they are expired over 2 weeks.

Chuck,
To be clear there are DOZENS of ads missing their first primary photo and associated thumbnail, I only pulled out a couple to show you as examples. Do you really want me to go through all 517 and count how many have been affected? I can, but I thought you understood the problem was much larger than just a couple of ads. Which reminds me I need to go check your sample ads this morning and see if they are still OK or not.

If the Cron job isn't changing the thumbnail link to be a bad link then what is? It would be impossible for different people to all fail in editing their primary image only and to all end up with the same bogus .jpg number and that number keeps changing as witnessed above. I think I need to go into the database and look and see what the thumbnail value is. Is it actually that bogus .jpg number photo or is it simply blank, etc, or is the correct value really there?

BTW I can shoot you the plesk control panel log in info in email if you want to look around the database as well.

CHUCK!!!! You better rethink your Cron job! :)

Go look at your test ads posted yesterday. Guess what, the thumbnails are GONE GONE GONE! :)

Yep, looks like the Cron job is doing something strange... :)

Ken,

You have indicated that you have some custom cron thing going on installed recently which coincides with your recent issue. Let's also keep this discussion in one place so I am not posting both in email and here.

Our cron scripting does not alter or delete any files or ads at all. When we delete ads in the program both the ad and files are removed and that is done through admin scripting and then you would not be able to see the ad.

Your issue is most definately related to your recent changes and custom cron script if your trying to do something custom aside from what our code does.

We do not offer support for custom alterations to code. From a support perspective I would tell you to disable any recent cron your guy Scott has setup and instead make sure you use all clean files of ours from our member's area. You can do that by downloading the code and unzip it. You can delete the data and uploads directories. You can delete the 2 config files install and upgrade files. You can then upload the contents of what is left to your classifieds directory.

Chuck,
I understand no support for custom alterations to code and actually there weren't any alterations to your classifieds code, but rather a separate cron job that when something was changed recently had an affect on the classifieds database. My host and developer are in the process of fixing that. Thanks for checking into this for me, sorry it took me so long to get back here and post I've been traveling again.
Thanks!

Ken

Not a problem obviously I knew when you described the issue it had to do with your custom stuff since our cron job does not delete files or remove anything from the database only mark an ad as expired. The deletion of ads and images are done somewhere else. Plus when we delete an image the remove images function deletes all 9 images.

It's pretty standard 98% of any issues have to do with configuration issues ( paths/permissions/etc) or code hacks. That really has not changed over the years. The number of true bugs is low.