solved Media player not working on custom templates

MAD
MAD
@madc
8 years ago
600 posts
Hey guys,

Found a problem arise again that happened about 18 months ago.
In our custom templates the audio media player is not loading the file.

From debg log

(2016-02-27T02:20:04-05:00.0.11375200 : 0)-(mem: 17825792)-(pid: 26101)-(ip: 101.162.0.40)-(user: Punk Band Promotions)-(uri: GET /podcasts/stream/loudfastshitty_podcast/554/key=e25Mn9mbmYAM/file.mp3) Array ( [error] => Query Error: Data too long for column 'count_name' at row 1 [_post] => Array ( [_uri] => /podcasts/stream/loudfastshitty_podcast/554/key=e25Mn9mbmYAM/file.mp3 [auto3a01e4885ed4] => 1-f4a1b3c4a0ad702c69b1b854a472798b [_gat] => 1 [sess3a01e4885ed4] => 1b4b44678a2135427bfb8c754edbdae3 [_ga] => GA1.2.797b341a-50da-4a20-92db-095c3f3ae61b [__unam] => 2d56d79-15321c3c19a-67472351-3 [module_url] => podcasts [module] => prLoudFastShitty [option] => stream [_1] => loudfastshitty_podcast [_2] => 554 [key] => e25Mn9mbmYAM [_3] => file.mp3 [unique_cid] => 797b341a-50da-4a20-92db-095c3f3ae61b )

I checked the core updates and notice the change.

            <div class="item">
                <div class="jraudio_detail_player">
                    <div class="jraudio_detail_player_left">
                        {assign var="ap" value="`$_conf.jrCore_active_skin`_auto_play"}
                        {jrCore_media_player type="jrAudio_player_dark" module="jrAudio" field="audio_file" search1="_profile_id = `$_items.0._profile_id`" search2="audio_album = `$_items.0.audio_album`" order_by="audio_file_track numerical_asc" limit="50" autoplay=$_conf.$ap}
                    </div>
                    <div class="jraudio_detail_player_right">
                        {jrCore_module_function function="jrImage_display" module="jrAudio" type="audio_image" item_id=$_items.0._item_id size="large" class="iloutline img_shadow" alt=$_items.0.audio_title width=false height=false}
                    </div>
                </div>
            </div>

And this is what is in the current


      <div class="item">
                <div class="center" style="padding:0;margin:0 auto;">
                    {jrCore_module_function function="jrImage_display" module="jrAudio" type="audio_image" item_id=$_items.0._item_id size="xxxlarge" class="img_scale" alt=$_items.0.audio_title style="max-width:805px;max-height:500px;margin:0 auto;border-radius:0;"}
                </div>
                {assign var="ap" value="`$_conf.jrCore_active_skin`_auto_play"}
                {assign var="skin_player_type" value="`$_conf.jrCore_active_skin`_player_type"}
                {assign var="player_type" value=$_conf.$skin_player_type}
                {assign var="player" value="jrAudio_`$player_type`"}
                {if isset($player_type) && strlen($player_type) > 0}
                    {jrCore_media_player type=$player module="jrAudio" field="audio_file" search1="_profile_id = `$_items.0._profile_id`" search2="audio_album = `$_items.0.audio_album`" order_by="audio_file_track numerical_asc" limit="50" autoplay=$_conf.$ap}
                {else}
                    {jrCore_media_player module="jrAudio" field="audio_file" search1="_profile_id = `$_items.0._profile_id`" search2="audio_album = `$_items.0.audio_album`" order_by="audio_file_track numerical_asc" limit="50" autoplay=$_conf.$ap}
                {/if}
            </div>

Take a look at the error here
https://www.punkbandpromotions.com/loud-fast-shitty/podcasts/554/episode-339-loud-fast-shtty-october-26-2015-tiefighterdown-happy-halloween
( Pause the top banner video/audio. It is set to auto start )

Click on either of the players underneath
It throws this error

An error was encountered loading the media URL

Any ideas? Has the code changed again?

Could be this in our custom tpl file

{if isset($_items)}
    {jrCore_media_player type="jrAudio_player_dark" module="prLoudFastShitty" field="loudfastshitty_podcast" items=$_items} 
{/if}

Cheers
Kev



--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion

updated by @madc: 05/28/16 05:52:06PM
michael
@michael
8 years ago
7,692 posts
I can see the error happening on the stream.

The issue is that the name is too long for the count_name column in the jr_jrcore_count_ip table.

You can change that manually to 64 if you like or we will have it fixed for the next release.

Thanks.

If you want to fix it up manually, go to phpmyadmin or the Developer Tools database browser, and change the varchar(32) to varchar(64)
MAD
MAD
@madc
8 years ago
600 posts
Spot on Michael.
Worked fine. Cheers for that.
Chat soon eh on Colloquy?


--
~ https://punkbandpromotions.com ~
Check us out for all your Punk/Alternative Music!
Check us out on Facebook:- https://facebook.com/PunkBandPromotion

Tags