Article withdrawal not working

Hi LB,

I set an article to be withdrawn on the 3 Oct but it is still displaying on my site.

Have a look here. It's article id 248 (the orchid one). It was set to be withdrawn on the 3rd October but is still there. I haven't resolved the problem with timezones yet (linking to CPGNuCalendar is out by 5 hours for some reason still) so was wondering if it was that, but it should have been withdrawn a couple of days ago.

SQL for the schedule is showing

SELECT * FROM chantill_pronews_schedule WHERE dttime<=1286259798

Well 1286259798 is Tue, 05 Oct 2010 06:23:18 GMT so it should withdraw about now.

[ Use this site to convert. ]

I know that this worked fine in California when I and server were same timezone. And Rusty_ extensively tested in AUS with sever and user in different timezones in 1 direction. I have site in UK (user and server) for which every article is auto-withdrawn - successfully.

So I'm guessing your server must be somewhere other than France ...

It's in the US. This presumably (like the link to the calendar) is a problem between having the server time and the site time set differently?

Probably a bug - code is very complex. But first dude, *you* must know USA is a big place! Timezone please!

Oh alright.. Default timezone America/Chicago it says on phpinfo.

So there's the 5 hours from the CPGNuCalendar bug. Will take a look at that when I get a chance.

But this issue is more than 5 hours. Was going to ask for some debug info - but I see you have full debug turned on - so will look for myself! (You probably want to turn that off.)

Hmm. Can you check, but it looks as if your cms_pronews_schedule db file must be empty. The withdraw record either never got written, or has already been cleared, I guess. In case this is a one-off, can you re-edit to a date and time in a few hours time, and see if it disappears then please? Checking to see if a cms_pronews_schedule record does get written when you submit/save it would also be useful.

I submitted a new article (id 249) and there is an entry in the schedule table.

	id	newstate	dttime
	249	0	1286730060

I edited the other article (248) and that appeared in the schedule table too.

I thought debug info only appeared to admins?

Sent PM on how to reset full debug.

Done, thank you!

Bizzarre. Having edited the article it withdrew it correctly. Very odd..

It may well be a programming bug. It tries to accomplish a lot with very few db i/o's, so I may have let 1 slip through. But it will need > 1 example to have much hope of tracking it.

Once the time has passed it will "clean up after itself". It has to for the scheme to work, but it doesn't help tracking issues!

Did you edit the article much when you first set it up? That was the one area I was most concerned about - keeping the CPGNuCalendar entry constant while the article was being repeatedly edited.

I don't think I edited it a lot. I guess I'll just need to wait and see if it happens again. Sunday is the day of the next 'withdrawal'!