Recurring search error in Activity Log

@iamtimbo
8 years ago
301 posts

I don't have much reason to check the Activity Log, but when I clicked on it by accident earlier, I noticed that every ten minutes (exactly) the following error is showing up:

invalid search criteria in jrCore_db_search_items parameters

Clicking the debug shows this detail:

Array
(
    [0] => jrGallery
    [1] => Array
        (
            [search1] => leigh
            [template] => item_list.tpl
            [order_by] => Array
                (
                    [_created] => random
                )

            [search] => Array
                (
                    [0] => leigh
                    [1] => _profile_id in (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_quota_id' AND `value` IN(1, 3, 4))
                )

            [limit] => 1000000
            [jrseamless_list_function_call_is_active] => 1
            [exclude_jrUser_keys] => 1
            [exclude_jrProfile_keys] => 1
            [exclude_jrProfile_quota_keys] => 1
            [return_keys] => Array
                (
                    [0] => _item_id
                    [1] => _created
                )

            [module] => jrGallery
        )

)

Clearly I have entered something daft somewhere, but I can't find it, and I don't understand why it's happening every ten minutes. It's not related to any user activity on the site, but it does mention a profile ('leigh') that I use a lot for testing, and seems to be related to jrGallery...

Any thoughts on why this might be happening would be much appreciated...
updated by @iamtimbo: 09/08/16 06:33:02AM

@michael
8 years ago
7,714 posts

this part:

 [0] => leigh

It probably should have a location, look more like:

 [0] => gallery_% like leigh

currently is saying "search the leigh" where as it should be saying "search the gallery for anything with leigh in it"

Its probably a jrCore_list call somewhere that looks like this:

{jrCore_list moudle="jrGallery" search1="leigh"}

updated by @michael: 06/03/16 12:05:31AM

@iamtimbo
8 years ago
301 posts

Thanks, Michael - I'll start digging!

@michael
8 years ago
7,714 posts

If you can figure out a way to make it fire consistently then I can help some more.

I'd try open one tab with the activity log open in it, then in another tab click around. keep refreshing the activity log to see if anything new comes up.

If you can identify a page that when refreshed causes that error to fire, then its something on that page.

Then narrow down from there.

@iamtimbo
8 years ago
301 posts

That's a good idea. At the moment, it's just doing it every ten minutes, like this. I'll see if I can force it to happen.

@michael
8 years ago
7,714 posts

Those time slots are too regular. They are all on either a 5 min or a ten min mark. There are 3 ip addresses that repeat over and over.

Turn on the 404 Not found error logger.
ACP -> CORE -> SYSTEM CORE -> GLOBAL CONFIG -> GENERAL -> log 404 not found

That will tell us if its a spam bot throwing weird URLs at your system hoping to find a weak path in.

@iamtimbo
8 years ago
301 posts

I have enabled that setting, and see what it throws up in five or ten minutes....

@iamtimbo
8 years ago
301 posts

Interestingly, there are a lot of icon related 404s to do with modules that @paul has made for me, but nothing that seems related to the recurring search error....

@michael
8 years ago
7,714 posts

He probably didn't put an icon into the modules. You can copy an icon.png from one of the other modules into the location showing if you want to fix that error.

or use the empty one attached to this message.

@michael
8 years ago
7,714 posts

My best guess is that its related to the rotator on the old construction kit.

Its ordering by _item_id random and I think sometimes it might randomly run into an image that doesn't exist.

might be the time to upgrade to the new version?

@iamtimbo
8 years ago
301 posts

It is time!

@michael
8 years ago
7,714 posts

don't freak out if something looks like it went wrong. Put the site into maintenance mode and outline it here in the forums, we'll be around to help.