Ajax-event-calendar 0.9.8.1 event date problems

I forgot to mention the address of the site:
https://bruno-mazier dot heb3 dot org/calendrier-2/

Another funny thing is the date of the event on the 10th of august is showed as
1 January 1970

Any clues?

Same problem for me (blog not in production.) I hope it will be corrected soon (using WP-FR and FR variables too.)

First, thank you for the compliment.
Now to the crux of the matter:
While I’m no expert in database administration, I’ll say two things:
1. in the next release of the plugin I have set database encoding for plugin tables to UTF8 – while I don’t believe the encoding is causing the date issue, as soon as I release the next patch, install it and let me know if it solved the problem.
2. the plugin installs and uses only two tables: wp_aec_event and wp_aec_event_category – so my plugin will only make changes to those tables
3. January 1 1970 is what’s known as the epoch, the beginning of the unix timestamp. Simply put, PHP and mysql show this date when they receive an input date that is invalid.

If you can wait a little bit, I’ll have the update out sometime today – I hope.

Eran

Great ??

Hint 1 : It seems to bug only when the “whole day” checkbox is selected. Even for multi days events.
Hint 2 : the calendar default date when the box popup is in 1970, I don’t know if it’s normal (I’m new to the plugin :/)

Hi!
First, thanks for this GREAT plugin Evan.

I got the same problem, using WP-FR and FR too and got

Thursday 1 January 1970
0 h 00 min – 0 h 00 min

For an events going to friday 22, jully
Here :
https://img695.imageshack.us/img695/2950/captureeventcalendar1.jpg

and a missing translation here :
https://img10.imageshack.us/img10/5974/captureeventcalendar2.jpg

@ Cafeine : For me the bug still even when i selected hours and doesn’t change if i check the “whole day”

Thanks for your answer, Eran and Cafeine for confirming there is an issue.

to 1. UTF-8 shouldn’t be the origin of the problem.
to 2 Ok I would pay attention to these two tables then and see what is there
to 3 Any Idea why the time stamp would be invalid?

here the content of wp_aec_event

id	bigint(20)		UNSIGNED	Nein	Kein	auto_increment
	user_id	int(10)		UNSIGNED	Nein	Kein
	title	varchar(100)	utf8_unicode_ci		Nein	Kein
	start	datetime			Nein	Kein
	end	datetime			Nein	Kein
	allDay	tinyint(1)		UNSIGNED	Ja	0
	category_id	tinyint(4)		UNSIGNED	Nein	Kein
	description	varchar(1000)	utf8_unicode_ci		Ja	NULL
	link	varchar(100)	utf8_unicode_ci		Ja	NULL
	venue	varchar(100)	utf8_unicode_ci		Ja	NULL
	address	varchar(100)	utf8_unicode_ci		Ja	NULL
	city	varchar(50)	utf8_unicode_ci		Ja	NULL
	state	char(2)	utf8_unicode_ci		Ja	NULL
	zip	varchar(10)	utf8_unicode_ci		Ja	NULL
	contact	varchar(50)	utf8_unicode_ci		Ja	NULL
	contact_info	varchar(50)	utf8_unicode_ci		Ja	NULL
	access	tinyint(1)		UNSIGNED	Ja	0
	rsvp	tinyint(1)		UNSIGNED	Ja	0

here the content of wp_aec_event_category

Feld	Typ	Kollation	Attribute	Null	Standard	Extra	Aktion
	id	tinyint(4)		UNSIGNED	Nein	Kein	auto_increment
	category	varchar(25)	utf8_unicode_ci		Nein	Kein
	bgcolor	char(6)	utf8_unicode_ci		Nein	Kein
	fgcolor	char(6)	utf8_unicode_ci		Nein	Kein

For both of them I resetted the value of collation on utf-8_unicode_ci myself instead of latin_swedish_ci.

Thanks for being so reactive.

I guess the fix is harder to find than expected? ??

To be honest, I haven’t had a chance to look into this particular issue as yet. I will give it attention next week and if all things gel, I should have an update by end of week.

Eran

Ok, thx. I built a blog for friends just to use it tbh (they share a plane ?? ) and i hope to tell them they can use it asap ??

Thx again for that great tool and I hope it will not be too hard to fix.

Hello Eran,

any news from the coming patch/update?
thank you to maintain the best calendar for wordpress till now.

I hope the fix is not that hard to find and implement.

News on the patch/update

Thanks A LOT ??

Awesome \o/

Eran thank you very much for the fix and long live the AEC.