Error Being Thrown

Dazed
@dazed
11 years ago
1,022 posts

Query Error: Unknown column 'profile_quota_id' in 'field list' - check debug log

debug log - (2014-04-16T01:40:15+01:00 : 0)-(mem: 13369344)-(pid: 5425)-(ip: 122.164.107.153)-(uri: /artists/most_viewed) |Query Error: Unknown column 'profile_quota_id' in 'field list'|

Any ideas?

updated by @dazed: 05/26/14 06:56:12PM

@michael
11 years ago
7,772 posts

Its saying something related to the url /artists/most_viewed is having trouble doing something with related to profile_quota_id.

Done anything custom on that page with 'profile_quota_id' in it?

If its a default skin, which skin?

--edit--
oh, and make sure all updates are up-to-date. Could be related. not sure.
updated by @michael: 04/21/14 11:00:52PM

Dazed
@dazed
11 years ago
1,022 posts

Thanks Micheal. Sorry for the late reply. My server decided to go on strike so spent a day down for the count.

As for this error, I have never used the artists/most_viewed so I am guessing it is a default ProJam template. I am not even sure where it resides in the ui.

@michael
11 years ago
7,772 posts

Can't reproduce this error. I tried on my local machine, but no error comes.

http://demo.jamroom.net/jrProJamLight/artists/most_viewed

is the url for the demo site. It seams to render properly.

If you go to that url on your site, does it show? does it trigger the error?

are the skins up to date?

Dazed
@dazed
11 years ago
1,022 posts

Thanks Michael. I am using the dark version but I looked at the default template and mine and they are identical. If I hit the page,I get the error - CRI: Query Error: Unknown column 'profile_quota_id' in 'field list'. The "most viewed" threw me. Once I looked at the url page, I knew the area. This had been working so I am kind of surprised. Also that search area should be valid.

                            {if isset($_conf.jrProJam_require_images) && $_conf.jrProJam_require_images == 'on'}
                                {if isset($_post.option) && $_post.option == 'most_viewed'}
                                    {jrCore_list module="jrProfile" chart_field="profile_view_count" chart_days="365" search1="profile_quota_id in `$_conf.jrProJam_artist_quota`" search2="profile_name like `$_post._1`%" template="artists_row.tpl" require_image="profile_image" pagebreak=$_conf.jrProJam_default_artist_pagebreak page=$_post.p}
                                {else}
                                    {jrCore_list module="jrProfile" order_by=$order_by search1="profile_active = 1" search2="profile_quota_id in `$_conf.jrProJam_artist_quota`" search3="profile_name like `$_post._1`%" template="artists_row.tpl" require_image="profile_image" pagebreak=$_conf.jrProJam_default_artist_pagebreak page=$_post.p}
                                {/if}
                            {else}
                                {if isset($_post.option) && $_post.option == 'most_viewed'}
                                    {jrCore_list module="jrProfile" chart_field="profile_view_count" chart_days="365" search1="profile_quota_id in `$_conf.jrProJam_artist_quota`" search2="profile_name like `$_post._1`%" template="artists_row.tpl" pagebreak=$_conf.jrProJam_default_artist_pagebreak page=$_post.p}
                                {else}
                                    {jrCore_list module="jrProfile" order_by=$order_by search1="profile_active = 1" search2="profile_quota_id in `$_conf.jrProJam_artist_quota`" search3="profile_name like `$_post._1`%" template="artists_row.tpl" pagebreak=$_conf.jrProJam_default_artist_pagebreak page=$_post.p}
                                {/if}

@brian
11 years ago
10,148 posts

I'll check this out for you and let you know what's up.

Thanks!

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

@brian
11 years ago
10,148 posts

I've got this fixed up on your site, but I'm not sure the ordering is correct - I'm checking that out locally here to see if I can replicate and will see what's up.

Thanks!

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

@brian
11 years ago
10,148 posts

I've got this fixed up now - let me know if you see any issues. Root cause was in the charts module (it needs to replace any existing order_by with the correct chart order_by).

Hope this helps!

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

solved Error Being Thrown