Author Topic: New Setup - Master/Dev Branch - Incorrectly Formatted Filename  (Read 217882 times)

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
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$
« Last Edit: 2014-04-23, 10:04:08 AM by irishj »

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #1 on: 2014-04-14, 10:43:06 AM »
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.

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #2 on: 2014-04-14, 10:47:23 AM »
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.

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #3 on: 2014-04-14, 10:48:00 AM »
Another issue might be the slash.

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

Line 109 nzedb/db/DbUpdate.php

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #4 on: 2014-04-14, 10:49:49 AM »
This also works : It gets the windows type slash : #^(?:.*[/\\]|)\d+-(?'table'\w+)\.tsv$#

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #5 on: 2014-04-14, 10:51:45 AM »
Actually it needs 4 : #^(?:.*[/\\\\]|)\d+-(?'table'\w+)\.tsv$#

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #6 on: 2014-04-14, 10:58:34 AM »
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

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #7 on: 2014-04-14, 11:06:33 AM »
That warning is fine, Im doing some testing and I'll push that regex change to dev branch.

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #8 on: 2014-04-14, 11:14:26 AM »
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 !

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #9 on: 2014-04-14, 11:19:16 AM »
Hmm not sure about that, we'd have to wait for the guy who made the script to chime in.

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #10 on: 2014-04-14, 01:16:15 PM »
Ok, thanks Kevin...will wait for reply from script writer

Offline kevin123

  • Overlord
  • ******
  • Posts: 456
  • Helpful: +49/-0

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #12 on: 2014-04-15, 08:53:55 AM »
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$

Offline archer

  • Overlord
  • ******
  • Posts: 25
  • Helpful: +5/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #13 on: 2014-04-15, 10:24:25 AM »
Just pushed another change to regex, please test. Better to reply in IRC if you can to make things faster.
Support my tech addiction.

Offline irishj

  • Junior Indexer
  • **
  • Posts: 46
  • Helpful: +0/-0
Re: New Setup - Dev Branch - Incorrectly Formatted Filename
« Reply #14 on: 2014-04-17, 09:06:14 AM »
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$