[plugin] [ORPHAN] upm_date_archive: Date archive listings

systrum · 2007-04-21 23:33:36

i am using this plugin to display a side bar archive. i have it successfully displaying dates under 3 category headings, as u can see here

my problem is that when u click on the date link for a particular category (for example for april in the category ‘Misc’) it displays articles for other categories also, in that same month.

in order for it to work properly (displaying articles for a certain category only) must i also restructure my blog into sections? or can i have this work without doing so? i can’t really see where i went wrong.
any pointers would be greatly appreciated

i have also played arounr with exclude_category and it doesn’t seem to be doing anything (it continues to display the category i want to exclude).

Last edited by systrum (2007-04-21 23:58:29)

Mary · 2007-04-22 01:34:57

Are you wanting it to display only specific sections, or are you wanting it to not display specific sections?

Can you post whatever you are currently using?

systrum · 2007-04-23 00:50:22

i did it! i obviously had not ordered things into sections and after having done that it works perfectly.

Mary · 2007-04-23 06:40:34

v.0.2.2

Last edited by Mary (2013-01-24 17:24:01)

anoke · 2007-05-24 12:41:06

<txp:upm_date_archive mode="smart" section="----cut-away----" none_found="archive_none_found"/> -> Textpattern Notice: Unknown tag attribute: mode on line 598

Hmm? Yes, mode defaults to smart. I tried adding it to check if my “archive_none_found”-form would get printed. (it didn’t. should it? i searched the plugin code but found only one hit for “none_found”.. “No articles could be found for the requested month.” prints fine.)

Trying on SVN @ 2388.

Or am I doing something wrong there?

stuu · 2007-06-06 08:19:37

Noob to textpattern, and lovin’ it so far.

My question/problem is with upm_date_menu and timezones.

I’m in Japan (GMT+9) and am hosted on textdrive (server tz=UTC).
Am in the process of (cough) manually importing a bunch of entries from a different cms.
I first tried not entering a time on the “write” form, but textpattern marks my post as Jan 1970, so I went ahead and marked everything 00:00:00.

When I do <txp:upm_date_menu /> I get the following:
1) duplicate months in the menu .. 2002 Sep Sep Oct Nov
2) Posts at Oct 1 00:00:00 show up in Sep instead of Oct
3) Posts at Sep 1 00:00:00 don’t show up in Sep — my first post was Sep 1 00:00:00 and it just disappears from the list

The mysql DB is storing everything in UTC (this is correct, right?) so I’m guessing that the search isn’t taking my TZ offset into account.

Now I can fix my batch posts by setting a time where UTC is the same day as JST, but if I really want to post at 3am… is something wrong with my setup?

Mary · 2007-06-06 10:13:56

I’m in Japan (GMT+9) and am hosted on textdrive (server tz=UTC).

Have you adjusted your timezone setting in your preferences?

…Textpattern marks my post as Jan 1970…

That would be a major problem that you need to resolve.

The mysql DB is storing everything in UTC (this is correct, right?)

It stores it in the timezone of the server and adjusts it using your timezone and DST settings when displaying.

Mary · 2007-06-06 10:16:06

anoke: what version of the plugin are you using?

stuu · 2007-06-06 10:32:46

> I’m in Japan (GMT+9) and am hosted on textdrive (server tz=UTC).
Have you adjusted your timezone setting in your preferences?

Yes. I tried turning the timezone setting off, and it screws up the current date in the “write” tab, so I think my current timezone setting is correct.

> …Textpattern marks my post as Jan 1970…
That would be a major problem that you need to resolve.

Ideally I’d like to be able to enter just a date and have it interpret the empty H:M:S fields as 0:0:0, but since that’s not the case, I had gone ahead and input 0:0:0 e.g. 2002-09-01 00:00:00

> The mysql DB is storing everything in UTC (this is correct, right?)
It stores it in the timezone of the server and adjusts it using your timezone and DST settings when displaying.

That’s what I thought. Pasting the relevent SQL query to phpMyAdmin works as I think it should. My problem seems to be with posts that span months/years between UTC (server timezone) and JST (my timezone).

Examples:

Entry [2000-09-01 01:00:00(JST)] Stored as [2000-08-31 16:00:00(UTC)]
causes Multiple “Sep” headings
[ 2001: Sep Sep Oct … ]

Entry [2001-01-05 01:00:00(JST)] Stored as [2001-01-04 16:00:00(UTC)]
Entry [2002-01-01 01:00:00(JST)] Stored as [2001-12-31 16:00:00(UTC)]
causes a duplicate heading in the wrong year
[ 2002: Jan ]
[ 2001: Jan(2001) Feb Mar Jan(is actually Jan 2002) ]

Update

Just installed rss_suparchive and got the same funky search results, so it looks like I’ve run into a textpattern setup/search problem.

Last edited by stuu (2007-06-07 01:42:24)

Mary · 2007-06-07 14:44:51

