Search is creating errors.

@starone
9 years ago
51 posts

I have been having problems for some time. The activity log is showing " invalid order_by criteria in jrCore_db_search_items parameters" where ever a search is being performed. I have updated both the core and the search modules and ran an integrity check and table repair, but still receiving the same error.

Any suggestions?
updated by @starone: 05/12/16 03:56:44AM

@michael
9 years ago
7,772 posts

Give us some steps to try and we can try them out here to see if we get the same issue. If we get the same issue here, then we'll be able to advise on the next steps to take.

Its a matter of figuring out what is causing the problem, then addressing it.

--edit--
The meaning of:

Quote: " invalid order_by criteria in jrCore_db_search_items parameters"

is a search has been requested and the results have been asked for in a particular order

Which is weird because you'd normally order search results in the order of the most relevant to the search query.
updated by @michael: 01/24/16 11:19:00PM

@brian
9 years ago
10,148 posts

This is likely an error in one of your custom templates - if you look in the debug info for the log it will show you the page it being requested on, as well as the search parameters, so you can clearly see what the issue is.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@starone
9 years ago
51 posts

No search results are being returned. I believe this all started when I moved the site to the new VPS. Everything else is working fine so this error is originating when a user performs a search.

Thanks.

@starone
9 years ago
51 posts

Here is the debug errors that are being created:

(2016-01-28T06:53:18-08:00.0.41778200 : 0)-(mem: 12582912)-(pid: 3409)-(ip: 66.87.124.225)-(uri: /you_tube) 
|(PAGINATION QUERY): SELECT COUNT(a.`_item_id`) AS tc FROM jr_jryoutube_item_key a JOIN jr_jryoutube_item_key
pr ON (pr.`_item_id` = a.`_item_id` AND pr.`key` = '_profile_id') WHERE ((a.`key` = 'youtube_title') OR 
(a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_jryoutube_item_key WHERE `key` = 'youtube_title')))
AND a.`_item_id` IN (SELECT yy.`_item_id` FROM jr_jryoutube_item_key yy LEFT JOIN jr_jryoutube_item_key zz ON
(zz.`_item_id` = yy.`_item_id` AND zz.`key` = '_profile_id') WHERE yy.`key` = '_created' AND (zz.`value` NOT
IN('233') OR zz.`value` IS NULL)) AND a.`_item_id` IN (SELECT yy.`_item_id` FROM jr_jryoutube_item_key yy 
LEFT JOIN jr_jryoutube_item_key zz ON (zz.`_item_id` = yy.`_item_id` AND zz.`key` = '_profile_id') WHERE yy.`key` = 
'_created' AND (zz.`value` NOT IN('35','39','40','41','42','43','44','45','46','48','49','50','51','54','55','56','57',
'58','59','61','63','64','65','68','70','72','75','76','82','83','92','102','103','104','105','114','115','116','117',
'118','125','130','133','134','136','139','144','145','146','147','148','149','150','151','152','153','154','155',
'156','157','158','159','160','161','162','163','164','165','166','167','170','171','172','173','174','175','176',
'177','178','179','180','181','182','183','184','185','186','187','188','190','191','193','194','196','198','201',
'202','215','216','218','219','222','223','224','225','226','228','229','230','231','232','234','235','236','237',
'238','239','240','241','242','243','245','246','247','248') OR zz.`value` IS NULL)) AND pr.`value` 
NOT IN(202,218,225,226,230,236,244)

Would this also cause an error in the general site search as to not return results?

@starone
9 years ago
51 posts

Any Ideas??

@michael
9 years ago
7,772 posts

There doesnt seam to be anything wrong with the query, i tried it here and it executed.

Was there any other information in the debug log.

Try it with a different skin, if it works on a different skin, then its likely an issue with the code.

It would be easier to help if you outlined how I can see the issue here for me on a default install other wise im stuck just guessing.

@starone
9 years ago
51 posts

Interesting, that any new additions are showing up in the search. So this tells me that when we moved the site we somehow lost the search indexing. Is there a way to reindex the site? I ran all of the integrity checks and repaired the tables but that did not fix the problem.

@paul
9 years ago
4,335 posts

The 'Rebuild Index' is in the Search module's Tools section.

--
Paul Asher - JR Developer and System Import Specialist

@starone
9 years ago
51 posts

That is what I needed, just did not know where it was. Thank you!

solved Search is creating errors.

Tags