blog documentation FAQ followers forum marketplace services youtube

solved Getting a DB error when selecting the artist tab

The Jamroom Network » Forum » Installation and Configuration » Page » Getting a DB error when selecting the artist tab
starone
@starone
11 years ago
51 posts
Instead of showing the tabs Artists by Name and Top Artists, I get the following error: error: invalid order direction received for - must be one of: ASC, DESC, NUMERICAL_ASC, NUMERICAL_DESC, RANDOM

Please advise.
updated by @starone: 06/20/14 12:51:23PM
brian
@brian
11 years ago
10,149 posts
starone:
Instead of showing the tabs Artists by Name and Top Artists, I get the following error: error: invalid order direction received for - must be one of: ASC, DESC, NUMERICAL_ASC, NUMERICAL_DESC, RANDOM

Please advise.

Can you let me know the skin you are using? I can test here and see what's up.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
I am using jrNova-release-1.2.3

Thanks!
brian
@brian
11 years ago
10,149 posts
starone:
I am using jrNova-release-1.2.3

Thanks!

Thanks - let me check this out and see if I can replicate it here.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
11 years ago
10,149 posts
I'm not seeing any issue here locally, nor on the Jamroom demo:

http://demo.jamroom.net/jrNova/artists

Have you customized anything in the skin templates or the skin config?

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
Not really, just a couple minor things in the header and footer but nothing that would effect that portion of the templates I would think. Which template is handling those artist buttons in particular?
brian
@brian
11 years ago
10,149 posts
starone:
Not really, just a couple minor things in the header and footer but nothing that would effect that portion of the templates I would think. Which template is handling those artist buttons in particular?

It would be the skins/jrNova/artists.tpl file. I've looked at the template here and the order_by values are correct.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
Let me take a look and see what it looks like. I have never touched that template. You can see the error here: http://star1ent.com/artists/artists
updated by @starone: 05/01/14 01:55:25PM
starone
@starone
11 years ago
51 posts
(snipped)
brian
@brian
11 years ago
10,149 posts
Yep I definitely see it. Try this - try reloading the skin from the Marketplace by going into ACP -> Marketplace -> Tools -> Reload Modules and Skin. "reload" the Nova skin, then do ACP -> Reset Caches and reset all caches.

If that error still persists, let me know your MySQL server version number from the ACP -> System Check area.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
Okay, I will want to save my modified templates first because I don't want to loose my template modifications. Thanks!
starone
@starone
11 years ago
51 posts
I don't see that the jrNova skin available in the Marketplace?
brian
@brian
11 years ago
10,149 posts
Make sure you are in the tools -> reload modules and skins section - not the main marketplace screen.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
Okay, updated the skin to the latest version and reset cache, but the same error persists. MySQL version is 5.5.32-cll

I have switch to a couple other skins and do not get that error only in Nova.
updated by @starone: 05/01/14 02:44:28PM
brian
@brian
11 years ago
10,149 posts
Something weird is going on here - if you can, send me your FTP login info and JR admin login to support [at] jamroom [dot] net and I will check it out as soon as I can.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
Info sent.
Thanks!
brian
@brian
11 years ago
10,149 posts
I've got this fixed for you, and am also checking out why it was happening. Looks like there is something up with the routing, but it also points out that we need a "catchall" in the template so something like this can't happen.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
I had to reload my core files because I ran into a problem now the artists tabs are not working again :(

If the problem is with my host directory being also called artists, then I am willing to rename the directory but then the question is how will this effect my installation? IS there an easy way to change the host directory name and have the core rewrite the paths internally?
updated by @starone: 05/03/14 05:26:45PM
starone
@starone
11 years ago
51 posts
You can checkout the problem by going here: http://star1ent.com/artists/artists
brian
@brian
11 years ago
10,149 posts
starone:
You can checkout the problem by going here: http://star1ent.com/artists/artists

I made the change in your "templates" section, which stores the changes in the DB - it won't be overwritten on an update.

I just checked here and am not seeing any errors.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
starone
@starone
11 years ago
51 posts
Thanks Brian, Michael added a line to the template and explained the fix so I am good to go now!

Tags