Issue: Invalid MySQL vb\legacy\issuenote.php

  1. issueid=356 03-24-2015 09:00 PM
    Cadellin
    Number of reported issues by Cadellin:
    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.
Issue Details
Issue Number 356
Project Project Tools
Category Functionality
Status Fixed
Priority 3
Affected Version 2.2.1
Fixed Version (none)
Milestone v2.2.2
Users able to reproduce bug 0
Users unable to reproduce bug 0
Assigned Users Pitchoune
Tags (none)




  1. Note:
    This issue contains some replies but it seems you don't have the permission to show them. To see them, you should log in.

    Once logged in, if the administrator decided it, you can still be able to not see replies.
+ Reply