Hello,
After an upgrade from version 3.x I have this error / message when I add a picture in the gallery
The picture is added in the gallery in spite of the message (!)
When I want to delete the picture I have this message :
SELECT * FROM `ibf_gallery_images` AS `gallery_images` LEFT JOIN `ibf_gallery_albums` AS `gallery_albums` ON image_album_id=album_id WHERE image_category_id=8 AND image_approved=1 AND ( image_album_id = 0 OR album_type NOT IN ( 2, 3 ) ) ORDER BY image_date DESC LIMIT 1 IPS\Db\Exception: Column 'album_id' in on clause is ambiguous (1052)
#0 /home/www/netcoupe/volavoile.net/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*netcoupe2::ne...', Array, false)
#1 /home/www/netcoupe/volavoile.net/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /home/www/netcoupe/volavoile.net/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#3 /home/www/netcoupe/volavoile.net/applications/gallery/sources/Category/Category.php(594): IPS\Db\_Select->first()
#4 /home/www/netcoupe/volavoile.net/applications/gallery/sources/Category/Category.php(571): IPS\gallery\_Category->setLastImage()
#5 /home/www/netcoupe/volavoile.net/system/Content/Content.php(957): IPS\gallery\_Category->setLastComment()
#6 /home/www/netcoupe/volavoile.net/applications/gallery/sources/Image/Image.php(1592): IPS\_Content->logDelete(Object(IPS\Member))
#7 /home/www/netcoupe/volavoile.net/system/Content/Content.php(858): IPS\gallery\_Image->logDelete(NULL)
#8 /home/www/netcoupe/volavoile.net/system/Content/Controller.php(929): IPS\_Content->modAction('delete')
#9 /home/www/netcoupe/volavoile.net/system/Dispatcher/Controller.php(90): IPS\Content\_Controller->moderate()
#10 /home/www/netcoupe/volavoile.net/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#11 /home/www/netcoupe/volavoile.net/applications/gallery/modules/front/gallery/view.php(65): IPS\Content\_Controller->execute()
#12 /home/www/netcoupe/volavoile.net/system/Dispatcher/Dispatcher.php(158): IPS\gallery\modules\front\gallery\_view->execute()
#13 /home/www/netcoupe/volavoile.net/index.php(13): IPS\_Dispatcher->run()
#14 {main}
Thank you for your support,
Best regards,
Frederic