search

Piwigo / piwigo-openstreetmap

OpenStreetMap integration for Piwigo
http://piwigo.org/ext/extension_view.php?eid=701
GNU General Public License v3.0
35 stars 35 forks source link

Unknown column 'category_id' #28

Closed quovadit closed 10 years ago

quovadit commented 10 years ago

When clicking on 'Show all' as normal user/guest I get a blank white page with the following error-message:

Warning:  [mysql error 1054] Unknown column 'category_id' in 'where clause'
SELECT  `id`, `latitude`, `longitude` 
FROM piwigo_images 
WHERE `latitude` IS NOT NULL AND `longitude` IS NOT NULL 
AND `latitude` > 48.x AND `latitude` < 48.x
AND `longitude` > 16.x AND `longitude` < 16.x

 AND (category_id NOT IN (...)

If I am logged in as webmaster/admin there is no error at all and the pictures are shown correctly as virtual album.

Do I have to update db? I have category_id in table 'image_category', not in 'images'

xbgmsharp commented 10 years ago

I do believe commit ad6f4465e5 from 2 weeks ago fixed that issue. I will test as normal user/guest the 'Show all' feature.

xbgmsharp commented 10 years ago

Just test and the fixed was on local dev branch. Please test using the latest master revision.

quovadit commented 10 years ago

it works now, thanks a lot!

xbgmsharp commented 10 years ago

Great thanks for the feedback.