Project

General

Profile

Bug #2374

Search results error

Added by Vasily Bezruchkin over 4 years ago. Updated over 4 years ago.

Status:
Resolved
Priority:
Normal
Target version:
Start date:
February 05, 2016
Due date:
% Done:

100%

Estimated time:

Description

User Warning: Unknown column 'yp.title' in 'where clause' SELECT SQL_CALC_FOUND_ROWS yp.*, cat.`title_alias` `category_alias`, cat.`title` `category_title`, cat.`no_follow`, cat.`num_pages`, acc.`fullname` `account`, loc.`title` `location`, loc.`title_alias` `location_alias` FROM `sbr404_yp_venues` yp LEFT JOIN `sbr404_yp_categories` cat ON(cat.`id` = yp.`category_id` AND cat.`status` = 'active') LEFT JOIN `sbr404_yp_locations` loc ON(loc.`id` = yp.`location_id` AND loc.`status` = 'active') LEFT JOIN `sbr404_members` acc ON(acc.`id` = yp.`member_id`) WHERE cat.`id` IS NOT NULL AND loc.`id` IS NOT NULL AND (acc.`status` = 'active' OR acc.`status` IS NULL) AND yp.`location_id` IN (25,26,27,29,30,31,32,33,4) AND (yp.`description` LIKE '%pizza%' OR yp.`title` LIKE '%pizza%') ORDER BY `sponsored` DESC LIMIT 0, 10 

try to search for pizza in Madrid

History

#1

Updated by Batyr Mackenov over 4 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Fixed in 60f9ab5

Also available in: Atom PDF