I have SQL imported about 200+ records to the "event" table in the appropriate format, yet it is not showing on Calendar. I added these holidays as events, verses holidays, so there are no recurrence.
I only have 1 calendar, the default one.
Is there a table or index other then "event" that needs updated?
Here are record examples in CSV. Note that I have verified the records and they are identical to a manually added event, except for the index column of course.
Thank you.
I only have 1 calendar, the default one.
Is there a table or index other then "event" that needs updated?
Here are record examples in CSV. Note that I have verified the records and they are identical to a manually added event, except for the index column of course.
Code:
"52";"1";"Christmas Day";"Christmas Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1198562400";"0" "53";"1";"Christmas Eve";"Christmas Eve";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1198476000";"0" "54";"1";"Columbus Day";"Columbus Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1191819600";"0" "55";"1";"Easter Day";"Easter Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1176008400";"0" "56";"1";"Election Day";"Election Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1194328800";"0" "57";"1";"Father's Day";"Father's Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1182056400";"0" "58";"1";"Flag Day";"Flag Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1181797200";"0" "59";"1";"Groundhog Day";"Groundhog Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1170396000";"0" "60";"1";"Halloween";"Halloween";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1193806800";"0" "61";"1";"Independence Day";"Independence Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1183525200";"0" "62";"1";"Labor Day";"Labor Day";"1";"0";;"1";"a:0:{}";"1";"1151670856";"-5";"1188795600";"0"
Comment