Recent Posts

Pages: 1 ... 8 9 [10]
91
Regex / Re: regex question
« Last post by ordeneus on 2018-02-05, 04:45:00 PM »
. does mean anything, but you didn't say how many anythings!

You need a quantifier.

* means zero or more.

So, .* means zero or more of anything...
92
Support / Re: File Renaming
« Last post by drakejones on 2018-02-05, 12:26:47 AM »
I ran "match_prefiles.php full show" and it renamed tons of perfectly named music to "Various.Artists. - .Smash.Hits.80s.Mixtape.[2017].[Mixtape]" and "Best.Of.Buddha.Beats".

Wish I would have caught your post before I did the same thing.  But it was worth a try!  I learn something new almost everyday.   :D   Try this to get the old searchnames back:
 
Code: [Select]
php '/var/www/nZEDb/misc/testing/Release/resetSearchname.php' reset
93
Support / Re: RELOAD privilege now required to repair tables?
« Last post by Darius on 2018-01-30, 04:05:22 AM »
You, most likely, haven't run this command:

Code: [Select]
GRANT ALL ON nzedb.* TO 'YourMySQLUsername'@'YourMySQLServerHostName' IDENTIFIED BY 'SomePassword';
When all privileges are granted, reload is available
94
Support / Re: File Renaming
« Last post by hanshansen on 2018-01-30, 02:08:23 AM »
Ok, I restored my VM to a 2 days old backup and checked all releases for the predb_id's. I found only one. So the script messed it all up. It would be nice if it had a "dry run" option

Be careful when running it on all releases...
95
Support / Re: RELOAD privilege now required to repair tables?
« Last post by hanshansen on 2018-01-30, 01:27:36 AM »
MariaDB 10.2
96
Support / Re: RELOAD privilege now required to repair tables?
« Last post by Darius on 2018-01-29, 11:12:25 PM »
That is caused by MariaDB update. What version are you using? 5.5, 10.0, 10.1 or 10.2?
97
Regex / Re: regex question
« Last post by david_ritterhous on 2018-01-29, 06:46:08 AM »
Ok, as I have continued this quest, I am having issues (no shocker there)

I am assuming I need to first create a collections regex?  or do I need to just create a release regex?

I have tried running some tests in the release regex but even if I copy an existing one into the test area, it just returns 0 results.  Just need some direction please.

EDIT:
I just thought of this, is there a way to view releases that did not match any regex?  That would help in seeing what regex's I could test against.
98
Support / Re: File Renaming
« Last post by hanshansen on 2018-01-29, 04:30:42 AM »
Note to myself, always make a snapshot of my nzedb VM before doing stuff like that  :-[

I ran "match_prefiles.php full show" and it renamed tons of perfectly named music to "Various.Artists. - .Smash.Hits.80s.Mixtape.[2017].[Mixtape]" and "Best.Of.Buddha.Beats".

I checked the releases and they all have the predb_id of one of these two id in it. How on earth did the same predb_id end up in so many releases?

Is there a way to get the proper names back? First I would delete the predb_id from all of those releases and replace $searchname with $name. Can I then run a script on those releases looking for the names in nfo, rar, par etc?
99
Support / RELOAD privilege now required to repair tables?
« Last post by hanshansen on 2018-01-29, 03:16:57 AM »
Hi,

I just noticed that I get the following error when running the optimize_db.php script, if a table needs to be repaired.

Code: [Select]
Error: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
It started a month ago the day after I updated a lot of packages in Ubuntu. Amongst the updates were php and mariadb. I don't remember if I updated nzedb too on that day.

Did something in nzedb change or is it caused by the mariadb update?
100
Support / Re: File Renaming
« Last post by slayer99 on 2018-01-28, 11:19:55 AM »
Try running match_prefiles.php to see if it helps with some of the rename issues.

That helped...improved naming on about 25%.

I guess what I'm wondering is that the titles are in the db when we do PAR2 and RAR checks...so there has to be a way to use the info in the database to rename the files based on that info.  The current renaming methods aren't covering those.
Pages: 1 ... 8 9 [10]