sql

Add a reply View Replies (9)

General

Wednesday, April 29 2009, 01:36 PM

Caner_wien

Offline

hallo my joomla 1.5.10 Music Collection 1.0.2

http://img201.imageshack.us/img201/7771/unbenanntmof.jpg

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 'AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY yea' at line 4 SQL=SELECT jos_muscol_albums.id FROM jos_muscol_albums LEFT JOIN jos_muscol_format ON jos_muscol_format.id = jos_muscol_albums.format_id WHERE artist_id = AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY year,month
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 'AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY yea' at line 4 SQL=SELECT jos_muscol_albums.id FROM jos_muscol_albums LEFT JOIN jos_muscol_format ON jos_muscol_format.id = jos_muscol_albums.format_id WHERE artist_id = AND (display_group = '' OR format_id = '' OR format_id = '') ORDER BY year,month

Responses (9)

Accepted Answer

Germinal Camps

Offline
Wednesday, April 29 2009, 03:48 PM - #Permalink
0

hello

I though this error was solved in 1.0.2.. I tested it many times and it worked fine.

can you post a link to your site?

(o you understand english?)

Germi
The reply is currently minimized Show
Accepted Answer

Caner_wien

Offline
Wednesday, April 29 2009, 03:52 PM - #Permalink
0

hallo germi das ist mein http://www.kurdo-can.com/index.php/de/multimedia/music">http://www.kurdo-can.com/index.php/de/multimedia/music web seite

oda http://www.kurdo-can.com/

ich hanbe keine engilsi moment ich meine kolega komst engilsh screbin

danek germi
The reply is currently minimized Show
Accepted Answer

Caner_wien

Offline
Wednesday, April 29 2009, 03:57 PM - #Permalink
0

How do i Have to put the music on my homepage, to listen to.
Which category belongs to "music"??? I dont know that
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Wednesday, April 29 2009, 04:21 PM - #Permalink
0

hallo

I see you created only an album, and some items inside this compilation. I dont think thats the way you want to do that.

usually the structure of Music Collection is:

Artists -> Artist -> Album -> Song

so usually, when you enter Music Collection, you access the Artists view, then you choose the artist, then the album... etc

in your MENU (multimedia -> music) select "Music Collection -> Artists"

do you want a list of your artists to appear? or you just want some albums to show? how many albums will you have (approx)?

I you want, you can send me by mail an admin username and password of your admin area, and I can try to configure Music Collection for you

Germi
The reply is currently minimized Show
Accepted Answer

Caner_wien

Offline
Wednesday, April 29 2009, 04:56 PM - #Permalink
0

sondu progleme what
The reply is currently minimized Show
Accepted Answer

Caner_wien

Offline
Wednesday, April 29 2009, 05:08 PM - #Permalink
0

in what kind of format the musicfile hast to be so i can upload it on the site
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Wednesday, April 29 2009, 05:12 PM - #Permalink
0

it has to be MP3

check you Parameters, anyway:

[img size=348]http://www.joomlamusicsolutions.com/images/fbfiles/images/imagen_1-2820f9f88ead41fa9565aa5ea11d09b2.png[/img]

Attachments:
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Wednesday, April 29 2009, 05:13 PM - #Permalink
0

[img size=468]http://www.joomlamusicsolutions.com/images/fbfiles/images/imagen_2.png[/img]

look at "Show online player for registered users", for instance

Attachments:
The reply is currently minimized Show
Accepted Answer

Caner_wien

Offline
Wednesday, April 29 2009, 08:21 PM - #Permalink
0

mein dame heren das Music Collection super programe enisn numer jetzzzz kaufenn
The reply is currently minimized Show