Loss of genre id's

General discussion about netjukebox
Post Reply
hulby
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Loss of genre id's

Post by hulby »

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?
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

This is not the intention.
I will check all the incremental sql files soon.
hulby
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Post by hulby »

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
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

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
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Post by hulby »

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
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Post by hulby »

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.
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

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
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Post by hulby »

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.
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

Can you mail me the old database in a zip or rar file?
Than I can see whait is going on.
hulby
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Post by hulby »

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
User
Posts: 27
Joined: Mon Feb 12, 2007 6:54 am

Post by hulby »

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?
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

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
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

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