Issues with the Calendar
Archived from the Xataface Users forum.
digital1 — Wed Nov 03, 2010 9:44 am
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 — Wed Nov 03, 2010 11:35 am
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 — Wed Nov 03, 2010 1:00 pm
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 — Wed Nov 03, 2010 3:08 pm
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 — Thu Nov 04, 2010 4:10 am
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 — Thu Nov 04, 2010 6:57 am
Yes that would help
digital1 — Thu Nov 04, 2010 7:40 am
I sent you the create code.
digital1 — Thu Nov 04, 2010 8:16 am
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 — Thu Nov 04, 2010 9:06 am
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 — Wed Nov 10, 2010 12:35 pm
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?