Problem with Calendar on 31st date of every month

Archived from the Xataface Users forum.

muzafar — Tue May 08, 2012 10:55 pm

Greetings,

I am working on the calendar event and it is working for all other dates except the 31st of any month. I am sending the snapshot, you can check. I have event on 31st of may 2012, but it is not shown in the calendar, if i change the To date to 30 or some other dates, then it show the event in the calendar. below is my table structure.

reportDuration enum(‘Weekly’, ‘Bi-Weekly’, ‘Monthly’, ‘Quarterly’)
reportFrom datetime
reportTo datetime
dueDate datetime
and my fields.ini file is:

[reportFrom]
event.date = 1
event.start = 1
widget:label = “From”

[reportTo]
event.date = 1
event.end = 1
widget:label = “To”

please lead me, what’s the matter, why it doesn’t show the event on date 31st?

your help will be greatly appreciated.

---

simbioc — Wed May 09, 2012 3:20 am

Change

$records =& df_get_records_array($query[‘-table’], $query);
with
$records =& df_get_records_array($query[‘-table’], array());

(Approx line = 43 xataface/actions/calender.php)

Solves the issue.

Cheers!

---

shannah — Wed May 09, 2012 9:38 am

Unfortunately that fix will break the calendar action when you have more than 30 events in the table.

I have fixed this issue in SVN.
trunk rev 3584
1.3.x rev 3585
1.5.x rev 3586

If you replace your actions/calendar.php file with the one at http://weblite.ca/svn/dataface/core/bra … lendar.php, it will fix the issue.

-Steve