EnglishI have problem with RV Maps & Earth (in PWG 2.4):
When I open map for this category http://foto.valec.info/map.php?/categories/58 I receive this Error message:
syntax error
<pre><br />
<b>Warning</b>: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
SELECT i.id,i.representative_ext,i.name,i.comment,i.path,i.lat,i.lon
FROM pwg_images i INNER JOIN pwg_image_category ON i.id=image_id
WHERE i.lat BETWEEN 53.12 AND 54.64 AND i.lon BETWEEN -7.07 AND -1.97
AND (category_id NOT IN (3,5,8,10,13,15,18,19)) AND category_id IN (58)
GROUP BY i.id
ORDER BY in <b>/array3/apache/data/exot/v/valec.info/www/SUB/foto/include/dblayer/functions_mysql.inc.php</b> on line <b>770</b><br />
</pre><br />
<b>Warning</b>: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in <b>/array3/apache/data/exot/v/valec.info/www/SUB/foto/include/dblayer/functions_mysql.inc.php</b> on line <b>153</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /array3/apache/data/exot/v/valec.
When I open map for any other category (for example http://foto.valec.info/map.php?/categories/57), or map for all categories http://foto.valec.info/map.php?/categories is no problem. I look to SQL tables pwg_images and pwg_image_category, but I don't see any different between entries from cat. 57 and 58.
I have no SQL experiences. Can anybody help
please go to the admin page , manage this album and in the tab photo order, make sure you have at least one field selected if you chose "automatic order"
Offline