Can't predate news posts

New Member Joined: Dec 28, 2005 Posts: 14

I am not able to predate a news article. In original phpnuke I could program a news story for a predate, say august 3rd 1998. Now if I try doing that, it just sits in programmed articles and never posts.

registered · Posted: Sat Jan 07, 2006 9:57 pm

Cyberkiller, I am sorry, but I have to ask: why are you trying to pre-date the article. What are you really trying to accomplish? If it is to also re-order your news article, or place an article earlier within the list of news articles, you cannot do this with the date because they are sorted in descending order of the news article ID number (which is auto-assigned).

You could possibly re-order some news articles by changing their sequence numbers using phpMyAdmin, but that could be a little "tricky" not to screw it up.

By the way, it works in RavenNuke76 (which is a latest patched 7.6 version).

Posted: Sat Jan 07, 2006 10:49 pm

I am running raven7.6

I have 70 articles from an old hacked phpnuke installation that I want to copy and paste over, I also have another 100 more from a different site (non phpnuke) that I want to copy and paste over.

I want to predate them because they are a year or two old and wouldn't make sense if I had 170 news articles from several years all in the same date. The archive would be useless.

I tried on a base 7.9 install and it did let me predate them using the program news story feature.

When I try doing this in raven7.6, they just sit as programmed and don't post.

I have no problem with the ordering as I will copy/paste them in order. I also can't really import them into the database as I don't know how and some are not from a phpnuke site.

I don't mind copying/pasting them over as long as I can override the date when I post them.

New Member Joined: Jan 04, 2006 Posts: 10

I also want to pre-date articles, and they do sit in the "Programmed Articles" for a couple days, but then they somehow are allowed out into "Last 20 Articles" after that. I'm not sure why it does that.

I have edited my modules/News/index.php to reorder by time (instead of news article ID #), so the pre-dating makes sense.

Another quirp I noticed with the programmed articles, is if I edit something sitting in programmed articles (happens to only be predated stuff), then the title changes to "News". Re editing the title doesn't matter, it shows up in "Programmed Articles" with title "News." Not sure if this is related to the predated stuff or not. I think I'll do a test...

EDIT:
OK, I did a test and the title changes to "News" after an edit of a future programmed article, also.

I'm using raven7.6v2.00

Posted: Mon Jan 23, 2006 11:50 pm

wish we could find a fix for this........

very much need to predate news.

kaimuki, lemme know if you find a fix?

Posted: Tue Jan 24, 2006 12:37 am

Cyberkiller:

Have you tried letting the articles just sit in programmed articles for a few days? I noticed with the few I've done, that after a few days past the programmed date, it will post eventually. I thought it's related to some date handling issue. Since often the site date shown on my homepage using IE 5.2 for Mac (using Sand_Journey theme) is often a day or two behind the current date. Using the Safari browser shows the correct date.

Posted: Tue Jan 24, 2006 6:54 am

Just to state, my reason for wanting to predate is that I am trying to transfer over articles from an old site and want to maintain my news articles from it with the correct date. I also want the news archived correctly by month/year.

I just don't understand why this is broke in raven's version. A fresh install of 7.9 fixes this problem, but also opens up a whole new can of worms.

Posted: Tue Jan 24, 2006 9:16 am

I also managed to get some to go through, but the predate didn't stay, instead it changed to the current date. They also aren't showing in the news archive.

http://www.worldofwarcraftforums.net/securejerlabs

This is my test site I am using for this.

I have some news articles on there I entered in several weeks ago and they are still sitting in programmed.

Posted: Tue Jan 24, 2006 1:53 pm

I'm using raven7.6v2.02.

I just had another article programmed for 1/21 (I programmed it on 1/22) that finally posted around midnight last night. Of course, as mentioned, because I edited it, the title automatically changed to "News." Looks like it's a bug. Can someone try programming an article then editing it to see if their title changes to "News", too?

When my articles do finally post, the predate does stay.

BTW--this is what I did to get my news article to sort by date instead of by article ID:

~modules/News/index.php
======

/* 01-18-06
$result = $db->sql_query("SELECT sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories $qdb $querylang ORDER BY sid DESC limit $storynum");
*/

$result = $db->sql_query("SELECT sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories $qdb $querylang ORDER BY time DESC limit $storynum"); /* 01-18-06 */

=====

Not sure if I need to change anything else such as the DESC or limit or anything...

kai

Posted: Tue Jan 24, 2006 3:06 pm

The only bug I had was categories, they would always rename to GOD when I submitted them.

I will do a fresh install once again of the last raven and see what happens. Will keep you updated.

Posted: Tue Jan 24, 2006 4:29 pm

Cyberkiller:

if you do a fresh install, it would be great if you could test it out before you do any edits.

1. test the predating problem
2. test to see if editing a programmed article changes title to "News"

kai

Posted: Tue Jan 24, 2006 6:58 pm

did a fresh install of latest ravenpackage

predate still does not work.

Posted: Tue Jan 24, 2006 10:49 pm

well, I had to wait a couple days for the predated programmed article to finally post. I was only predating a few days, though. Of course, I think if you predate, the article should post immediately.

Can you try and edit a programmed article and see if the title changes to "News" after the edit?

Thanks!

Involved Joined: Oct 09, 2004 Posts: 293

In did this a while back simply doing what montego suggested above...editing in the stories table of the id and date #
When sorting order leave a few gaps in the id so the items can be moved up and down.