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