I tried turning the timezone setting off…

Er, how? it can’t be “turned off”.

…so I think my current timezone setting is correct.

Which is… what? You’ve got it set to GMT +9? That is what you should have it set to.

Ideally I’d like to be able to enter just a date and have it interpret the empty H:M:S fields as 0:0:0, but since that’s not the case, I had gone ahead and input 0:0:0 e.g. 2002-09-01 00:00:00

The thing is, those fields are pre-populated with the current date and time when you open the Write tab, so it shouldn’t be a problem. If you really want them stored as being posted at exactly midnight, then changing the time fields to zero is how you would do it. If it’s only a case of you not wanting posts to have the time displayed to readers, that is customized in your article forms.

I’m not seeing where you’re getting the “stored as” dates. They would be stored in the timezone your server is on. Is your server’s date and time set to GMT/UTC?

Would you please post your “high” diagnostics results?

anoke · 2007-06-07 19:54:39

Mary: 0.2.2

stuu · 2007-06-08 01:38:10

Sorry for the mess — I can’t seem to be able to explain this easily.

> I tried turning the timezone setting off…
Er, how? it can’t be “turned off”.

Set to “GMT+0” so that it matches the server’s timezone.

> …so I think my current timezone setting is correct.
Which is… what? You’ve got it set to GMT +9? That is what you should have it set to.

Yes.

The thing is, those fields are pre-populated with the current date and time when you open the Write tab, so it shouldn’t be a problem. If you really want them stored as being posted at exactly midnight, then changing the time fields to zero is how you would do it. If it’s only a case of you not wanting posts to have the time displayed to readers, that is customized in your article forms.

Yes. Since I don’t need times for manually imported (copy/pasted from different CMS that I can’t import from) I will figure out how to turn times off for posts-older-than-x-months.
But that’s not my point.

I’m not seeing where you’re getting the “stored as” dates. They would be stored in the timezone your server is on. Is your server’s date and time set to GMT/UTC?

That’s correct. Server is GMT/UTC so the “posted” and “last-modified” fields in the mysql textpattern table are converted to GMT/UTC. My problem (this also happens with rss-suparchive, so it might be a textpattern thing or both plugins are making the same mistake) is that when the converted GMT falls on a different month/year than my localtime (+9:00) the plugin pulls the entry in a wierd way.

Posted as 2002-01-01 00:00:00 JST -> stored in mysql as 2001-12-31 15:00:00 GMT
Entry shows up in the archive menu at the end of 2001 instead of at the beginning of 2002
Entry doesn’t show up in January 2002

Would you please post your “high” diagnostics results?

Textpattern version: 4.0.4 (r1956)
Last Update: 2007-06-03 05:00:32/2007-06-03 04:58:05
TZ: JST-9
PHP version: 5.2.0
Server Local Time: 2007-06-08 10:34:52
MySQL: 5.0.27-log
Locale: en_US.UTF-8
Server: Apache
PHP Server API: cgi-fcgi
RFC 2616 headers:
Server OS: FreeBSD 6.2-PRERELEASE
Active plugins: rss_admin_show_adv_opts-0.3, rsx_plugins_table-1.1, rsx_plugins_list-1.1, wet_thumbfilter-0.6, rss_category_cloud-0.1m, fpx_image_import-0.3, upm_image-0.6, upm_img_popper-1.3.4, upm_date_archive-0.2.2m, rss_suparchive-0.18

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/

<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php </IfModule>

#php_value register_globals 0

SecFilterEngine Off

————————————

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/share/mysql/charsets/
17 Tables: -

PHP extensions: session, SPL, Reflection, date/5.2.0, libxml, bz2, calendar, ctype, curl, dom/20031129, exif/1.4 $Id: exif.c,v 1.173.2.5.2.4 2006/10/10 22:22:43 tony2001 Exp $, ftp, gd, gettext, gmp, iconv, imap, mbstring, mcrypt, mhash, mssql, mysql/1.0, mysqli/0.1, ncurses, openssl, pcntl, pcre, pdf/2.1.1, zlib/1.1, PDO, pdo_mysql/1.0.2, pdo_pgsql/1.0.2, pdo_sqlite/1.0.1, pgsql, posix, readline, standard/5.2.0, shmop, SimpleXML, soap, sockets, SQLite, tidy/2.0, tokenizer/0.1, xml, xmlreader/0.1, xmlrpc/0.51, xmlwriter/0.1, xsl/0.1, yaz/1.0.7, zip/1.4.0, json/1.2.1, Zend Optimizer

pretext_data: array ( ‘id’ => ‘’, ‘s’ => ‘’, ‘c’ => ‘’, ‘q’ => ‘’, ‘pg’ => ‘’, ‘p’ => ‘’, ‘month’ => ‘’, ‘author’ => ‘’, ‘request_uri’ => ‘/5e54105c03f24acce4318a89ff9c66a7/?txpcleantest=1’, ‘qs’ => ‘txpcleantest=1’, ‘subpath’ => ‘\\/’, ‘req’ => ‘/5e54105c03f24acce4318a89ff9c66a7/?txpcleantest=1’,
)

