Jump to content

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


Go to solution Solved by Marc Stridgen,

Recommended Posts

Hello,

After an upgrade from version 3.x I have this error / message when I add a picture in the gallery

PICT-1.png.e5b1a47f3643adc31fc0ccf3c0f6b1ce.png

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}

 

PICT-2.thumb.png.39bd7b39cbf522d1847a9cb8bd976031.png

Thank you for your support,

Best regards,

Frederic

 

Link to comment
Share on other sites

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

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...