Invalid MySQL vb\legacy\issuenote.php
Invalid MySQL breaks search for users when PT permissions granted
There appear to be two typos in vb\legacy\issuenote.php line 118 and line 132
Line 118:
Code:
$select[] = 'userfield.*, userfieldtext.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid';
userfieldtext.* should instead be usertextfield.* to match line 121.
Line 132:
Code:
$joins[] = 'LEFT JOIN ' . TABLE_PREFIX . 'customavatar AS customavatar ON (customavatar.userid = post.userid)';
post.userid is invalid and I suspect should instead be user.userid
As is - this issue breaks the forum search if issues are included in the search.