I see..

hmm is this at the jomsocial page?
can you post a link? that would be very useful...

Sorry
I've the same error
My link page is:
http://www.ddsound.com/index.php?option=com_muscol&view=playlist&id=0&Itemid=69&lang=it

But this site is at the moment closed with key password's acces.
Can i contact for give you private access?

Answer me to my email please.
Fabio

hello Fabio,
details at joomlamusicsolutions@gmail.com

Hey here is the link... I kind of threw it up real quick so you can see, sorry it took so long
but can you help with this...
it seems to be on the new artist register page in the music collection system as well as jomsocial add new artist... its the same message though
oh yea and this site is currently closed...
I can give it to you via my email @ zodiggsz@gmail.com
thank you so much

http://mymusicpromo.com/index.php?option=com_muscol&view=artist&layout=form&Itemid=94&lang=en

yes send me your access data please.. otherwise I can't do much!

I'll make it live so you can check it out


mymusicpromo.com/index.php?option=com_mu...temid=94&lang=en

Hi Germi
I've sent you the acces key.
Have you received it?

Bye
F

yes! already answered you by mail: the problem is that you were trying to save a plylist without items in it! I just added some items, and then saved the playlist, and there was no problem!

Hi Germi

Sorry but the problem display the error without any interaction with to the playlist but as soon as you open the page!

So please see better!
Bye

Hi Germi
I've see your playlist on my website but..
I've the same problem in pages without any song loaded.

If I not insert song on playlist the error is showed otherwise it's go out.
Can you help me please to remove it in any way?

I hope see you soon on my webstie.
Bye

i think i have the same problem here.. no idea what is going on..

http://atunesonline.com/index.php?option=com_content&view=article&id=19&Itemid=27&lang=en



and i also get this after i comment on an artist page:

500 - No valid database connection:Unknown column 'artist_name' in 'field list' SQL=SELECT artist_name AS name,user_id FROM jos_muscol_albums WHERE id = 8

You may not be able to visit this page because of:

1. an out-of-date bookmark/favourite
2. a search engine that has an out-of-date listing for this site
3. a mistyped address
4. you have no access to this page
5. The requested resource was not found.
6. An error has occurred while processing your request.

Please try one of the following pages:

* Home Page

If difficulties persist, please contact the System Administrator of this site.

No valid database connection:Unknown column 'artist_name' in 'field list' SQL=SELECT artist_name AS name,user_id FROM jos_muscol_albums WHERE id = 8

arggg SORRY

we just discovered this error!!!!

it's a small bug. very easy to solve. we will publish an update very soon! however, if you want, you can solve it yourself:

open /components/com_muscol/controller.php and go to line 365

where it says #__muscol_albums it should say #__muscol_artists

SORRY ABOUT THAT!!!

thanks for the solution...love your product.

Hi Germy

Sorry but I've change the line 356 and not the 365 because in 365 not there is the "#__muscol_artists" label.

This is what now there is:
$query = ' SELECT artist_name AS name,user_id FROM #__muscol_artists WHERE id = ' .$album_id ;

In my 356 line i see what you mean I hope.
But the error message don't go out!!

Please help again!
Bye

this is the link to the error.. when you click on the on-the-go playlist when its empty.

http://atunesonline.com/index.php?option=com_muscol&view=playlist&id=0&Itemid=54&lang=en

@fabionefa yes, the changeyou did is the corrent... but the problem should be gone! you still have the problem when you comment an artist?

@sevenxavier uops!! this looks like an error (the truth is.. "on-the-go" playlist should not be clickable if empty...)

oooh wow.. i guess i found two errors so far with the application. i should get a discoutn or soemthign. hahha..

any fix yet on this? please keep me informed.

actually, I'm taking a deeper look into this.. and it's not a bug, actually. the playlist should show up, but just... empty.

if you see in our site, that's what it does: it opens, but it's empty. it gives no error... and we are using exactly the same version that you have!

so I'm wondering why are you getting this error... let me look deeper into it.

anyway, here's a quick fix: unzip and copy this file into
/components/com_muscol/views/playlists/tmpl/default.php
[file name=default-20101220.zip size=1407]http://www.joomlamusicsolutions.com/images/fbfiles/files/default-20101220.zip[/file]

(it must replace the current one)

basically, this just skips the LINK if the playlist is empty...

I had this error but looking at an artist and showing related items. It seems to be something with the query on related items and related items does have values (it's not empty).

"No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT related FROM jos_muscol_artists WHERE id ="

Interesting thing: I have to give an example for trying to explain what I see is happening from my perspective.

Let's say we have two artist: A and B. If on A you select B as related and on B you select A as related (on the admin), the error comes out...

"No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT related FROM jos_muscol_artists WHERE id =".

If you just select one of them, there should be no problem.

Another thing is that I run a spanish version site. In spanish we use the accent symbol on some words, that is, á é í ó ú. Maybe the query could have problems with those characters..

hello

the problem looks just like "there's no ID" which is pretty weird. it shouldnt have any problems, you select or not A related to B and the other way around

about chars like á é í ó ú, don't worry, it is not a problem at all. I run a spanish site myself and there are no problems. it is UTF8 compatible. works even with arabic, cyrillic...
no problems

Hi Germi
No the problem is when you enter in the page where you can manage the playlist but if is empty the error is show!
Please help or fix it.

Bye
Fabio

well... the file I posted should solve this.. (it simply disables acees to the playlist, if empty).. have you tried it?

Hi Germi
unfortunately the problem doesn't go away and new problem is come!!
Please see my web site's pages:
"Gestisci la tua PLAYLIST" where the problem is showed
and
"Problem" where the new error is come... the page is gone !!

Please help as son as possible.
Bye
Fabio

Hi Germi
Where You are ? Are you in holydays? :-) Great!

The SQL problem remain the same!!

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=SELECT s.*,al.name as album_name, al.image, ar.artist_name FROM jos_muscol_songs as s LEFT JOIN jos_muscol_albums as al ON al.id = s.album_id LEFT JOIN jos_muscol_artists as ar ON (ar.id = s.artist_id OR ar.id = al.artist_id) WHERE s.id IN ()


in the page where ther isn't item in the playlist!!
Please can you make a fix for this bad problem?

You have the acces keys for my site...do you remember?

See you as soon as possible
fabionefa

hello Fabio!

yes, I took some days off...

HAPPY NEW YEAR!!

let me take care of this. can you please remind me in which page do you get this error? ( I mean, can you just post a link?)

Hi Germi

Happy New Year to you!

Yes the link is here:
http://www.ddsound.com/index.php?option=com_muscol&view=playlist&layout=form&Itemid=70&lang=it

See you soon
Fabio

hello Fabio,

can you check if this file solves the issue?
you must unzip it and replace it for the one existing in /components/com_muscol/models/

[file name=playlist.zip size=2660]http://www.joomlamusicsolutions.com/images/fbfiles/files/playlist.zip[/file]

It solved the issue about the playlist being empty.

However, at the global parameters, there is an option that says "Allow Playlist Storage". It is "Yes". But in fact, nothing is written to the playlist table on the database. Did I missed something?