All Events don't display

More
9 years 1 week ago #28073 by lemiran
Hi everyone
I have your geommunity module installed on my J3 site it seems to work well but in reality it doesn't display all the upcoming events.
Here is the map : yayos.fr/
Here are alle the events to come : yayos.fr/calendrier-des-sorties-sportives-yayos

Is there a parameter that i didn't see?

Thank you
Regards
Miran

Please Log in or Create an account to join the conversation.

More
9 years 1 week ago #28111 by lemiran
Replied by lemiran on topic All Events don't display
Bonjour
Est-ce que mes explications sont claires ou voulez-vous les mêmes mais en français?

Cordialement
Miran

Please Log in or Create an account to join the conversation.

More
9 years 1 week ago #28113 by nordmograph
Hello

Oui, merci, mais l'anglais est préféré dans ce forum.

If I look at the query to get events from the database, we get
- All published events in the area we're looking at and with a start date > now.
Do you think this last parameter is guilty ?
If so try this:

open components/com_geommunity3js/models/eventmarkers.php on line 26
and replace startdate by enddate

Let me know if it solves your issue.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

More
9 years 1 week ago #28114 by lemiran
Replied by lemiran on topic All Events don't display
hi thank you for your help

i now have this in my eventmarkers.php :

<?php
/*
* @component com_geommunity3js
* @copyright Copyright (C) 2010-2014 Adrien ROUSSEL Nordmograph.com
* @license GNU/GPL Version 3
* @Website : www.nordmograph.com/extensions
*/
defined('_JEXEC') or die('Restricted access');
jimport('joomla.application.component.modelitem');
class Geommunity3jsModelEventmarkers extends JModelLegacy
{
protected $markers;
public function getEventmarkers()
{
$db = JFactory::getDBO();
$user = JFactory::getUser();
$jinput = JFactory::getApplication()->input;
$mapid = $jinput->get('mapid');
$a = $swLat = $jinput->get('swLat');
$b = $swLng = $jinput->get('swLng');
$c = $neLat = $jinput->get('neLat');
$d = $neLng = $jinput->get('neLng');
$condition1 = $a < $c ? "latitude BETWEEN $a AND $c":"latitude BETWEEN $c AND $a";
$condition2 = $b < $d ? "longitude BETWEEN $b AND $d":"longitude BETWEEN $d AND $b";
$q ="SELECT id , title , latitude , longitude
FROM #__community_events
WHERE published='1' AND enddate>=NOW()
AND ( $condition1 ) AND ( $condition2 ) ";
$db->setQuery($q);
$markers = $db->loadObjectList();
return $markers;
}

}

But the same problem...

Please Log in or Create an account to join the conversation.

More
9 years 1 week ago #28138 by lemiran
Replied by lemiran on topic All Events don't display
hi i deactivated the map from the front page because it doesn't work.

it is visible on this page : yayos.fr/test
I still have the same problem only 2 events from the database display on the map :(

Please Log in or Create an account to join the conversation.

More
9 years 1 week ago - 9 years 1 week ago #28139 by nordmograph
According to this query, there are 3 reasons for an event not being displayed on the map:
- It won't load if it is not published (not relevent)
- It won't load if is finished (not relevent)
- it won't load if it is not in the viewport (not relevent)
- it won't load if it doesn't have coordinates (only reason left)

Can you make sure other events actually truely have coordinates
(not only address but also coordinates)

Let me know

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.
Last edit: 9 years 1 week ago by nordmograph.

Please Log in or Create an account to join the conversation.

Time to create page: 0.352 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.