New Setup - Master/Dev Branch - Incorrectly Formatted Filename

[irishj]

Hi,

I'm just trying a new setup of nzedb, cloned from the 'dev' branch and I'm getting the following error on DB setup.

Never had this issue before (have setup nzedb a few times) and DB creds are correct and user has full access to database 'nzedb'.  Also tried with a user who has root DBA permissions.  It created the database tables, but no data is imported.  I can't get past DB setup at the moment due to this error.  Any help appreciated.


Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-anidb.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-binaryblacklist.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-category.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-content.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-countries.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-forumpost.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-genres.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-groups.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-menu.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-site.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-tmux.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\resources\db\schema\data\10-tvrage.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$

[kevin123]

I believe the issue is with the ?'x' , it should be ?P<x> (if using php 5.2 or lower) but if you use php 5.5 as recommended that shouldn't be the issue.

[irishj]

Hi,

Thanks for the prompt reply.

I'm using php 5.5.8.  I'll try and manually edit the .sql scripts, making the change you advised.

[kevin123]

Another issue might be the slash.

Try changing it to this : #^.*\d+-(?P<table>\w+)\.tsv$#

Line 109 nzedb/db/DbUpdate.php

[kevin123]

This also works : It gets the windows type slash : #^(?:.*[/\\]|)\d+-(?'table'\w+)\.tsv$#

[kevin123]

Actually it needs 4 : #^(?:.*[/\\\\]|)\d+-(?'table'\w+)\.tsv$#

[irishj]

Ahh..excellent, thanks

I checked the php log and found this error..

PHP Warning:  PDO::setAttribute(): SQLSTATE[00000]: No error: PDO constructor was not called in D:\nzedb\www\install\step2.php on line 117

I'll make the changes you kindly suggested now.

Thanks

[kevin123]

That warning is fine, Im doing some testing and I'll push that regex change to dev branch.

[irishj]

Ok, made that change, but now it's throwing these errors.  The path is wrong...

Inserting data into table: 'anidb'
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'field list'
Inserting data into table: 'binaryblacklist'
SQLSTATE[HY000]: General error: 29 File 'D:\data\ zedb esourcesdbschemadata10-binaryblacklist.tsv' not found (Errcode: 2 - No such file or directory)
Inserting data into table: 'category'
SQLSTATE[HY000]: General error: 29 File 'D:\data\ zedb esourcesdbschemadata10-category.tsv' not found (Errcode: 2 - No such file or directory)

There is no 'data' directory, the drive is named 'data' and the nzedb folder is in the root of that drive, called 'nzedb'.

So the complete path would be "D:\nzedb\resources\db\schema\data".  I'm running on Windows if it makes a difference.

Thanks !

[kevin123]

Hmm not sure about that, we'd have to wait for the guy who made the script to chime in.

[irishj]

Ok, thanks Kevin...will wait for reply from script writer

[kevin123]

I let him know and he pushed this change :

https://github.com/nZEDb/nZEDb/commit/408e22ff866da2c152e7d60d9d3fc001b18339be

[irishj]

I just tried again, fresh install and getting the same error as yesterday when I first reported the issue.  Weird thing is, I get this error with the 'master' or 'dev' branches, but never had this issue before

// MASTER

Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-binaryblacklist.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-category.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-content.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-countries.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-forumpost.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-genres.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-groups.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-menu.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-site.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-tmux.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_master\resources\db\schema\data\10-tvrage.tsv' (should match ^(?:.*/|)\d+-(\w+)\.tsv$

// DEV

Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-anidb.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-binaryblacklist.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-category.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-content.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-countries.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-forumpost.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-genres.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-groups.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-menu.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-site.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-tmux.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-tvrage.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$

[archer]

Just pushed another change to regex, please test. Better to reply in IRC if you can to make things faster.

[irishj]

Hi,

I did a 'git stash' & 'git pull' and it did pull changes.

D:\nzedb\nzedb_dev>git pull
remote: Counting objects: 196, done.
remote: Compressing objects: 100% (100/100), done.
remote: Total 196 (delta 116), reused 150 (delta 95) eceiving objects:  95% (187
Receiving objects:  96% (189/196), 2.12 MiB | 79
Receiving objects: 100% (196/196), 3.08 MiB | 795.00 KiB/s, done.
Resolving deltas: 100% (116/116), done.
From https://github.com/nZEDb/nZEDb
   9814f56..2d0d633  dev        -> origin/dev
Updating 9814f56..2d0d633
Fast-forward
 Changelog                             |  10 +
 docs/Basic Windows Guide.txt          |   2 +
 docs/GNUWIN.txt                       |  14 +
 misc/testing/Dev/check_time.php       |   1 +
 misc/testing/Dev/export_settings.php  |  13 +-
 nzedb/build/git-hooks/runHooks.php    |   3 +-
 nzedb/build/nZEDb.xml                 |   2 +-
 nzedb/controllers/IRCScraper.php      |  56 +--
 nzedb/controllers/NZBContents.php     |  58 +--
 nzedb/controllers/Nfo.php             | 104 ++---
 nzedb/controllers/PreDb.php           |  19 +-
 nzedb/controllers/ReleaseCleaning.php |  53 ++-
 nzedb/controllers/Sharing.php         |   2 +-
 nzedb/db/DbUpdate.php                 |  10 +-
 nzedb/utility/Utility.php             | 779 ++++++++++++++++++++--------------
 www/automated.config.php              |   2 +
 www/pages/BasePage.php                |  13 +-
 www/pages/ajax_preinfo.php            |  10 +-
 www/pages/nfo.php                     |   3 +-
 19 files changed, 637 insertions(+), 517 deletions(-)
 create mode 100644 docs/GNUWIN.txt

Tried the installer again and getting the same error..

Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-anidb.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-binaryblacklist.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-category.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-content.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-countries.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-forumpost.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-genres.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-groups.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-menu.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-site.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-tmux.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$ Incorrectly formatted filename 'D:\nzedb\nzedb_dev\resources\db\schema\data\10-tvrage.tsv' (should match ^(?:.*/|)\d+-(?'table'\w+)\.tsv$