New news items not appearing in Summary

[homebrewruss]

Hi,
I'm using CMSMS ver 1.5.3 with the default News module 2.9.3.
When i add a new news article it doesn't appear in my summary page immediately even though the post date appears to be fine and matches the date on my server.  I can even change the date to a previous date and it still doesn't appear.
Clearing the browser or server cache doesn't help either.

However after waiting for a day or so the new news article appears in the summary page as if by magic.
Can anyone shed any light on why this might be - i can't see any other settings that i need to change.

Thanks

Russ

[RonnyK]

Do you have the "use expiration" ticked, when entering a news-entry. Because if you dont have that ticked, then ALL active entries should show, regardless of the expiration-dates. The expiration dates arent active, when the tick isnt set.

Ronny

[homebrewruss]

Thanks Ronny but I don't have the "use expiration" checked.

[RonnyK]

OK,

but with the expiration-tick set, the postdate isnt the date that the entry will appear... With the tick set, the start-date and expiry-date are the frame in between the entry is showing.

Ronny

[homebrewruss]

Sure i understand that. 
I don't have the "use expiration" tick checked for any of my articles.  Instead i have a summary template which should show the 3 most recent items.  It's just that the most recent item isn't showing up as soon as it should.

Any other ideas?

[RonnyK]

Sorry, misread the 'haven't' in the earlier post... Could it be a caching-issue then, What happens when you set the cache in Global Settings to 0.

Ronny

[homebrewruss]

The cache is already set to 0 so that makes no difference.  I'm stumped 

[homebrewruss]

Anyone else got an opinion on this?
I've established that it takes 4 hours after posting before a news item appears live. 
Guess i can live with this in the short term but not sure if my client can..

Even if i set the time of posting to five hours prior to the current time it makes no difference, it still takes a further four hours for the news item to appear..

[alby]

Anyone else got an opinion on this?
I've established that it takes 4 hours after posting before a news item appears live. 
Guess i can live with this in the short term but not sure if my client can..

Even if i set the time of posting to five hours prior to the current time it makes no difference, it still takes a further four hours for the news item to appear..

Have you some php caching (eaccelerator, amc, zend ....)?
it happens only with the news?

Alby

[RonnyK]

Postingdate doesnt do anything on the posting.

Only startdate/expirationdate and then only when the use-expiration tick is set.

Ronny

[homebrewruss]

That's right it only happens with the news, new pages etc are fine. I've tried reinstalling the news module but it made no difference. I don't have any caching turned on.

[RonnyK]

What happens when you set the startdate back to an earlier date, and use expiration-tick?

Ronny

[homebrewruss]

Ok, very weird, that works. 
If i set the post date and expiration date over four hours earlier than the current time than the post appears.

Any idea why this might be happening?

If i can't work out why this is happening, guess i could go live with this in the interim but it's not ideal.

[alby]

Any idea why this might be happening?

If you have some SQL skill, you can enable debug in config.php
At this point you can look the SQL query news and check where is the wrong date value (the difference of 4 hours).
Can be a wrong set time of your server

Alby

[homebrewruss]

That's really useful I fell like i've almost cracked it.  If i look at a page with the news summary on it and debug enabled i see the following code:



(mysql):
            SELECT
                mn.*,
                mnc.news_category_name,
                mnc.long_name,
                u.username,
                u.first_name,
                u.last_name
            FROM cms_module_news mn
            LEFT OUTER JOIN cms_module_news_categories mnc
            ON mnc.news_category_id = mn.news_category_id
            LEFT OUTER JOIN cms_users u
            ON u.user_id = mn.author_id
            WHERE
                status = 'published'
            AND
        (mnc.news_category_name = 'General') AND ( IFNULL(start_time, '1969-12-31 19:00:01')  < '2009-03-23 17:41:17')  AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2009-03-23 17:41:17')) ORDER BY news_date desc LIMIT 0, 3
Error (0):

This is the offending time: '2009-03-23 17:41:17'
It should be four hours ahead (ie 21:41:17) which is what the server and MYSQL seems to think it is.

I've tried changing the locale in config.php, .htaccess etc.
Is there anywhere else this time could be set?

Thanks