Fatal error при использовании tag=CURRENT_ITEM_TAG
Posted: Thu Feb 27, 2014 12:04 pm
51 Build 201402241258
при выводе related galleries с тегом tag=CURRENT_ITEM_TAG выдает вместо галлереи:
Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1052 (Column 'gallery_md5' in where clause is ambiguous) (db_link) in query SELECT DISTINCT(g.id), g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id JOIN rot_gal2tag as t ON t.gallery_md5 = g.gallery_md5 WHERE g.status = 1 AND g.rgroup != 0 and gs.best_thumb = 'yes' and gs.group_id = '0' AND gallery_md5 IN ('7669d6caac00e6ca7c9d1e0016588360','9af36d36c86ee10b9e332916facc7863','bdf76454d5fd5805eca1aee2771f5e77','01cdf89a72f27c3fd2b349fe5333b135','384a640ff764dbdb9714d1f45a7e6552','4a3c2937e23927552d97e3569d427476','daab2fd1f0dd425fefad6651c8b827d5','3931246aa065caee2f6df4a02a2e8c21','25d83560d92a1ebea57d98660f7a36f9','88f66f2a9ff674210c481f29ab39e0d5','acdcaea53c3fbda01c6b007e9fa85946','d0b23bdcb3736f55ecd0f4abfb355b51','13959d118d8a1fb096f053e67c6031d8','5ca759c3987db8087ddae9881ff73d45','ee551fa99f271 in /home/admin/domains/domain.com/public_html/scj/includes/db_modules/mysql.php on line 62
в настройках 'Related' type: by all tags
если ставим sponsor=CURRENT_ITEM_SPONSOR или group=CURRENT_ITEM_GROUP
то все работает нормально
при выводе related galleries с тегом tag=CURRENT_ITEM_TAG выдает вместо галлереи:
Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1052 (Column 'gallery_md5' in where clause is ambiguous) (db_link) in query SELECT DISTINCT(g.id), g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id JOIN rot_gal2tag as t ON t.gallery_md5 = g.gallery_md5 WHERE g.status = 1 AND g.rgroup != 0 and gs.best_thumb = 'yes' and gs.group_id = '0' AND gallery_md5 IN ('7669d6caac00e6ca7c9d1e0016588360','9af36d36c86ee10b9e332916facc7863','bdf76454d5fd5805eca1aee2771f5e77','01cdf89a72f27c3fd2b349fe5333b135','384a640ff764dbdb9714d1f45a7e6552','4a3c2937e23927552d97e3569d427476','daab2fd1f0dd425fefad6651c8b827d5','3931246aa065caee2f6df4a02a2e8c21','25d83560d92a1ebea57d98660f7a36f9','88f66f2a9ff674210c481f29ab39e0d5','acdcaea53c3fbda01c6b007e9fa85946','d0b23bdcb3736f55ecd0f4abfb355b51','13959d118d8a1fb096f053e67c6031d8','5ca759c3987db8087ddae9881ff73d45','ee551fa99f271 in /home/admin/domains/domain.com/public_html/scj/includes/db_modules/mysql.php on line 62
в настройках 'Related' type: by all tags
если ставим sponsor=CURRENT_ITEM_SPONSOR или group=CURRENT_ITEM_GROUP
то все работает нормально
