Author Topic: 0.7.3.3 2017-06-21  (Read 869 times)

Offline Wally73

  • Overlord
  • ******
  • Posts: 251
  • Helpful: +27/-1
  • i'm nuts
0.7.3.3 2017-06-21
« on: 2017-06-05, 07:59:20 AM »
0.7.3.0 2017-06-05
Changed:
   * tmux configuration adjustments for <= v1.8.
   * Update PC Games support, use Steam and GiantBomb only.
   * The IRCScraper code has been changed to make it properly timezone aware. As before,
    predates are received as UTC/GMT time. However they are not converted using a call to the
    Database server (whose timezone is essentially unknown). Instead, the timezone of the
    connection to the server is used, which we are able to set as part of the ootstrap process.
    By default, this timezone will be the same as the PHP code running the indexer, but it may
    be set to any valid zone by the user.
      Database changes: The 'predate' datetime field is replaced by a 'created' timestamp field
     and a new 'updated' timestamp field is added.
      ***NOTE*** If you have not already done so, you MUST populate the database's timezone tables
     as described in their documentation. For Debian/Ubuntu users 'mysql_tzinfo_to_sql
     /usr/share/zoneinfo | mysql -u root mysql' should load them easily, this will require
     restarting the database server.

      The smarty template now displays the timezone in the Date header so that it is obvious to
     users. There is also an additional field for when the entry was updated.
      Additionally the pager template is switched to the newer paginate.tpl that I have been
     using in the dev-move-to-models branch.
    * Reworked all Anime release naming regexes.


Fixed:
   * Problem with external yEnc decoders (hopefully). Closes issues 2383 and 2435.
   * Path to bootstrap.min.js in Default theme.
   * Path reference to settings.php for View Logs page. Fixes issue 2456.
   * Fixed some fields in *.tsv files being processed incorrectly because it started with a
    double-quote, but didn't end with one.
« Last Edit: 2017-06-22, 08:33:22 AM by Wally73 »

Offline dertbv

  • Junior Indexer
  • **
  • Posts: 30
  • Helpful: +1/-0
Re: 0.7.3.0 2017-06-05
« Reply #1 on: 2017-06-05, 12:19:33 PM »
Getting an error when i run the update..SUCCESS: DELETE FROM release_naming_regexes WHERE id IN (30, 31, 35, 749, 750, 751, 1160, 1161, 1162);
Info: COMMENT: Adjust previous regex
SUCCESS: UPDATE release_naming_regexes SET id = id - 2 WHERE id IN (32, 33, 34);
Error: UPDATE release_naming_regexes SET id = id - 3 WHERE id BETWEEN 752 AND 1159; Failed \{1062}
   Duplicate entry '1030' for key 'PRIMARY'

thoughts?

Offline raclure

  • Newbie
  • *
  • Posts: 0
  • Helpful: +0/-0
Re: 0.7.3.0 2017-06-05
« Reply #2 on: 2017-06-11, 03:24:18 AM »
Mysql Error
(Mysql Version : Server version: 5.7.17 on FreBSD 10.3 jail)
Patch 0479

Error: ALTER TABLE predb
  ADD COLUMN created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
COMMENT 'Unix time of when the pre was created, or first noted by the system' AFTER category,
  ADD COLUMN updated TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
COMMENT 'Unix time of when the entry was last updated' AFTER created; Failed \{1067}
        Invalid default value for 'updated'

UPDATE:

My fault, https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date

My server was started with mode no_zero_date
« Last Edit: 2017-06-11, 03:32:02 AM by raclure »

Offline Wally73

  • Overlord
  • ******
  • Posts: 251
  • Helpful: +27/-1
  • i'm nuts
0.7.3.1 2017-06-09
« Reply #3 on: 2017-06-11, 10:54:28 AM »
0.7.3.1 2017-06-09
Fixed:
   * Steam lookup repeating all the lookups because last pdate date/time wasn't saved properly.

Offline Wally73

  • Overlord
  • ******
  • Posts: 251
  • Helpful: +27/-1
  • i'm nuts
0.7.3.2 2017-06-20
« Reply #4 on: 2017-06-20, 04:44:46 AM »
0.7.3.2 2017-06-20
Fixed:
   * Predb entries not being updated because of error in method signature. This prevented
    IRCScraper from working correctly.
   * Replace overlooked occurences of 'predate' with 'created' in queries. Closes Issue 2474.

also take a look at
Code: [Select]
https://github.com/nZEDb/nZEDb/wiki/Update-Guide when you have issues updating

Offline Wally73

  • Overlord
  • ******
  • Posts: 251
  • Helpful: +27/-1
  • i'm nuts
0.7.3.3 2017-06-21
« Reply #5 on: 2017-06-22, 08:33:10 AM »
0.7.3.3 2017-06-21
Fixed:
   * SQL patch 0482 to update release_renaming_regexes entries.