[plugin] [ORPHAN] upm_date_archive: Date archive listings

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)

Mary · 2007-06-08 16:18:44

I’m not familiar with how the other plugin pulls data from the database, so I don’t know about that. This plugin uses MySQL rather than PHP to do the date math (Txp in general uses PHP). That could be significant or not.

Now you said:

Pasting the relevent SQL query to phpMyAdmin works as I think it should.

Do you mean that if you post the SQL query the plugin uses directly into phpMyAdmin, the results are as expected?

hachi · 2007-07-02 15:40:39

Hi there

I just upgraded from 4.0.3 to 4.0.5 and also updated the plugin from 0.1.6 to 0.2.2. I use TXP with german language set and want to output a archive menu like so:
http://mainstream.radiox.ch/playlists
As you can see, everything works fine except the german umlaute in the month March (März) is not displayed correctly. Does anybody have any advice on how to fix this?

Thanks in advance!
Oliver

Mary · 2007-07-02 23:06:00

I can’t view your site at the moment (“The server at mainstream.radiox.ch is taking too long to respond.”) but I’ll try looking at it again later.

Nic · 2007-07-03 23:32:11

I seem to be having trouble with viewing individual articles within any of the “smart” sections. If I try to view an individual article, it seems to show the default section front article list. I’ve included the code that I’m using to display the articles below. Is this a problem between the “smart” mode finds things? My URL setup is /section/title, if that’s of any help.

I’m using 4.0.5 and 0.2.2. Even if I distill the lower code to a basic <txp:article searchall=“0” />, it doesn’t show an individual article.

PS – Is there a reason the article tag in the month listing (e.g., 2007-06) seems to pick up the year and month? That’s really awesome, and if it’s possible I’d request a feature for a plain month tag to let the article tag do the rest.

<txp:if_article_list>
	<txp:if_section name="press"><!-- Only for the Press section -->
		<txp:if_category name="releases, in-the-news"><!-- For any page but the home page -->
			<txp:article limit="5" searchall="0" />

			<txp:else /><!-- Home page only shows Press Releases -->
			<txp:article_custom section="press" category="releases" limit="5" />
		</txp:if_category>
		<txp:else />
		<txp:article searchall="0" />
	</txp:if_section>
	<txp:else /><!-- Otherwise it's normal on a section page -->
	<txp:article searchall="0" />
<p><txp:older><txp:text item="older" /></txp:older> 
			<txp:newer><txp:text item="newer" /></txp:newer></p>
</txp:if_article_list>

renobird · 2007-07-05 16:35:49

Hi Mary,

This plug-in is excellent! Thank you.

I have a question about sorting.
Is it possible to keep the listings grouped by section?

Month 1
—Section 1
——Article title 1 (sorted by date)
——Article title 2
——Article title 3

—Section 2
——Article title 1 (sorted by date)
——Article title 2
——Article title 3

Month 2
—Section 1
——Article title 1 (sorted by date)
——Article title 2
——Article title 3

—Section 2
——Article title 1 (sorted by date)
——Article title 2
——Article title 3

I’d like sections to appear in the order you list them in the tag (Ex section=“section1,section2,etc”)

Is there currently any way to accomplish this?
if not, would you consider it as a modification?

Here’s a link to the site I’m working on with this

Thanks for all the great work.

)

—
Tom

Last edited by renobird (2007-07-05 16:36:37)

hachi · 2007-07-12 16:44:57

Mary wrote:

I can’t view your site at the moment (“The server at mainstream.radiox.ch is taking too long to respond.”) but I’ll try looking at it again later.

Did you find time to have a look at it yet?
I found another possible bug: When searching in the playlists section and then clicking on the title of the search result, I don’t get the single article but the section page. try for example the search for new young pony club and then try the URL http://mainstream.radiox.ch/playlists/958/

I have set the url mode to /section/id/title and switched off the “add title to permalink” feature. When I switch off the plugin, the URL works and I get a single article.

And just for completeness, I have the following in my template for the playlist section:

<txp:upm_date_menu link_to="playlists" month_format="%B" section="playlists" year_format="%Y" insert_empty_months="no" />

Any help appreciated as always.
Oliver

Last edited by hachi (2007-07-12 16:46:04)

Nic · 2007-07-13 16:42:55

hachi wrote:

I found another possible bug: When searching in the playlists section and then clicking on the title of the search result, I don’t get the single article but the section page.

That sounds a lot like my bug, no? I imagine it has something to do with smart mode, and maybe something to do with error handling?, but I’m not adept enough to look through the plugin.

Nic · 2007-07-19 20:58:45

I apologize if this sounds insistent or rude, but I was wondering if there was any progress made with this plugin issue. It’s coming close to launch for a website I’m work on, but this archive issue is holding us back.

Mary · 2007-08-02 12:46:59

Nothing to do with smart mode, really, but the clean url detection (this always seems to get gummed up by upgrades, expectedly). This latest update should fix it.

v.0.2.3

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

Textpattern CMS

Textpattern CMS support forum

#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

#97 2007-06-08 16:18:44

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

#98 2007-07-02 15:40:39

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

#99 2007-07-02 23:06:00

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

#100 2007-07-03 23:32:11

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

#101 2007-07-05 16:35:49

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

#102 2007-07-12 16:44:57

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

#103 2007-07-13 16:42:55

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

#104 2007-07-19 20:58:45

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

#105 2007-08-02 12:46:59

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

Board footer