/include/txp_category.php: r1879 (aee777474b2f67ca07fc25756ba25c15)
/include/txp_plugin.php: r1917 (74184c0d8ed8608f840707a255178617)
/include/txp_auth.php: r1879 (b1dd4072b7daf4e997c6ff65ce3d1b2d)
/include/txp_form.php: r1913 (16ec600b41438b4cca10d2c8a19b2db8)
/include/txp_section.php: r1891 (2959593586ba3e97bc602f369c32e738)
/include/txp_tag.php: r1915 (3b4a7f73d92f9bbbe09985c5aa830d29)
/include/txp_list.php: r1892 (41f4d32fd070234b78f94adefebd5234)
/include/txp_page.php: r1913 (34331a5468bbb18dd9f6a282f3aa11e8)
/include/txp_discuss.php: r1909 (9b9ee934a30f52cd7a4d8cb45c8380ab)
/include/txp_prefs.php: r1946 (05615b6275d8927a2a0d51918d70a896)
/include/txp_log.php: r1919 (ed54d02e865319f2506c642a6bde768b)
/include/txp_preview.php: r1238 (5a4ae3ff0d68f4cb573d6d62a00ce9e8)
/include/txp_image.php: r1955 (20be975e67fa7c4aa9a1a3e51bfaf379)
/include/txp_article.php: r1889 (7749f699c03d0c57e04fafe17dbfa94c)
/include/txp_css.php: r1897 (f5cf1c20badb96a063c7c180e9020359)
/include/txp_admin.php: r1879 (d36dac010d21df7bcf9cf5e242b34d58)
/include/txp_link.php: r1879 (0652287df8bb32c66cfa1b939402404a)
/include/txp_diag.php: r1902 (96697ade63048e517177f4129d47de76)
/include/txp_file.php: r1895 (6ed67b094522e51b028dc88baa07444c)
/include/txp_import.php: r1238 (634e75d1b61958875ff275e3130f23ad)
/lib/admin_config.php: r1747 (1563fcbaffe25b3272b0d85ff9d5571d)
/lib/txplib_misc.php: r1956 (182c50b86195f1abe9dbe15728df3cae)
/lib/taglib.php: r1535 (04806ef864d5b0d2974e0e5f6397a2d7)
/lib/txplib_head.php: r1887 (b110efd071e9a5bb395beea66ced128a)
/lib/classTextile.php: r1943 (2c559991e34738eef1990dc079bd91c4)
/lib/txplib_html.php: r1937 (c206ca9cb9a54a7a95f3355b77fd0fa2)
/lib/txplib_db.php: r1879 (d68b6ea69950e405c4fec23b8641d9c2)
/lib/IXRClass.php: r765 (cbe59b59246dce060a4b4a52b4d448d8)
/lib/txplib_forms.php: r1887 (0049a228dc8eb346f8603478a7c1b2e2)
/lib/class.thumb.php: r1955 (12961180eee3add5096e69e0a154284e)
/lib/constants.php: unknown (0e40251c717c52b2b7fe992b62a3e97a)
/lib/txplib_update.php: r1239 (757f8189fcc53a795d7c807f17b2e788)
/lib/txplib_wrapper.php: unknown (584448787b4a3488200722672c0eee0d)
/publish/taghandlers.php: r1949 (3fa1b9ded18e6074b2495a3f4e3c33b5)
/publish/atom.php: r1864 (50602e2f1c443819a0a60f14f39d3093)
/publish/log.php: r1637 (a4a772567079f18101a1752446f3f6d4)
/publish/comment.php: r1951 (a3f803d744fea80808eb27a3f6b28674)
/publish/search.php: r1748 (b0182abc287055fe0932c263b2a5266d)
/publish/rss.php: r1864 (ae43eaa9ebe6b00e63810ae60ca7c6b6)
/publish.php: r1945 (abff727405efc6c4ec8b1cb403290063)
/index.php: r1948 (adf86f44861797f4969373c708ef48fb)
/css.php: r944 (763fa7658fc19ad23a5b2126fcdf366c)

Textpattern CMS

Textpattern CMS support forum

#85 2007-04-21 23:33:36

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#86 2007-04-22 01:34:57

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#87 2007-04-23 00:50:22

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#88 2007-04-23 06:40:34

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#89 2007-05-24 12:41:06

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#90 2007-06-06 08:19:37

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#91 2007-06-06 10:13:56

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#92 2007-06-06 10:16:06

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#93 2007-06-06 10:32:46

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#94 2007-06-07 14:44:51

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#95 2007-06-07 19:54:39

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

#96 2007-06-08 01:38:10

Re: [plugin] [ORPHAN] upm_date_archive: Date archive listings

Board footer