Loss of genre id's

hulby · Post by **hulby** » Mon Dec 31, 2007 9:43 am

After upgrading I lost my genre_id's in the album table, they are now empty. Is this normal? Is the upgrade supposed to wipe them out?

Post by **wbartels** » Mon Dec 31, 2007 10:18 am

This is not the intention.
I will check all the incremental sql files soon.

hulby · Post by **hulby** » Mon Dec 31, 2007 10:30 am

I did customize my genre table when I started, creating my own set. Maybe that is why? All of the album_id's are different now, so I dont think there is a way to bring my old album table online and update the new album table genre_id field. Do you think there is a way?

Thank you Willem for your assistance.

-hulby

Post by **wbartels** » Mon Dec 31, 2007 10:32 am

I found the problem:
Remove line 71 from incremental_upgrade_19.sql:

Code: Select all

TRUNCATE TABLE `album`;

(the previous line: TRUNCATE TABLE `track`; is not a problem and will be rebuild)
I will soon release u bugfix.

I hope you have a backup of you database.
Than you can restore the database and update it again with the fix above.

hulby · Post by **hulby** » Mon Dec 31, 2007 10:58 am

That worked, well kind of. The db incrementally upgraded, and the genre_id's are still in there. Now I am back to the problem of the tracks not showing up. When I run Update, the track table is empty.

hulby · Post by **hulby** » Mon Dec 31, 2007 11:20 am

It seems like the only way I can get it to repopulate the tracks is to drop the database and have it do a full rebuild. However doing this, you lose all of the genre_id's anyway. I must be missing something. I did notice the track table structures are different with this upgrade.

Post by **wbartels** » Mon Dec 31, 2007 11:36 am

hulby wrote:That worked, well kind of. The db incrementally upgraded, and the genre_id's are still in there. Now I am back to the problem of the tracks not showing up. When I run Update, the track table is empty.

Did you do a full update after upgrading netjukebox?
Otherwise the tracks will stay empty.

hulby · Post by **hulby** » Mon Dec 31, 2007 11:40 am

Yes, I ran Config>Update, NOT Config> Fast Update. I've ran it a few times. I tried removing one of the .id files from an artist folder that didn't work either. Tried a few different things. Seems like it will only repopulte the tracks if I do a Drop on the db.

Post by **wbartels** » Mon Dec 31, 2007 11:45 am

Can you mail me the old database in a zip or rar file?
Than I can see whait is going on.

hulby · Post by **hulby** » Mon Dec 31, 2007 11:59 am

I did remove the line in incremental_upgrade_19.sql that truncates the track table. When the upgrade ran, the tracks were there, and so were the genre_id's. However when I clicked Update, it wiped out the track table.

You want me to email you the netjukebox mysql db itself? What is your email address, it is not under your profile?

hulby · Post by **hulby** » Mon Dec 31, 2007 12:28 pm

If I were to Drop the db, run a full rebuild and place a copy of my old album table in the db as a different name, could I run a sql statement that would populate the new album table with album_id and genre_id? I am not great with sql statements... Any advice?

Post by **wbartels** » Mon Dec 31, 2007 3:00 pm

hulby wrote:You want me to email you the netjukebox mysql db itself? What is your email address, it is not under your profile?

Yes
My email is on my homepage: http://www.netjukebox.nl/about.php

Post by **wbartels** » Tue Jan 01, 2008 4:48 pm

Hulby, from witch netjukebox version did you do the update?
Maybe than I can reproduce the problem.