Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#894 closed Bug (fixed)

Problems updating from Piwik 0.1 to trunk

Reported by: vipsoft Owned by: vipsoft
Priority: major Milestone: Piwik 0.4.3
Component: Core Keywords:
Cc: Sensitive:

Description (last modified by vipsoft)

  • warning when updating user_language
  • installer does not prompt to re-use existing tables before database update
  • mandatory updates don't consistently throw Piwik_Updater_UpdateException

Table inconsistencies between fresh install and upgrade path:

  • the 0.2.33 update (utf8 conversion) misses tables created by plugins
  • also in 0.2.33, TEXT fields became MEDIUMTEXT fields
  • in 0.2.27, visit_goal_converted is inconsistent between Piwik.php and the update (VARCHAR vs TINYINT)
  • the 0.2.12 update didn't drop the index_idaction INDEX on log_action table
  • in 0.2.2 (there was no update), feedburnerName changed from NOT NULL to DEFAULT NULL on site table
  • in 0.1.7 (there was no update), location_provider changed from NOT NULL to DEFAULT NULL on log_visit table

Re-open #522:

  • tables created with login column still VARCHAR(20)

Change History (7)

comment:1 Changed 5 years ago by vipsoft (robocoder)

  • Description modified (diff)

comment:2 Changed 5 years ago by vipsoft (robocoder)

  • Resolution set to fixed
  • Status changed from new to closed

(In [1351]) fixes #894, refs #666 - fix problems and inconsistencies between fresh install and upgrade path

Only the utf8 side-effects of converting of TEXT columns to MEDIUMTEXT columns was unchanged.

comment:3 Changed 5 years ago by vipsoft (robocoder)

(In [1352]) refs #894 - a little refactoring

comment:4 Changed 5 years ago by vipsoft (robocoder)

(In [1354]) refs #894 - fix broken Updater.test.php

comment:5 Changed 5 years ago by vipsoft (robocoder)

(In [1355]) refs #894 - generate friendly error message if configuration file exists but points to an empty database

comment:6 Changed 5 years ago by vipsoft (robocoder)

(In [1356]) refs #894 - update comments

comment:7 Changed 5 years ago by vipsoft (robocoder)

(In [1365]) refs #894 - updates for third party plugins

Note: See TracTickets for help on using tickets.