sendnotice.pho seems to have deleted all adverts/marked as sold?

[darr3n]

Cron Job: sendnotice.php

Following on from that.

I have enabled it in the footer and it's run and now to my horror all adverts apart from 2 have been deleted and i think it's classed them as sold even though they're not and they do not have an expiry date on the advert?!

Luckily there was only about 30 adverts but still is this an option I've set incorrectly?!

Main Index - My Spain Classifieds

EDIT: Also it's sent no owners of adverts any emails/pm that it's expired something or anything like that

[Chuck S]

No the cron task did what it was suppose to do. It does not get rid of sold ads. They get rid of themselves if users mark them sold.

The cron script gets rid of expired ads meaning if someone posted an ad for 30 days and you run the script and the ad is 32 days old then its not expired.

If you have never ran your cron then I can see you being a little freaked but its just doing its job.

[darr3n]

Originally Posted by Chuck S

No the cron task did what it was suppose to do. It does not get rid of sold ads. They get rid of themselves if users mark them sold.

The cron script gets rid of expired ads meaning if someone posted an ad for 30 days and you run the script and the ad is 32 days old then its not expired.

If you have never ran your cron then I can see you being a little freaked but its just doing its job.

Hi Chuck,

I repeat it's not done what it has meant to do as 90% of those adverts I placed (uploaded via the option to set user name) as those were the active adverts from vbclassifieds I converted over to your product.

So I can 110% confirm all those adverts were set to NOT expire and yet, all of them bar 2 have been removed, they do not show up anywhere as sold or anything of the sort.

I have done a couple of test adverts just now and set the sendnotice cron to run every 2 mins and it has not deleted those yet.

Though it seems to be working as it should right now why would it have deleted adverts that did 110% have a no expiry date set?

EDIT: Reruning phrases.php would not have caused this right?

[Chuck S]

It would have had to do its job. I mean it only expired ads what are over the timeframe the ad is set for.

we are dealing with absolute queries here

[Chuck S]

Here is the query in cron.php

Content visible to verified customers only.

It only expires ads where enddate is less than the time in unixtimestamp of today this very minute when you run it

[darr3n]

Chuck,

I'm not disputing it has done what it was meant to do but what I'm disputing is I know for a fact that the vast majority of those adverts had NO expiry when place.

Now the only thing I can think of is perhaps your product did not record the expiry selection properly? I can understand it if I miss-selected a couple of adverts but not 33 out of 35!

Another example to back this up is an advert I placed myself under my account of a couple of weeks ago was marked as SOLD after running sendnotice and I have NEVER marked any advert as sold.

I started out with v3 (whatever the latest version was before v4) if that's any help.

I'm just very concerned that this will happen again once I convince my users to replace adverts!

[Chuck S]

I posted the query for you above. Nothing has really changed in the sendnotice script and the cron.php file is a duplicate of sendnotice.php except the print statements. For your ads to be expired then the enddate on those ads had to be less than the unixtimestamp of today.

Feel free to post the unixtimestamp of one of those ads but like I said this is an absolute here.

For expire those ads lets take the query I posted and construct what the query looks like in reality.

Say you ran the cron task right this minute

UPDATE cp_products SET approved=2,status='1268682020' WHERE enddate < 1268682020 AND isauction=0

That would only expire ads where the enddate is less than that timestamp right there.

[darr3n]

Chuck something even more concerning to me has happened to my user data with your product.

The peoples ads which were removed now have a post count of "4294967294" each having previously had a 0 post count.

This simply further backs up me in saying it was not me who accidental set wrong expiry dates or the unixtimestamp but a bug or error in your product which makes me very nervous considering it's handling and changing sensitive data (ie the user data)

Please let me know what is going on as it's clearly doing something to it that it shouldn't.

Not happy at all tbh.

PS: My set up seems to be fine as you've previously checked it concerning the advanced editor bug.

[Chuck S]

well what integration is this? what site is this?

First off expiring ads has nothing to do with post counts so not sure you can correlate the two. There is no connection there. You can look at cron.php or sendnotice.php we don't query or change anything to user counts. Just my 2 cents there. That cant be related.

I stand beside what I have said twice here. I will look at your site but as stated thats an absolute query there and this script runs on everyone's sites for years now. the script for expiration of ads is virtually untouched since the programs creation. It simply expires an ad that has an enddate less than today's date.

I would be interested in having site data and uploading an ad or two and checking the database to see how date formats are being stored. Or even so if some ads have not been dropped from the database that you say are expired seeing what those dates say as that would say alot.

[darr3n]

What sort of access would you require to do the checking as my host is somewhat restrictive of what can be done (there is no cpanel)

So just to confirm nothing what so ever in your product is meant to change post counts?

Originally Posted by Chuck S

well what integration is this? what site is this?

First off expiring ads has nothing to do with post counts so not sure you can correlate the two. There is no connection there. You can look at cron.php or sendnotice.php we don't query or change anything to user counts. Just my 2 cents there. That cant be related.

I stand beside what I have said twice here. I will look at your site but as stated thats an absolute query there and this script runs on everyone's sites for years now. the script for expiration of ads is virtually untouched since the programs creation. It simply expires an ad that has an enddate less than today's date.

I would be interested in having site data and uploading an ad or two and checking the database to see how date formats are being stored. Or even so if some ads have not been dropped from the database that you say are expired seeing what those dates say as that would say alot.

[Chuck S]

You have no web hosting panel?

I would need this usually

1. url and admin login to your application.

2. ftp info

3. url and login to phpmyadmin. If you dont have that its an application you can download and install just like ours.

[darr3n]

Originally Posted by Chuck S

3. url and login to phpmyadmin. If you dont have that its an application you can download and install just like ours.

I will get you this as I was never supplied with it but I know it's available.

There is definitely something going on as I've just noticed something else.

I did a test advert for 3 days and ofc it sends you a email to say it's going to expire soon etc and also when you're in the classifieds you have 1 message.

BUT the person photopost classifieds says the msg is from is some random user on the site see as follows:

From: spanishlawyer [ March 16 03:03PM ] [ Reply ]

Darren, your ad on My Spain for Test test please ignore is going to expire in 2 days. If you have not sold your product and wish to renew your ad for an additional 3 days, please click on the link below: Login - My Spain Classifieds If you have sold your item, please let us know by clicking on this link: Login - My Spain Classifieds Thank you!

From is some random user who has never used the classifieds at all!

[Chuck S]

well like I said I would need that info to really comment further.

whats your email say about the ad expiration?

[darr3n]

Originally Posted by Chuck S

well like I said I would need that info to really comment further.

whats your email say about the ad expiration?

I've emailed my host about myphpadmin access so will email or PM you that information which would you prefer (we've had a previous email convo concerning the advanced editor issue so I can reply to that if you want?)

Here's the email it mentions no specific dates:

Admin, your ad on My Spain for Test test please ignore is going to expire in 2 days. If you have not sold your product and wish to renew your ad for an additional 3 days, please click on the link below: Login - My Spain Classifieds If you have sold your item, please let us know by clicking on this link: Login - My Spain Classifieds Thank you!


---------

Also I've noticed that ones post count on vB does go up when you place at advert so if one expires and the user previously had 0 posts perhaps there is a bug where it can't set it back to 0 so instead sets it to some huge number?

[darr3n]

Got the information you need Chuck how do you want it?

PM, Reply to the previous email conversation or contact us?

[Chuck S]

contact us in the header