smd_calendar: complete schedule / event / calendar / diary

mikulas · 2016-06-22 10:17:21

Bloke wrote #299917:

Please would you furnish me with some info, a lot of which you can clip from your High Diagnostics:

Textpattern version: 4.5.7 (r5900)
PHP version: 5.3.29
Plugin version: smd_calendar-0.53
Server TZ: Europe/Prague
Server Local Time: 2016-06-22 10:31:01
DST enabled?: 1
Automatically adjust DST setting?: 1
Time Zone: Europe/Prague (3600)
MySQL: 5.0.51a-24+lenny5
Locale: cs_CZ.UTF-8
Server OS: Linux 2.6.26-2-amd64
Active plugins: smd_calendar-0.53, pap_contact_cleaner-0.1m, zem_contact_reborn-4.5.0.0m, smd_gallery-0.62, glx_image_count-0.2, adi_mobile-0.2, kuo_tinymce_mb_cz-0.2m, upm_image-0.6.2, etc_date-0.3, esq_adminsplash-1.01m, ebl-image-edit-2.2, rvm_css-1.0, boy_enduser_docs-0.6_mbm, adi_file_tab-0.1, jmd_sitemap-0.1.2, smd_lib-0.36, soo_plugin_pref-0.2.2, bot_write_tab_customize-0.7.2, wet_peex-1.0, smd_browse_by-0.10m, jbx_multiple_image_upload-0.4m, rah_status_dropdown-0.4, bot_admin_tooltips-0.4m, wet_quickopen-1.1, bot_privs-0.3.2m, adi_article_tab-0.1, msd_admin_datepicker-0.7

My calendar tag with atributes:

<txp:smd_calendar section="nastenka,kalendar,logopedie" expired="1" monthformat="{Leden,Únor,Březen,Duben,Květen,Červen,Červenec,Srpen,Září,Říjen,Listopad,Prosinec}" dayformat="{Ne,Po,Út,St,Čt,Pá,So}" firstday="1" navarrow="0" select="month" datefields="custom_1,custom_6" stepfield="custom_7" showskipped="0" showspanned="1" cellform="kalendar-obsah-bunky" spanform="kalendar-span" yearwidth="1,1" eventwraptag="dd" classlevels="cell,event" />

cellform (kalendar-obsah-bunky):

<txp:smd_if_cal flag="event">
<ul>
<li><h4>{day}</h4>
<dl><dt>Události dne <span style="color:red;"><txp:smd_cal_info type="day" />.<txp:smd_cal_info type="month" />.</span></dt>
{events}</dl>
</li>
</ul>
<txp:else />
<h4>{day}</h4>
</txp:smd_if_cal>

spanform (kalendar-span):

<txp:permlink><txp:title /></txp:permlink>

How your event is set up:

Using a Posted datestamp or a custom field?

Does the event have an expiry?

If so, how is it defined? Posted datestamp or custom field?

Any other custom fields in use?

For a posted date I use custom field.
Does the event have an expiry? – yes
If so, how is it defined?
1. One-day event using fieldset write-expires with the same date as event set and evening hour.
2. Multi-day event using custom field custom_6 and article expiration is set using fieldset write-expires.
3. custom fields for calendar uses datepicker with format yy-mm-dd (e.g. 2016-06-22)
For recuring events is stepfield custom_7.

Last edited by mikulas (2016-06-27 06:18:26)

mikulas · 2016-07-02 09:21:54

Hm, when I delete the atributte datefields from smd_calendar tag and for setting of event day I use the posted timestamp, everything is OK even with the first day of month. (But in this case I’ll have to rewrite all calendar events …)

Bloke · 2016-07-02 14:48:03

mikulas wrote #300126:

when I delete the atributte datefields from smd_calendar tag and for setting of event day I use the posted timestamp, everything is OK even with the first day of month.

OK, thanks for testing and for the detailed info about your environment, and sorry I haven’t got back to you in the meantime. Been sidetracked.

Interesting that it works for regular posted/expiry dates but not the extended custom-field based posted/expiry dates. That gives me something to check. They’re supposed to behave the same way, but maybe there’s some circumstances — like first day of the month — under which they don’t. I’ll do some debugging.

mrdale · 2016-09-14 18:45:31

for some reason I’m getting this error from a vanilla smd_calendar call.

