New Calendar Module >> Seeking Pilot Group Members

charless, I have one more question to you...

I can see ’Mini-Calendar Width’ field in the Configuration window. What is this field intended for? Is there some way to display a Mini-Calendar view and how?

Thanks!

@Kristalin -
did you log-out of the manager and back in? if not try that and then select the "mxcalendar" module from the menu tab; if that still doesn’t work can you verify that the tables were created on mysql?

let me know what you get then

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table 'admin_gimnazia.kivi_mxcalendar_events' doesn't exist »
      SQL: SELECT *,E.id as eid,E.category as catID, C.name as category, (SELECT DATEDIFF(E.enddate, E.startdate)) as DurationDays, (SELECT TIMEDIFF(E.endtime, E.starttime)) as DurationTime FROM `admin_gimnazia`.`kivi_mxcalendar_events` as E LEFT JOIN `admin_gimnazia`.`kivi_mxcalendar_categories` as C ON E.category = C.id WHERE startdate >= '2010-04-21' or `lastrepeat` >= '2010-04-21' or enddate < '2010-04-21' and E.active=1 ORDER BY startdate LIMIT 0,5 
      [Copy SQL to ClipBoard]

Quote from: charless at Apr 20, 2010, 11:09 AM

@Kristalin -
did you log-out of the manager and back in? if not try that and then select the "mxcalendar" module from the menu tab; if that still doesn’t work can you verify that the tables were created on mysql?

let me know what you get then

after update new files i get new error:

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table 'admin_gimnazia.kivi_mxcalendar_events' doesn't exist »
      SQL: SELECT *,E.id as eid,E.category as catID, C.name as category, (SELECT DATEDIFF(E.enddate, E.startdate)) as DurationDays, (SELECT TIMEDIFF(E.endtime, E.starttime)) as DurationTime FROM `admin_gimnazia`.`kivi_mxcalendar_events` as E LEFT JOIN `admin_gimnazia`.`kivi_mxcalendar_categories` as C ON E.category = C.id WHERE startdate >= '2010-04-21' or `lastrepeat` >= '2010-04-21' or enddate < '2010-04-21' and E.active=1 ORDER BY startdate LIMIT 0,5 
      [Copy SQL to ClipBoard]

looks like the table name it’s looking for doesn’t exist, have you looked at the "System Events" log in the manager reports? If there are errors on install with the tables it will write to the system event log.

check your database and make sure that you have four tables with "_mxcalendar" in the name.

cheers

Quote from: Plankton at Apr 20, 2010, 01:24 PM

Thanks a lot! Another issue is that only Event title with URL can be displayed in the ’list’ mode in 0.0.5. I remember that ’location’ was also displayed in 0.0.4. Could you please advice how to orginize the list view in this way?
----------------
<Date>
Event Title
Description: <content field>
Location: <location>
----------------

Yes...I agree...this is quite a logical way to present an events list, particularly if one does not have a lot of calendar items.

Thank you, Tom

<p>[+mxcEventListItemLocation+]</p>
<p>[+mxcEventListItemDescription+]</p>

    <div  id="[+mxcEventListItemId+]" class="[+mxcEventListItemClass+]">
        <div class="date">
            <div class="month"><p>[+mxcEventListItemMonth+]</p></div>
            <p style="font-size: 70%;">[+mxcEventListItemStartDateTime+][+mxcEventListItemDateTimeSeperator+][+mxcEventListItemEndDateTime+]</p>
        </div>
        <h6 style="font-size: 100%;">[+mxcEventListItemTitle+]</h6>
        <p>[+mxcEventListItemLocation+]</p>
        <p>[+mxcEventListItemDescription+]</p>
    </div>

Retraction: Event List Descript placeholder "mxcEventListItemDescription" was not being set in the class file, so I’ve updated that along with sever different things in a new release 0.0.5b.4 for download.

Here are the release notes:

Release Notes: 0.0.5b.4 - Apr 20, 2010
* Updated FileList:
|- mxCalendar.class.php
|- mxCalendar.tpl.php
|- Release_Notes.txt
|- includes/calendar.inc.php
|- includes/install/mxCalendar.mysql.install.inc
|- includes/install/0.0.5b.4.upgrade.mysql
|- lang/english.lang
|- snippets/mxCalendar.modules.txt
|- snippets/mxCalendar.snippet.txt
|- themes/default/theme.xml
|- themes/default/css/*

Change Log (not all inclusive):
- fixed empty value for mxcEventListItemLabelLocation placeholder on event list
- update to theme setup
- manager tab changes (added: location label events list, moved: rearranged some fields to correct section)
- added new entries in language file to support new manager fields
- database minor update to mxcalendar_config table

http://code.google.com/p/mxcalendar/downloads/list

Fresh installation; working fine for me except that it broke my nice layout :’( Now I’ll have to quit being lazy and pretty it up again...one of these days.