Author Topic: Maybe a dumb question but..  (Read 9757 times)

Offline BeZazz

  • Prolific Indexer
  • ****
  • Posts: 256
  • Helpful: +9/-2
    • BeZazz
Maybe a dumb question but..
« on: 2013-05-21, 08:55:28 am »
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?

Offline zombiehoffa

  • Junior Indexer
  • **
  • Posts: 17
  • Helpful: +5/-0
Re: Maybe a dumb question but..
« Reply #1 on: 2013-05-21, 04:03:23 pm »
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...

Offline BeZazz

  • Prolific Indexer
  • ****
  • Posts: 256
  • Helpful: +9/-2
    • BeZazz
Re: Maybe a dumb question but..
« Reply #2 on: 2013-05-21, 04:13:20 pm »
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

Offline jonnyboy

  • Epic Indexer
  • *****
  • Posts: 1046
  • Helpful: +93/-1
  • Lazzy Trucker
Re: Maybe a dumb question but..
« Reply #3 on: 2013-05-21, 04:36:04 pm »
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.

Offline BeZazz

  • Prolific Indexer
  • ****
  • Posts: 256
  • Helpful: +9/-2
    • BeZazz
Re: Maybe a dumb question but..
« Reply #4 on: 2013-05-21, 08:49:42 pm »
Ok,
Thanks.

Offline BeZazz

  • Prolific Indexer
  • ****
  • Posts: 256
  • Helpful: +9/-2
    • BeZazz
Re: Maybe a dumb question but..
« Reply #5 on: 2013-05-23, 06:00:15 am »
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?

Offline jonnyboy

  • Epic Indexer
  • *****
  • Posts: 1046
  • Helpful: +93/-1
  • Lazzy Trucker
Re: Maybe a dumb question but..
« Reply #6 on: 2013-05-23, 06:44:56 am »
You can change them.

Offline BeZazz

  • Prolific Indexer
  • ****
  • Posts: 256
  • Helpful: +9/-2
    • BeZazz
Re: Maybe a dumb question but..
« Reply #7 on: 2013-05-24, 07:34:21 am »
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 ','')

Offline BeZazz

  • Prolific Indexer
  • ****
  • Posts: 256
  • Helpful: +9/-2
    • BeZazz
Re: Maybe a dumb question but..
« Reply #8 on: 2013-05-24, 09:29:16 am »
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