Textpattern Error: Unknown column 'NULLDATETIME' in 'having clause' while parsing form None on page events

[EDIT] Did some snooping… “setting the pref “publish expired articles” to “yes” solved the issue.

mrdale · 2016-11-06 18:31:20

Let’s say my event is on Friday at 10am-6pm.

When I use <txp:smd_article_event time="future" /> when the time rolls around to 10am it no longer displays… I would like it to display til 6pm then disappear…

Am I missing something? Is there an easy way to handle this?

GugUser · 2016-11-06 18:38:52

In Content > Date and time > Expire time 18:00:00. Sorry, I don’t know why you need <txp:smd_article_event />.

mrdale · 2016-11-08 16:12:09

<txp:smd_article_event /> has additional features for displaying recurring events, etc. I got around the issue by using time="any" attribute and by setting expiration on all events regardless of how long the actual event is.

mrdale · 2016-12-05 16:30:32

OK. Still getting the NULLDATETIME errors from <txp:smd_article_event stepfield="custom_35" /> where custom_35 contains 1 week

Codebase: 4.6.2
Plugin: 0.5.4

Help?

Gallex · 2017-04-03 12:18:07

i have the same NULLDATETIME issue:

Tag error: <txp:smd_calendar section="uudised" size="small" firstday="1" dayformat="{P,E,T,K,N,R,L}"  monthformat="{Jaanuar,Veebruar,Märts,Aprill,Mai,Juuni,Juuli,August,September,Oktoober,November,Detsember}" time="any" yearwidth="2,1c" id="aastalind" /> ->  Notice: Use of undefined constant NULLDATETIME - assumed 'NULLDATETIME' while parsing form smd_calendar on page default

and second one:

Tag error: <txp:smd_calendar section="uudised" size="small" firstday="1" dayformat="{P,E,T,K,N,R,L}"  monthformat="{Jaanuar,Veebruar,Märts,Aprill,Mai,Juuni,Juuli,August,September,Oktoober,November,Detsember}" time="any" yearwidth="2,1c" id="aastalind" /> ->  Textpattern Error: Unknown column 'NULLDATETIME' in 'having clause' while parsing form smd_calendar on page default

TXP: 4.6.2

Gallex · 2017-04-03 12:36:13

trying to install the latest version of the plugin which should remove the NULLDATETIME issue from https://github.com/Bloke/smd_calendar
but can’t: Badly formed or empty plugin code

?

uli · 2017-04-03 12:58:45

Gallex wrote #305200:

Badly formed or empty plugin code

Had that when copying from somewhere and had <? or the like captured at the beginning.

Bloke · 2017-04-03 13:02:16

Gallex wrote #305200:

Badly formed or empty plugin code

Try the official release, which has been compiled as a proper plugin. You’ll get that error if you try to install a PHP template file instead of a .txt file.

Textpattern CMS

Textpattern CMS support forum

#877 2016-06-22 10:17:21

Re: smd_calendar: complete schedule / event / calendar / diary

Bloke wrote #299917:

#878 2016-07-02 09:21:54

Re: smd_calendar: complete schedule / event / calendar / diary

#879 2016-07-02 14:48:03

Re: smd_calendar: complete schedule / event / calendar / diary

mikulas wrote #300126:

#880 2016-09-14 18:45:31

Re: smd_calendar: complete schedule / event / calendar / diary

#881 2016-11-06 18:31:20

Re: smd_calendar: complete schedule / event / calendar / diary

#882 2016-11-06 18:38:52

Re: smd_calendar: complete schedule / event / calendar / diary

#883 2016-11-08 16:12:09

Re: smd_calendar: complete schedule / event / calendar / diary

#884 2016-12-05 16:30:32

Re: smd_calendar: complete schedule / event / calendar / diary

#885 2017-04-03 12:18:07

Re: smd_calendar: complete schedule / event / calendar / diary

#886 2017-04-03 12:36:13

Re: smd_calendar: complete schedule / event / calendar / diary

#887 2017-04-03 12:58:45

Re: smd_calendar: complete schedule / event / calendar / diary

Gallex wrote #305200:

#888 2017-04-03 13:02:16

Re: smd_calendar: complete schedule / event / calendar / diary

Gallex wrote #305200:

Board footer