this is because each song is assigned to that different artist (different than the artist on the album), then it will display it...
if the artist is not this one, you need to go to each song and assign it the artist from the album, then it won't display it.

It's like that for all songs. In site admin, everything is correct. But on website, that's what it shows. Wrong artist to the album. But all information and scans are correct.

that's weird. Can you please send me joomla backend access so I can take a look?

That's what happened when the artist table got corrupted. So I had to empty it and re-add them all over again. Then I had to re-assign them to each album.

oooh!! ok so that's what happened.

this means that you did not assign the SONGS table as well..

the artist_id in the songs table must be poiting to the "old" artist ID they belonged to. that's the problem of course.

how many artists do you have?

I'll have to count them, but it was 25 pages of CDs. So you can imagine how long that took. If I can just change the ids, that would be a lot quicker than each song.

well this is what I meant, it will be faster to change the ARTISTs ids (in the artist table), to match the "old" values (which are the ones still present in the SONGS table..)

So do I just look that up in song table, write them down and match them with artist table ids?

yes, that's what I would do...

but, again, if you changed the ALBUMS too, you will need to that in that table too...

I fixed that the long way. Just need to match the artists with songs.

going to be a long process. 410 artists. Have to renumber them, then change the album numbers

... yes this will be a long process.

the other thing we can do is simply NOT display the artist name in the songs list. The artist will not be correctly assigned, but at least you won't see the name on the album page...

That's the easiest way. How do I do that?

this requires a small modification on a PHP file.

which MC version are you running?

Wouldn't that mess up future additions? I may try the long way. First write down and figure out the old numbers to the 401 artists. Get that corrected. Then match that number up to albums. Which should put everything in order. Hopefully I can resort artist table by corrected ids

future addition won't be a problem at all.. the only problem of missmatching artists is precisely with all the data that is already there on your website...

So I guess it's best to just match the artists with the old ids (songs), then update the albums which can be done in admin.

Ok. The less frustrating way to do it is to wipe everything and start over. With the discogs integration, it won't be as painful. Then immediately back up the database.

Thanks for the help.