jffuchs Posted February 7, 2022 Share Posted February 7, 2022 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 1IPS\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 Link to comment Share on other sites More sharing options...
Marc Posted February 7, 2022 Share Posted February 7, 2022 Have you tested this with all 3rd party items disabled first of all? Link to comment Share on other sites More sharing options...
jffuchs Posted February 7, 2022 Author Share Posted February 7, 2022 Hello, Same issue with the 3rd party app disable (Advanced Custom Widgets Enabled 1.0.7 By Taman ) Best regards, Link to comment Share on other sites More sharing options...
Marc Posted February 7, 2022 Share Posted February 7, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
jffuchs Posted February 7, 2022 Author Share Posted February 7, 2022 Hello, I have updated the "Stored Access Information" Best regards, Link to comment Share on other sites More sharing options...
Marc Posted February 7, 2022 Share Posted February 7, 2022 I have escalated your topic to a ticket to be looked at by one of our developers. It looks like there may be a column there which has been left over from 3.x, but want to make sure that is the case Link to comment Share on other sites More sharing options...
jffuchs Posted February 7, 2022 Author Share Posted February 7, 2022 Merci, 👍 Marc 1 Link to comment Share on other sites More sharing options...
Solution Marc Posted February 9, 2022 Solution Share Posted February 9, 2022 I see Daniel managed to get you sorted there. Please do let us know if you have any further issues 🙂 SeNioR- 1 Link to comment Share on other sites More sharing options...
Recommended Posts