hey

my first installation of media monkey 4 was good because i didnt know that it can be installed in portable mode . so i installed it and made it portable myself as i always do and nothing went wrong

the problem appeared when i wanted to install it on my other pc and this time i noticed the portable check box and i installed it on my previous portable folder .
this is what happened to the music paths in my library
[url=http://www.sorakheboz.org/ax/viewer.php?file=93521243514719747384.jpg][img]http://www.sorakheboz.org/ax/images/93521243514719747384_thumb.jpg[/img][/url]

as you can see the start (shared) section of the path which was d:\media\audio\music has changed to [MUSIC] and i dont know how to fix it. i hoped that by writing a config line like this [music]=d:\media\audio\music\ would solve the problem but despite trying all the combinations i could guess , im still unable to fix this problem. please help

thanks in advance

What are the steps you are using to accomplish this, perhaps with that information someone will be able to help you?

Actually no, it's not easier to update Genres in MM manually when you have several thousand of them. Isn't that the point of scripts? I can handle doing some manually, but not thousands.

I gave up on SQL and am trying UpdateDB and WriteTags methods with no luck. I will start another thread to try to figure it out.

Out of curiosity wouldn't it be easier to add the genre's via the native MM way? But using this script, what sql are you using, are you sure the tags are being saved with the new genre's?? Try syncronizing them after you run the sql.

I am trying to get this to work with adding new Genres. I can get a new Genre to add to the Songs table, but once I rescan my library, the new genre disappears. I tried adding the new Genre to the Songs table, Genres table and the link between the song and new genre in the GenresSongs table, but still the new Genre disappears when I rescan the library.

Any suggestions for adding new Genres with SQL?

Thanks

Steve

A few minutes. It "took some time" means compared to the wrong code :wink:

Great, how long time did it take? (It should be pretty fast.)

[quote]What's the difference between \\xyz\ and :\xyz\[/quote]
The driveletter is not stored in the path field in the database. I.e all paths starts with :\xyz\. If you use UNC path then do the paths start with \\xyz\ (\\DEVICENAME\folder).

Hey, thanks, it worked. Took quite some time, but with 12500 songs, no wonder.
[b]Don't forget to restart MM![/b]

What's the difference between [color=#FF0000]\\xyz\[/color] and [color=#FF0000]:\xyz\[/color]
I would have thought that the \\xyz searches anywhere in the path, whereas :\xyz searches only including the leading colon from right after the drive letter?

Actually, changing the drive letter would still make the songs playable since MM uses the driveID of a drive to locate it. The reason it doesn't work now is that you have changed the folder. To make it work again, do like this:

1. Back up your database!

2. Run this statement: (Use either button.)
[code]UPDATE Songs SET SongPath = REPLACE(SongPath, ':\jaBU\iMusic\', ':\2 Music\')
WHERE SongPath like ':\jaBU\iMusic\%';[/code]
3. Let me know it it worked.

Hi. I have a quite similar problem, but I can't get it SQL-Viewer to do the work:
I changed the volume character (from H: to N:) on an external drive containing my music and also the path to the music folder:
old: [b]H:\jaBU\iMusic\[/b]
new: [b]N:\2 Music\[/b]
Then I opened MM and found all my music, under the new drive letter, but within the old path: N:\jaBU\iMusic\
All songs are displayed black, but when trying to play, they turn grey and don't play.
I am completely new to SQL-Viewer and have no coding experience whatsoever. I entered the following into the window:
[code]UPDATE Songs SET SongPath = REPLACE(SongPath, '\\jaBU\iMusic\', '\\2 Music\')
WHERE SongPath like '\\jaBU\iMusic\%';[/code]
Then I hit 'Run Select Query' (although I am not sure what the buttons mean): 0.234 sec, nothing happens (except #____ in the bottom window).
Then I hit 'Execute DDL/DML Statement': Information window 'Statement Successfully Executed in 0,344 sec'
Nothing has changed with the songs.
Please help :-?

SQL can only change the path in MM's database. But I guess that's what you want to do?

1. What is the incorrect path in your database?
2. What do you want to update it to in MM's database?

Hmmm... did not do the job jet. I went to the folder in MM. Selected all those entries. Then started the Script SQL viewer. Entered the code in the big box in the middle and hit RUN Select Query. It took about 7 seconds and 0 rows.

I'm totally new to SQL viewer. Maybe I do sth wrong?

If I understand you correctly this should do it, but please [b]back up your database [/b]first!
[code]UPDATE Songs SET SongPath = REPLACE(SongPath, '\\Algemeen\d\mp3\', '\\Algemeen\mp3\')
WHERE SongPath like '\\Algemeen\d\mp3\%';[/code]

Can someone help me out? I also need to change the folder name. But the folders are on a different PC, within the same network group.

It was: \\Algemeen\d\mp3\
must be: \\Algemeen\mp3\

Can you please make the query for me? I'm totally not experienced and am afraid I will screw it all up.

I've used it with mm4 but I have not tested it with any of the new fields that are in mm4.