All new adds being deleted over night.

[robferrari]

Similar to the problem before. I now have sendnotice.php running nightly. All the old ads are working properly. However, users are reporting that new ads are deleted overnight. I'm sure when the sendnotice.php runs.

You can view my board right now, 10 ads posted today in Ferrari V-6 & V-8, but none before that since July 30th, which is when you fixed the software. All the ads posted those days since have been removed. Look tomorrow and I bet those 10 ads are gone.

Thanks,
rob

[Chuck S]

Hello

All we did last time was upgrade you to 2.41 and set your ads which had expired like to sometime this week is all I remember which I had stated.

The code is absolute in this respect that if the enddate is less than now then they get expired as I showed previously.

I would bet your 10 ads will still be there tomorow as there enddate is not passed. This is the exact query and there is no way they can be deleted if what is in the enddate is not less than the unixtimestamp of now.

$query = "UPDATE {$Globals['pp_db_prefix']}products SET approved=2,status='$today' WHERE enddate < $today AND isauction=0";
$result = ppmysql_query($query,$link);

[robferrari]

Originally Posted by omegatron

I would bet your 10 ads will still be there tomorow as there enddate is not passed. This is the exact query and there is no way they can be deleted if what is in the enddate is not less than the unixtimestamp of now.

$query = "UPDATE {$Globals['pp_db_prefix']}products SET approved=2,status='$today' WHERE enddate < $today AND isauction=0";
$result = ppmysql_query($query,$link);

The 10 ads plus all others posted yesterday are now gone. This was the exact same problem that was happening before you made sure I had all the correct files. I would run sendnotice.php and it would remove all ads.

Maybe it is the cron job? That wouldn't explain how it removes ads by just running from address url though.

curl http://www.ferrarichat.com/pp-classi...sendnotice.php

I've PM'd you the login info, it is same as last time.

[Chuck S]

Well I have looked at the coding and see no errors at all with our coding.

On your install the enddate is not being set although the code is correct. I can not replicate this anywhere else so at the moment nothing I can suggest

will do more testing to see if I can replicate

[Chuck S]

okay well your issue can not be replicated as to what on your site is blocking the enddate from being set however I did make a tweak to your image-inc.php file to set the enddate and it seems to work

[robferrari]

Originally Posted by omegatron

okay well your issue can not be replicated as to what on your site is blocking the enddate from being set however I did make a tweak to your image-inc.php file to set the enddate and it seems to work

Hmm, so you have never seen this problem before? That's what I've figured the entire time as others haven't had the problem. I knew something on my Db and server was not setting right, I guess enddate.

Would you suggest I look into this more or just go with your tweak?

Thanks,
rob

[Chuck S]

well nope have not seen this before. My tweak should work. You can try a test install and see if it happens to a new install