Database date fields

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
chief
Posts: 1
Joined: Thu 7. Jul 2011, 21:19

Database date fields

Post by chief »

I'm trying to change article dates - begin (article_begin), end (article_end), created (article_created). I can change the begin and end dates in the backend. I can change the begin, end, and created dates in database using phpmyadmin.

However, when I try to refer to those dates for sorting of an rss feed (in feed.ini.php), I can't seem to get it to recognize the changes - when I ask it to sort by "livedate", instead of sorting by article_begin, it sorts by article_created. And the real kicker is that even after I edit article_created to reflect a different date, it still sorts and displays the original article_created value in the feed.

Any ideas? Ultimately, I'd like the feed to be sorted by livedate.
User avatar
Oliver Georgi
Site Admin
Posts: 9889
Joined: Fri 3. Oct 2003, 22:22
Contact:

Re: Database date fields

Post by Oliver Georgi »

Maybe your feeds.ini.php is not well formatted. Be sure to use the default INI-file and change the INI section only.

This is the line you need:

Code: Select all

orderBy = "livedate" ; possible: livedate, killdate, createdate, changedate
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Систрон
Post Reply