Fotos
categories.php 96 executeQuery () -- /var/www/vhosts/kainstobbe.nl/httpdocs/modules/categories/
albums.php 261 setHierarchicalCategories () -- /var/www/vhosts/kainstobbe.nl/httpdocs/modules/albums/
item.php 330 renderContent () -- /var/www/vhosts/kainstobbe.nl/httpdocs/modules/items/
defaultcontent.php 30 renderAlbumItem () -- /var/www/vhosts/kainstobbe.nl/httpdocs/views/kainstobbe/modules/content/
content.php 953 include_once () -- /var/www/vhosts/kainstobbe.nl/httpdocs/modules/content/
content.php 9 renderContent () -- /var/www/vhosts/kainstobbe.nl/httpdocs/actions/
index.php 243 include_once () -- /var/www/vhosts/kainstobbe.nl/httpdocs/
MySQL error 1055: Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'kainstobbe_nl_kainstobbe.categorydivisions.divisionId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
When executing:
SELECT c.*
FROM categories c, categorydivisions
WHERE (EXISTS (SELECT * FROM categorydivisions WHERE categorydivisions.categoryId = c.categoryId AND categorydivisions.divisionId = 1))
AND categoryType = "2"
AND c.status=1
GROUP BY c.categoryId
ORDER BY parentCategoryId, sort, divisionId, insertTimeStamp DESC