[Plugin: Events Calendar] Unable to view events

Same with me. Events do not show.

Hi.

There’s a problem with the dates when the data is inserted on database. The problem is quite simple to solve. go to the plugin’s folder and open the file ec_db.class.php. Go to line 227 (function addEvent) and change all lines BEFORE $sql = INSERT INTO `$this->mainTable… for this lines:

$postID = is_null($postID) ? “NULL” : “‘$postID'”;
$location = is_null($location) ? “NULL” : “‘$location'”;
$description = is_null($description) ? “NULL” : “‘$description'”;
$startDate = is_null($startDate) ? “NULL” : “$startDate”;
if($startDate!=”NULL”)
$arrFecha = explode(“-“,$startDate);
$startDate=”‘”.$arrFecha[2].”-“.$arrFecha[1].”-“.$arrFecha[0].”‘”;
$endDate = is_null($endDate) ? “NULL” : “$endDate”;
if($endDate!=”NULL”)
$arrFecha = explode(“-“,$endDate);
$endDate=”‘”.$arrFecha[2].”-“.$arrFecha[1].”-“.$arrFecha[0].”‘”;

$linkout = is_null($linkout) ? “NULL” : “‘$linkout'”;
$startTime = is_null($startTime) ? “NULL” : “‘$startTime'”;
$accessLevel = is_null($accessLevel) ? “NULL” : “‘$accessLevel'”;
$endTime = is_null($endTime) ? “NULL” : “‘$endTime'”;

The fix consists in changing the date format (dd-mm-yyyy) for a valid MySQL format (yyyy-mm-dd) using php function explode and arranging the parameters according to MySQL.

That’s it! Now the plugin is working perfect

The problem is not in capturing the event as Events Calendar shows the event once it has been captured.

The problem is that on my webpage, the event cannot be viewed when hovering over the event date. It does not show up.

@fernandopiedra, I did what you said and it worked great!

There’s just one little problem when I post a new event:

Start date is working, DD-MM-YYYY. When I post the event, the page load the wrong year, like:

“Start date: 22-11-2010” take me to November 2022 calendar
“Start date: 18-12-2010” take me to December 2018 calendar
“Start date: 03-06-2010” take me to June 2003 calendar

The plugin create the event on the correct date, just the calendar displayed is wrong. It shows the wrong year and it’s getting the day information to do so.

Do you have any information about it? If you don’t, can you tell me wich version you are using? Thanks.