search

bobosch / ods_osm

TYPO3 Extension OpenStreetMap
10 stars 22 forks source link

[1.12.0] Missing coordinates in Openlayers mapMarkers #22

Closed dawnbreak closed 8 years ago

dawnbreak commented 8 years ago

In class.tx_odsosm_openlayers.php#L124 it seems like lat and lon are missing.

bobosch commented 8 years ago

Hi! Have you used the update script? Field names in tt_address have changed...

dawnbreak commented 8 years ago

Yes I run the update script. Then I deleted the old columns with the compare database and when I edit the address I also see the coordinates. But in the mapMarker they are empty.

ToelkeStwm commented 8 years ago

the sys_category relations are somehow inverted compared to the old tt_address_group settings. With this change in class.tx_odsosdm_pi1.php Line 216

from

$res=$GLOBALS['TYPO3_DB']->exec_SELECT_mm_query('tt_address.*', 'tt_address', 'sys_category', 'sys_category_record_mm', 'AND sys_category.uid=' . $item . tx_odsosm_div::getWhere('tt_address',$this->cObj));

to $res=$GLOBALS['TYPO3_DB']->exec_SELECT_mm_query('tt_address.*', 'sys_category', 'sys_category_record_mm', 'tt_address', 'AND sys_category.uid=' . $item . tx_odsosm_div::getWhere('tt_address',$this->cObj));

it works here.

ToelkeStwm commented 8 years ago

sorry wrong issue.... but this is also one. :/

bobosch commented 8 years ago

@dawnbreak Does this issue still exists in version 1.12.2 ? @ToelkeStwm Thanks! Please post the next time 30 minutes earlier - I had it just fixed as your message arrived ;-)

dawnbreak commented 8 years ago

The coordinates are there now, but I need a new clean system. Getting several other errors in the javascript console and no map output anymore.