Issue: Unknown MYSQL column on projectsearch.pp

  1. issueid=362 04-11-2015 10:51 AM
    Cadellin
    Number of reported issues by Cadellin:
    Unknown MYSQL column on projectsearch.pp
    Unknown column 'projectcategory.title' in 'field list' in projectsearch.php

    Code:
    Database error in vBulletin 4.2.2:
    
    Invalid SQL:
    
    			SELECT issuesearchresult.groupid, IF(issuesearchresult.groupid = '0', 'Unknown', projectcategory.title) AS grouptitle, COUNT(*) AS count
    			FROM ex_pt_issuesearchresult AS issuesearchresult
    			LEFT JOIN ex_pt_projectcategory AS projectcategory ON (projectcategory.projectcategoryid = CAST(issuesearchresult.groupid AS UNSIGNED))
    			WHERE issuesearchresult.issuesearchid = 18
    			GROUP BY issuesearchresult.groupid;
    
    MySQL Error   : Unknown column 'projectcategory.title' in 'field list'
    Error Number  : 1054
    Request Date  : Saturday, April 11th 2015 @ 02:49:16 AM
    Error Date    : Saturday, April 11th 2015 @ 02:49:17 AM
    Script        : http://www.example.com/projectsearch.php?do=searchresults&searchid=18
    Referrer      : http://www.example.com/project.php?projectid=4
    IP Address    : X.X.X.X
    Username      : User
    Classname     : vB_Database
    MySQL Version : 5.5.42-cll
Issue Details
Issue Number 362
Project Project Tools
Category Show Stopper
Status Fixed
Priority 2
Affected Version 2.2.1
Fixed Version 2.3.0
Milestone v2.3.0
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