Report reply Kjell Iver Johansen 6 Posted September 5, 2017 hallo michael.. I know martin A have been in contact with you regarding som errors in my system SELECT * FROM `babble_rooms` LEFT JOIN `core_permission_index` ON core_permission_index.app='babble' AND core_permission_index.perm_type='rooms' AND core_permission_index.perm_type_id=babble_rooms.rooms_id WHERE (( FIND_IN_SET(2,perm_) ) OR perm_='*' ) Unknown column 'perm_' in 'where clause' #0 /home/kjiver/fjellforum.no/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IteratorItera...', Array, true) #1 /home/kjiver/fjellforum.no/system/Db/Select.php(440): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /home/kjiver/fjellforum.no/applications/core/extensions/core/Sitemap/Content.php(208): IteratorIterator->rewind() #4 /home/kjiver/fjellforum.no/system/Sitemap/Sitemap.php(102): IPS\core\extensions\core\Sitemap\_Content->generateSitemap('sitemap_content...', Object(IPS\Sitemap)) #5 /home/kjiver/fjellforum.no/applications/core/tasks/sitemapgenerator.php(35): IPS\_Sitemap->buildNextSitemap() #6 /home/kjiver/fjellforum.no/system/Task/Task.php(248): IPS\core\tasks\_sitemapgenerator->execute() #7 /home/kjiver/fjellforum.no/system/Task/Task.php(217): IPS\_Task->run() #8 /home/kjiver/fjellforum.no/system/Dispatcher/Standard.php(311): IPS\_Task->runAndLog() #9 [internal function]: IPS\Dispatcher\_Standard->__destruct() #10 {main} Quote Share this comment Link to comment
Report reply Michael 263 Posted September 5, 2017 yeah something changed in 4.2.3, so the sitemap generator when it is looking up node's it is expecting the "read" permission to be in the permission map. i'll have it fixed in the next version. Quote Share this comment Link to comment
Report reply Kjell Iver Johansen 6 Posted September 5, 2017 Just now, Michael said: yeah something changed in 4.2.3, so the sitemap generator when it is looking up node's it is expecting the "read" permission to be in the permission map. i'll have it fixed in the next version. Should I switch off site map generator for the moment? Quote Share this comment Link to comment
Report reply Michael 263 Posted September 5, 2017 you can do that, or you can replace the file applications/babble/sources/Rooms/Rooms.php with this one. Rooms.php 1 Quote Share this comment Link to comment
Report reply Kjell Iver Johansen 6 Posted September 5, 2017 46 minutes ago, Michael said: you can do that, or you can replace the file applications/babble/sources/Rooms/Rooms.php with this one. Rooms.php Seems to be gone now thanks for prompt fix 1 Quote Share this comment Link to comment
Report reply Michael 263 Posted September 5, 2017 Changed Status from Pending to ClosedChanged Fixed In to Next Version Quote Share this comment Link to comment
Report reply Michael 263 Posted September 5, 2017 use this one instead, the other one will add an additional field to the permission matrix of rooms if you edit the perms or create a new room. this one fixed that. Rooms.php Quote Share this comment Link to comment