blog documentation FAQ followers forum marketplace services youtube

solved Activity Log Help

The Jamroom Network » Forum » Using Jamroom » Page » Activity Log Help
Dazed
Dazed
@dazed
8 years ago
1,022 posts
I am seeing this error appear in my activity log many times but i have no idea how to fix. It looks like an invalid query. I am not sure why the call is for "not in" which seems like a bit of a performance issue.

Anyway any ideas?
errormsg.jpg
errormsg.jpg  •  284KB


updated by @dazed: 04/01/17 07:01:01PM
douglas
@douglas
8 years ago
2,791 posts
@dazed can you send use the site URL and admin access.

I can tell you that the gallery_title_url and profile_id are not getting set in whatever function is being used. Can't tell much more without access to the actual page (. . . sos-band/action) and template that is causing the error.

Thanks!


--

Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos
brian
@brian
8 years ago
10,148 posts
This tells you the page that was access is:

/sos-band/action

Which lines up with the "item_index.tpl" for the Timeline module - i.e. jrAction/templates/item_index.tpl - OR if you have overridden it in your skin it will be skins/SkinName/jrAction_item_index.tpl.

You can see here that the core has been told to search for a "gallery_title_url" that is missing a search value (i.e. there is nothing AFTER the equal sign).


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Dazed
Dazed
@dazed
8 years ago
1,022 posts
ok this makes a little sense but I did a search on "gallery" in the jrAudio templates with no luck. I did a search for "gallery_title_url" in the skins and came up empty also. So could this be a module template? I did not change any of those.

I had to do some shuffling of templates here because there was nothing in place for artists to allow/disallow downloads of their music. Let me ask you guys, how is the best way to add conditional statements for downloads when all that is displayed is:

                    <div class="block_config">
                        {jrCore_item_list_buttons module="jrAudio" field="audio_file" item=$item}
                    </div>

My code looks like the below that I pulled from PJ.

{jrCore_module_url module="jrAudio" assign="murl"}
{if isset($_items)}

    {foreach from=$_items item="item"}

    <div class="item">
        <div class="container">
            <div class="row">

                <div class="col2">
                    <div class="block_image" style="position:relative">
                        <a href="{$jamroom_url}/{$item.profile_url}/{$murl}/{$item._item_id}/{$item.audio_title_url}">{jrCore_module_function function="jrImage_display" module="jrAudio" type="audio_image" item_id=$item._item_id size="xlarge" crop="auto" class="iloutline img_scale" alt=$item.audio_title width=false height=false}</a>
                        <div style="position:absolute;bottom:8px;right:5px">
                            {if $item.audio_active == 'on' && $item.audio_file_extension == 'mp3'}
                                {jrCore_media_player type="jrAudio_button" module="jrAudio" field="audio_file" item=$item}
                            {else}
                                 
                            {/if}
                        </div>
                    </div>
                </div>

                <div class="col7">
                    <div class="p5" style="overflow-wrap:break-word">
                        <h2><a href="{$jamroom_url}/{$item.profile_url}/{$murl}/{$item._item_id}/{$item.audio_title_url}">{$item.audio_title}</a></h2><br>
                        <span class="info">{jrCore_lang module="jrAudio" id="31" default="album"}:</span> <span class="info_c"><a href="{$jamroom_url}/{$item.profile_url}/{$murl}/albums/{$item.audio_album_url}">{$item.audio_album}</a></span><br>
                        <span class="info">{jrCore_lang module="jrAudio" id="12" default="genre"}:</span> <span class="info_c">{$item.audio_genre}</span><br>
                        {jrCore_module_function function="jrRating_form" type="star" module="jrAudio" index="1" item_id=$item._item_id current=$item.audio_rating_1_average_count|default:0 votes=$item.audio_rating_1_count|default:0}
                    </div>
                </div>

                <div class="col3 last">
                    <div class="block_config">
					{if $item.audio_dj_download == 'on' && (jrUser_is_admin() || (jrUser_is_logged_in() && $_user.profile_quota_id == $_conf.paDJDownload_dj_quota))}
		<div class="add_to_cart_section" title="DJ Download"><span class="add_to_cart_price">Mix DJ</span><a href="{$_conf['jrCore_base_url']}/audio/djdownload/audio_file/{$item._item_id}">{jrCore_icon icon="download" }</a></div>
		{/if}
			    <a href="{$jamroom_url}/{$item.profile_url}/{$murl}/{$item._item_id}/{$item.audio_title_url}" title="Review Song">{jrCore_icon icon="pen"}</a>
                            {if isset($item.audio_file_item_price) && $item.audio_file_item_price > 0}
                                {jrCore_module_function function="jrFoxyCart_add_to_cart" module="jrAudio" field="audio_file" item=$item}
                            {elseif $_conf.jrAudio_block_download != 'on' &&  $item.audio_downloadable == 'on'|| $item.audio_file_item_price == '0'}
                                <div class="add_to_cart_section" title="Free Download"><span class="add_to_cart_price">Free</span><a href="{$jamroom_url}/{$murl}/download/audio_file/{$item._item_id}">{jrCore_icon icon="download"}</a></div>
                            {/if}
							{jrCore_item_update_button module="jrAudio" profile_id=$item._profile_id item_id=$item._item_id}
                            {jrCore_module_function function="jrPlaylist_button" playlist_for="jrAudio" item_id=$item._item_id}

								 {jrCore_item_delete_button module="jrAudio" profile_id=$item._profile_id item_id=$item._item_id}
                        
                    
					
					
					
					
					
					</div>
                </div>

            </div>
        </div>
    </div>

    {/foreach}

