WordPress.org

1. jeannevermaak
   Member
   Posted 1 year ago #

   I've recently installed Events Calendar 6.7.5. When I create an event, it does not reflect on the calendar. Only the posts posted on the specific date are reflected.

2. gizmobandit
   Member
   Posted 1 year ago #

   Same with me. Events do not show.

3. fernandopiedra
   Member
   Posted 1 year ago #

   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

4. jeannevermaak
   Member
   Posted 1 year ago #

   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.

5. leocg
   Member
   Posted 1 year ago #

   @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.

Topic Closed

This topic has been closed to new replies.