Form posting as article now listed as "pending"

jadrake 09 Apr, 2012
Everything was working fine.

I have a form, that posts a Joomla article. I have a custom action at to combine the form's fields together, and also include a date setting: $form->data['publish_up'] = date('Y-m-d H:i:s');

It worked beautifully, until now.

Now, every article posted via the form is tagged as "pending", not "published". The implication is that the published date is in the future somehow, but looking at the article itself, the created and published date are both identical, and correct.

Things that changed recently: Upgraded to Joomla 1.5.26 and installed Mobile Joomla.

Note: Articles posted normally via the administrative back-end work fine. They publish normally.

Can anyone point me towards a solution, or at least a way to find out what's going on?

Cheers,

Adam
GreyHead 09 Apr, 2012
Hi Adam,

If you look in the database #__content table are there any differences between a ChronoForms published article and a Joomla published one? I guess that something may have changed in 1.5.26

Bob
jadrake 10 Apr, 2012
Problem solved.

Ah, the red herrings and blind alleys I've fished and travelled tonight!

The solution had nothing to do with 1.5.26 and nothing to do with Mobile Joomla, and nothing to do with Chronoforms.

It was all to do with the fact that the clocks went forward recently! Whilst the time appeared to be being entered into the DB correctly, something was going wrong, and the articles were being posted an hour into the future.

The fix?

Changing my reference to date () within the Chronoforms action to gmdate (). Solved everything.

Sorry for bothering y'all. Perhaps my fix will help someone else.

Best wishes,
Adam
GreyHead 10 Apr, 2012
Hi Adam,

Well found - I wouldn't have thought of that explanation in a long time.

Bob
This topic is locked and no more replies can be posted.