Maybe a dumb question but..

[BeZazz]

I have asked this twice on IRC without a reply. So I am thinking maybe the answer is obvious.

In Series List. I have entries that look like "10532 scenenzb Parks and Recreation"    NOTE: the extra info at start "10532 scenenzb"
and
"02601 15659 Entourage"

Clicking on them leads to the correctly named series.

Is there a way to fix these so they are correct when viewing Series List?

[zombiehoffa]

I believe you can use fixReleaseNames.php in ~/nZEDb/misc/testing as described in the little blurb at the top of the script to fix this, it may take a long time. I haven't had this problem so I haven't tried this out myself. Since I haven't tried this myself, I would recommend you backup your sql database before you do it in case I don't know what I'm talking about...

[BeZazz]

Hi,
Thanks for the reply.

I looked at that script but was a bit hesitant to run it on "all".

I will just have to what you suggested and make sure my backup is up to date.

Thanks

[jonnyboy]

fixReleaseNames.php doesn't change the original name, that always remains. So, you can run this script again and again, with different settings until you get the results you like. Tmux scripts run 3 then 5. So, have no worries.

[BeZazz]

Ok,
Thanks.

[BeZazz]

I had no luck with this.
The ones I was hoping would get changed (see first post) didn't.

Am I able to manually change the names without causing other issues to occur?

[jonnyboy]

You can change them.

[BeZazz]

Hi all,
Does anyone know if this would work
(To remove "Release Name" before the actual correct name)

SELECT * FROM `releases` WHERE `searchname` LIKE '%release name%' replace(searchname, 'Release Name ','')

[BeZazz]

I went with
UPDATE `releases` SET `searchname` = replace(searchname, 'Release Name ','')

Appears to have worked but I wouldn't recommend anyone use the above, just in case lol