Error in gallery catgory

[Saurabh Jain]

https://vidyasagar.guru/gallery/category/3-1

 

SELECT gallery_albums.*, author.* FROM `gallery_albums`  LEFT JOIN `core_members` AS `author` ON author.member_id = gallery_albums.album_owner_id WHERE gallery_albums.album_category_id=4 AND album_type<>4 AND ( gallery_albums.album_type IN(1,2) OR ( gallery_albums.album_type=3 AND ( gallery_albums.album_owner_id=1 OR gallery_albums.album_allowed_access IN (0) ) ) ) AND gallery_albums.album_hidden < 2 AND gallery_albums.album_hidden!=-2 AND gallery_albums.album_category_id IN(1,2,3,4,5) ORDER BY `gallery_albums`.`album_`gallery_albums`.`album_last_img_date`` desc LIMIT 0,25
IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'gallery_albums`.`album_last_img_date`` desc LIMIT 0,25' at line 1 (1064)
#0 /home/cricketi/public_html/system/Db/Select.php(371): IPS\_Db->preparedQuery('SELECT gallery_...', Array, true)
#1 /home/cricketi/public_html/system/Db/Select.php(433): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 [internal function]: IteratorIterator->rewind()
#4 /home/cricketi/public_html/system/Helpers/Table/Content.php(289): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator))
#5 /home/cricketi/public_html/system/Helpers/Table/Table.php(475): IPS\Helpers\Table\_Content->getRows(Array)
#6 /home/cricketi/public_html/applications/gallery/modules/front/gallery/browse.php(183): IPS\Helpers\Table\_Table->__toString()
#7 /home/cricketi/public_html/applications/gallery/modules/front/gallery/browse.php(96): IPS\gallery\modules\front\gallery\_browse->_category(Object(IPS\gallery\Category))
#8 /home/cricketi/public_html/system/Dispatcher/Controller.php(96): IPS\gallery\modules\front\gallery\_browse->manage()
#9 /home/cricketi/public_html/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute()
#10 /home/cricketi/public_html/applications/gallery/modules/front/gallery/browse.php(48): IPS\Content\_Controller->execute()
#11 /home/cricketi/public_html/system/Dispatcher/Dispatcher.php(142): IPS\gallery\modules\front\gallery\_browse->execute()
#12 /home/cricketi/public_html/index.php(12): IPS\_Dispatcher->run()
#13 {main}

 

 

[Saurabh Jain]

urgent help needed

[Adriano Faria]

You won't get help for this here. Submit a ticket.

[Saurabh Jain]

it was resolved..............

but today when I created a gallery in clubs...

the error again appeared --  it means we need to look errors in core and then also in clubs

I wish staff can look into it on week end as well