[Gallery] "Colum 'album_id' in on clouse is ambigous"

[jffuchs]

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

 

[Marc]

Have you tested this with all 3rd party items disabled first of all?

[jffuchs]

Hello,

Same issue with the 3rd party app disable (Advanced Custom Widgets Enabled 1.0.7 By Taman )

Best regards,

[Marc]

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. 

 

[jffuchs]

Hello,

I have updated the "Stored Access Information"

Best regards,

[Marc]

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

[jffuchs]

Merci, 👍

[Marc]

I see Daniel managed to get you sorted there. Please do let us know if you have any further issues 🙂