Hello -

I'm working on a site that was running Joomla 1.5, and I'm in the process of upgrading it to 3.0. My client was using Music Collection in Joomla 1.5, so I need to upgrade and port everything over. I just bought the most recent version of Music Collection today (since the old one had expired a year ago!) and searched the forums looking for tips on how to export the old site into the new. I found a few posts saying to go into PHPMyAdmin and export just the old MySQL tables into the new database, so I went ahead and did that.

Now in the admin, I can view settings, albums, genres, formats, tags, and ratings. But if I try to go into artists, songs, or comments, I get the following errors:

Artists: 1054 Unknown column 'ar.user_id' in 'on clause' SQL=SELECT ar.*, u.name as username FROM j2_muscol_artists as ar LEFT JOIN j2_users as u ON u.id = ar.user_id ORDER BY ar.class_name ASC LIMIT 0, 20

Songs: 1054 Unknown column 's.user_id' in 'on clause' SQL=SELECT s.*, al.name as album_name, ar.artist_name, u.name as username FROM j2_muscol_songs as s LEFT JOIN j2_muscol_albums as al ON al.id = s.album_id LEFT JOIN j2_muscol_artists as ar ON ar.id = s.artist_id LEFT JOIN j2_users as u ON u.id = s.user_id ORDER BY s.id DESC LIMIT 0, 20

Comments: 1146 Table 'memarkel_joom13.j2_muscol_playlists' doesn't exist SQL=SELECT c.*,al.name as album_name, s.name as song_name, ar.artist_name, pl.title as playlist_name, u.name FROM j2_muscol_comments as c LEFT JOIN j2_users as u ON u.id = c.user_id LEFT JOIN j2_muscol_albums as al ON al.id = c.album_id LEFT JOIN j2_muscol_songs as s ON s.id = c.album_id LEFT JOIN j2_muscol_artists as ar ON ar.id = c.album_id LEFT JOIN j2_muscol_playlists as pl ON pl.id = c.album_id ORDER BY c.date DESC LIMIT 0, 20

I haven't the faintest idea what to do about this.

I haven't actually copied the MP3 files over to the new instance of Joomla yet (my client has 700+MB of songs so it will take a while! :blink: ) but that shouldn't be causing SQL errors anyway, especially on the comments section...

Any idea what might be happening?

Thank you!

k*