Geotagging Pane didn't show

[jatzoo]

Hi,

I have:
- published and authorized category with images and geo settings (longitude, latitude, geo title)
- 'Display Geotagging (Category)' to 'Yes' in: 'Control Panel' -> 'Misc'
- setting widht (400) and height (500) map for geotagging pane

But didn't see geotagging pane. Can see only pane for 'Ratting', 'Comments' and 'Statistics'.
I can only see google maps in general view when set 'Display Geotagging (Categories)' to 'Yes'.

Tested on:
- Joomla 2.5.6 (multilingual - default English language)
- Phoca Gallery 3.2.1
- default Joomla templates

Please help...

[eltjavs]

Hello, i have the exact same problem, i have tried, i think all possible settings, but geotag pane wont show.

Esben

[Jan]

Hi, did you set the geotagging (displaying maps) for category (not only for images)?

Now I see it, it is related to SQL queries optimization, will be fixed in next release.

Quick fix:

go to:

components\com_phocagallery\models\category.php

cca line: 204 and change

FROM:

Code: Select all

$query = 'SELECT c.id, c.title, c.alias, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc,' .

TO:

Code: Select all

$query = 'SELECT c.id, c.title, c.alias, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.description, ' .

Thank you, Jan

[jatzoo]

Thank You, now works ok

[Jan]

Ok

[Henni]

Hi,

sorry for pushing this topic up again, but I think I find a bug, which is very simular to this one. I had some troubles with the meta description und meta keys on the category pages (they weren't shown, only the default phocagallery meta data which I entered in the global phoca configuration was displayed). After debugging the phoca gallery code for a while, I noticed in my phoca gallery installation (3.2.1) that the attributes metadesc and metakey are also missing in this SQL query. In my installation the query in components\com_phocagallery\models\category.php
looks like this:

Code: Select all

'SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.access,' . ...

I corrected it for me so that now the correct meta description und meta keys are shown in my html sourcecode. So if anybody else has trouble with the meta description and meta keys an categories just add the attributes c.metakey and c.metadesc to the query

best regards
Hendrik

[Jan]

Hi, thank you for this info.

[Jan]

Fixed in 3.2.2