Issues with the Calendar

[digital1]

I tried enabling a calendar for a table that I have and I get the calendar to appear, but none of the records are appearing as events in the calendar and none of the filtering options are showing up. Here is the following code that I have for the calendar:


fields.ini
[date]
event.date=1
event.start=1
(This is a datetime field)


actions.ini
[calendar > calendar]
condition= "true"
The only thing that has changed is that was major was a foreign key was reassigned to a new table for this table and the relationships.ini file was updated to reflect this.

[shannah]

You may want to test to make sure that your [date] section in the fields.ini file is being picked up. e.g. add a widget:label directive to the section and see if it changes the label.

[digital1]

I tested it out and I am getting the label to change, but it's not picking up the event information still. I also have another seperate xataface app that is behaving the same way on this table. (eg events aren't showing up) . This is version 1.2.4 btw

[shannah]

Are you sure that the dates of the records fall in the calendar month you are currently viewing? I cannot seem to reproduce these results. If you can give a simple test case I may be able to set it up and run it... even better is if you could give a link to the app so I can take a look.

[digital1]

I sent you a PM with the log in information. I took the same database setup and put it in my development environment on your newest version of Xataface(1.2.6) and was able to reproduce the issue locally. I tried creating a calendar event with another table and it worked. I am not sure what is so special about this table in particular. I can PM you the create SQL used for this particular table if it would help.

[shannah]

Yes that would help

[digital1]

I sent you the create code.

[digital1]

I tried sending you a PM but it was sitting in my outbox. I am just going to paste the create code here.
CREATE TABLE `show` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`venueId` int(11) NOT NULL,
`hostId` int(11) NOT NULL,
`seasonId` int(11) NOT NULL,
`eventDate` datetime NOT NULL,
`canceled` tinyint(1) NOT NULL DEFAULT '0',
`calendar_name` varchar(255) NOT NULL,
`cancelledReason` varchar(255) DEFAULT NULL,
`discounted` tinyint(1) NOT NULL DEFAULT '0',
`discountedReason` varchar(255) DEFAULT NULL,
`numPeople` int(11) NOT NULL DEFAULT '0',
`numTeams` int(11) NOT NULL DEFAULT '0',
`amountPaid` double NOT NULL DEFAULT '0',
`settledUp` date DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`updatedId` int(11) NOT NULL DEFAULT '0',
`updatedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `venueId_fk` (`venueId`),
KEY `hostId_fk` (`hostId`),
KEY `updatedId_fk` (`updatedId`),
KEY `seasonId_fk` (`seasonId`),
CONSTRAINT `show_ibfk_13` FOREIGN KEY (`updatedId`) REFERENCES `users` (`id`) ON UPDATE CASCADE,
CONSTRAINT `show_ibfk_10` FOREIGN KEY (`venueId`) REFERENCES `venue` (`id`) ON UPDATE CASCADE,
CONSTRAINT `show_ibfk_11` FOREIGN KEY (`hostId`) REFERENCES `host` (`id`) ON UPDATE CASCADE,
CONSTRAINT `show_ibfk_12` FOREIGN KEY (`seasonId`) REFERENCES `season` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1

[digital1]

Here is an interesting conundrum...I changed the eventDate field to a 'date' field instead of a datetime field and it works. I have tried this a couple of times. For some reason it does not like the datetime field. Is that normal? I thought the calendar worked with datetime as well as date.

[digital1]

I have found that if I try to include a time field or anything related to a time this will not work (e.g. I had a separate date field and a separate time field) . Is there a limitation in Xataface that prevents the Event Calendar from functioning with a time field enabled?