query did not work in smartfaq

 XOOPS  21 Responses »
Jun 202010
 
  • Open ‘/modules/smartfaq/class/faq.php’,
  • Position to line 1311, 
    $grantedFaq->add(new Criteria('faqid', "(".implode(',', $faqsGranted).")", 'IN'), 'OR');

    ,

  • Change these line to 
    $grantedFaq->add(new Criteria('faq.faqid', "(".implode(',',  $faqsGranted).")", 'IN'), 'OR');

    ,

  • Position to line 1408, 
    $sql .= ' AND faqid IN ('.implode(',', $items).')';
  • Change these line to 
    $sql .= ' AND faq.faqid IN ('.implode(',', $items).')';

My System Overview:

XOOPS Version: 2.4.5 RC3
PHP Version: 5.2.13
SmartFAQ Version: 1.0.8

Taken from: http://www.xoops.org/modules/newbb/viewtopic.php?topic_id=64655