Descrition Search Error

[bgordon]

Whenever I populate the keyword field for a search (description) it get the following SQL errors showing up at the top of the page... Any ideas?

Notice: Query failed: Column 'description' in where clause is ambiguous SQL: SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country, u.extra, u.extra2, u.extra3, c.name FROM class_listings AS p LEFT JOIN class_users AS u ON p.owner = u.id LEFT JOIN class_categories AS c ON p.section = c.id WHERE 1=1 AND p.id IN (8,7,9,10,17,18,15,14,13,12,11,23,26,27,28,24,25,3 3,34,30,29,78,77,76,75,74,73,72,71,70,69,68,67,66, 65,64,63,62,84,85,241,240,239,238,237,236,226,225, 224,223,222,221,220,219,218,217,216,215,214,213,21 2,211,210,209,208,207,206,205,204,203,202,201,200, 199,198,197,196,195,194,193,192,191,190,189,188,18 7,186,185,184,183,182,181,180,179,178,177,176,175, 242,243,244,245,246,247,248,249,250,251,252,253,26 3,412,411,410,409,408,407,406,405,404,403,402,401, 400,399,398,397,396,395,394,393,392,391,390,389,38 8,387,386,385,384,383,382,381,380,379,378,377,376, 375, in /../includes/classes/database/mysql.php on line 140

Notice: Query failed: Column 'description' in where clause is ambiguous SQL: SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country, u.extra, u.extra2, u.extra3, c.name FROM class_listings AS p LEFT JOIN class_users AS u ON p.owner = u.id LEFT JOIN class_categories AS c ON p.section = c.id WHERE 1=1 AND p.id IN (8,7,9,10,17,18,15,14,13,12,11,23,26,27,28,24,25,3 3,34,30,29,78,77,76,75,74,73,72,71,70,69,68,67,66, 65,64,63,62,84,85,241,240,239,238,237,236,226,225, 224,223,222,221,220,219,218,217,216,215,214,213,21 2,211,210,209,208,207,206,205,204,203,202,201,200, 199,198,197,196,195,194,193,192,191,190,189,188,18 7,186,185,184,183,182,181,180,179,178,177,176,175, 242,243,244,245,246,247,248,249,250,251,252,253,26 3,412,411,410,409,408,407,406,405,404,403,402,401, 400,399,398,397,396,395,394,393,392,391,390,389,38 8,387,386,385,384,383,382,381,380,379,378,377,376, 375, in /../includes/classes/database/mysql.php on line 140

[Lhotch]

68C version? Template? Are you using a 3rd party search mod?

[Eric Barnes]

Either a module is altering this query or you have custom changes. The class_categories AS c is not part of the original query that comes stock with the script.

[bgordon]

Screwed up listings.php... don't have any change log for it, so it must have been misadventure... restored from the master copy and all is well... false alarm Thanks for the prompt replies though!

[juven14]

This is correct, something is adding a join and the default class isn't coded to handle a join with another table that contains a discription, title, or id.

PHP Code:

$where .= " AND (id LIKE '%".$trimm."%' OR title LIKE '%".$trimm."%' OR description LIKE '%".$trimm."%')"; 


I can't think of any of our products that alter the query in this manner, if you create a support ticket in our ticket system I can try and track down the cause of the issue for you. https://www.templatecodes.com/support

[bgordon]

Originally Posted by Eric Barnes

Either a module is altering this query or you have custom changes. The class_categories AS c is not part of the original query that comes stock with the script.

I know what it was now...

Somewhere on the forums, there was a code snipped that you guys provided to allow the 'category' and some extra fields to be showable in the view listings...

I recall putting that snippet in my listings.php now and never noticed that it broke the keyword search.

That being said, I will try to find that posting again, but I wonder if you could provide some compatible code to make that available again... I have some logic in my showlistings template that conditionally shows the category and a small graphic if one of my extra fields contains a certain value.

Pretty sure this is all standard in 4.10 (I am 4.09) so maybe this would be the time to upgrade...

Your thoughts on this?