{/if}

updated by @dazed: 12/31/16 09:38:32AM
michael
@michael
8 years ago
7,719 posts
Dazed:..... makes a little sense but I did a search on "gallery" in the jrAudio templates with no luck. I did a search for "gallery_title_url" in the skins and came up empty also.....
You wont find other modules prefixes in the jrAudio module. We try to keep all modules separate, so if you're looking for a 'gallery_???????' then it will either be in the jrGallery module or in the skin.


--
With 
{jrCore_item_list_buttons module="jrAudio" field="audio_file" item=$item}
its asking for "Give me all the buttons that should go here".

You're wanting some specific setup, so you'll want to explode that out so you have finer grained control.

Use:
{jrCore_item_create_button module="jrAudio" view="create" profile_id=$_profile_id title="Create Audio"}


Added some docs here:

Docs: "{jrCore_item_list_buttons}"
https://www.jamroom.net/the-jamroom-network/documentation/jamroom-developers-guide/4611/jrcore-item-list-buttons

Then just add the buttons you want individually and wrap them in whichever IF clauses you require.
Dazed
Dazed
@dazed
8 years ago
1,022 posts
Thanks Michael. I think it is a bug. I can create the error when going to site_url/band/action and the user has gallery links in their timeline. I have made zero changes to this area. Oh it also throws:

tinymce_imagetools failed to save the adjusted file
updated by @dazed: 12/31/16 12:37:36PM
michael
@michael
8 years ago
7,719 posts
You've tried running the integrity check?

The cause of the issue seams to be those activity timline entries on your-site.com/sos-band/action from 11 months ago with nothing in them.

They appear to supposed to be gallery images, but there is no details of them, the links show up as:
your-site.com//gallery//all

My guess is that the item they were supposed to be linked to may have been deleted...(?)... or maybe they are for a custom module...(?)....

Or it could be that the details in that row display template are using the wrong variable and the templates just need an update.

do you know how to get this situation to repoduce? I could follow those steps to see if i can recreate it. Might notice something.
Dazed
Dazed
@dazed
8 years ago
1,022 posts
Yes on Integrity check repairing DB's entries. I deleted those timeline entries for that band and no more db error. I am throwing tinymce_imagetools failed to save the adjusted file though.

I only saw this error when changing the skin. I just changed my site to the default Audio Pro Skin and was able to reproduce it.


Message	[Admin] invalid search criteria in jrCore_db_search_items parameters
Date	12/31/16 04:21:30PM
IP Address	75.171.156.220
URL	/ron-dadey/action/p=2
Memory	19.5MB

Array
(
    [0] => jrGallery
    [1] => Array
        (
            [jrcore_list_function_call_is_active] => 1
            [search] => Array
                (
                    [0] => gallery_title_url = 
                    [1] => _profile_id = 176050
                )

            [template] => 

    {if isset($_items)}
    {foreach $_items as $_i}
    <a href="{jrGallery_get_gallery_image_url item=$_i}" title="{$_i.gallery_alt_text}">{jrCore_module_function function="jrImage_display" module="jrGallery" type="gallery_image" item_id=$_i._item_id size="icon96" crop="portrait" class="iloutline" alt=$_i.gallery_alt_text width=96 height=96}</a>
    {/foreach}
    {/if}


            [order_by] => Array
                (
                    [gallery_order] => numerical_asc
                )

            [limit] => 4
            [module] => jrGallery
        )

)

updated by @dazed: 12/31/16 01:25:43PM
michael
@michael
8 years ago
7,719 posts
where are you seeing "... tinymce_imagetools failed to save the adjusted file though...."?

In the activity log? or on the screen when you try to upload stuff. First guess would be space on the harddrive to store the image if its just started happening.

Could you walk me through some steps for me to take to see that happening please.
Dazed
Dazed
@dazed
8 years ago
1,022 posts
Hey Michael - I just opened a ticket on this. I dd not see Douglas asked for it. There is more info there but here are repro steps.

Just login
clear activity logs
go to /ron-dadey/action/p=2
then check the activity logs