After upgrade to 0.5.2 evrything wrong

I recently upgraded the Piwik installation from < 0.5 to 0.5.4. Now I get the same error message as the OP but on line 367 of plugins/Actions/Actions.php.

I added the following debug output to this line

                if(!is_object($currentTable)) {
                    $currentTable =& $currentTable[$actionCategory];
                }
                else
                {
                    echo '<pre>';
                    echo 'actionsTablesByType'."\n";
                    var_dump($this->actionsTablesByType[$row['type']]);
                    echo 'currentTable'."\n";
                    var_dump($currentTable);
                    echo 'actionExplodedNames'."\n";
                    var_dump($actionExplodedNames);
                    echo 'row'."\n";
                    var_dump($row);
                    echo '</pre>';
                    die;
                }

and got output like

actionsTablesByType
array(2) {
  ["countries"]=>
  array(10) {
    ["fi"]=>
    array(1) {
      ["cities"]=>
      array(1) {
        ["helsinki"]=>
        object(Piwik_DataTable_Row)#375 (1) {
          ["c"]=>
          array(3) {
            [0]=>
            array(4) {
              ["label"]=>
              string(8) "helsinki"
              ["nb_visits"]=>
              string(1) "1"
              ["nb_uniq_visitors"]=>
              string(1) "1"
              ["nb_hits"]=>
              string(1) "2"
            }
            [1]=>
            array(1) {
              ["url"]=>
              string(29) "/countries/fi/cities/helsinki"
            }
            [3]=>
            NULL
          }
        }
      }
    }
    ["nl"]=>
    array(1) {
      ["cities"]=>
      array(1) {
        ["amsterdam"]=>
        object(Piwik_DataTable_Row)#421 (1) {
          ["c"]=>
          array(3) {
            [0]=>
            array(4) {
              ["label"]=>
              string(9) "amsterdam"
              ["nb_visits"]=>
              string(1) "1"
              ["nb_uniq_visitors"]=>
              string(1) "1"
              ["nb_hits"]=>
              string(1) "1"
            }
            [1]=>
            array(1) {
              ["url"]=>
              string(30) "/countries/nl/cities/amsterdam"
            }
            [3]=>
            NULL
          }
        }
      }
    }
    ["si"]=>
    object(Piwik_DataTable_Row)#430 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "si"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/si"
        }
        [3]=>
        NULL
      }
    }
    ["no"]=>
    array(1) {
      ["cities"]=>
      array(1) {
        ["oslo"]=>
        object(Piwik_DataTable_Row)#426 (1) {
          ["c"]=>
          array(3) {
            [0]=>
            array(4) {
              ["label"]=>
              string(4) "oslo"
              ["nb_visits"]=>
              string(1) "1"
              ["nb_uniq_visitors"]=>
              string(1) "1"
              ["nb_hits"]=>
              string(1) "1"
            }
            [1]=>
            array(1) {
              ["url"]=>
              string(25) "/countries/no/cities/oslo"
            }
            [3]=>
            NULL
          }
        }
      }
    }
    ["at"]=>
    &object(Piwik_DataTable_Row)#432 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "at"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/at"
        }
        [3]=>
        NULL
      }
    }
    ["be"]=>
    object(Piwik_DataTable_Row)#433 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "be"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/be"
        }
        [3]=>
        NULL
      }
    }
    ["hr"]=>
    object(Piwik_DataTable_Row)#435 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "hr"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/hr"
        }
        [3]=>
        NULL
      }
    }
    ["fr"]=>
    object(Piwik_DataTable_Row)#436 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "fr"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/fr"
        }
        [3]=>
        NULL
      }
    }
    ["se"]=>
    object(Piwik_DataTable_Row)#437 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "se"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/se"
        }
        [3]=>
        NULL
      }
    }
    ["ie"]=>
    object(Piwik_DataTable_Row)#439 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(2) "ie"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "1"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(13) "/countries/ie"
        }
        [3]=>
        NULL
      }
    }
  }
  ["example.com"]=>
  array(1) {
    ["/countries/de"]=>
    object(Piwik_DataTable_Row)#410 (1) {
      ["c"]=>
      array(3) {
        [0]=>
        array(4) {
          ["label"]=>
          string(13) "/countries/de"
          ["nb_visits"]=>
          string(1) "1"
          ["nb_uniq_visitors"]=>
          string(1) "1"
          ["nb_hits"]=>
          string(1) "2"
        }
        [1]=>
        array(1) {
          ["url"]=>
          string(43) "http://example.com/countries/de"
        }
        [3]=>
        NULL
      }
    }
  }
}
currentTable
object(Piwik_DataTable_Row)#432 (1) {
  ["c"]=>
  array(3) {
    [0]=>
    array(4) {
      ["label"]=>
      string(2) "at"
      ["nb_visits"]=>
      string(1) "1"
      ["nb_uniq_visitors"]=>
      string(1) "1"
      ["nb_hits"]=>
      string(1) "1"
    }
    [1]=>
    array(1) {
      ["url"]=>
      string(13) "/countries/at"
    }
    [3]=>
    NULL
  }
}
actionExplodedNames
array(4) {
  [0]=>
  string(9) "countries"
  [1]=>
  string(2) "at"
  [2]=>
  string(6) "cities"
  [3]=>
  string(10) "klagenfurt"
}
row
array(5) {
  ["name"]=>
  string(31) "/countries/at/cities/klagenfurt"
  ["type"]=>
  string(1) "2"
  ["nb_visits"]=>
  string(1) "1"
  ["nb_uniq_visitors"]=>
  string(1) "1"
  ["nb_hits"]=>
  string(1) "1"
}

The error occures only on one very recently added website. A website that was added some time ago does not have this problem.

Since January 16th the error occured on one of my sites and the archive.sh returns the same error. Was the problem fixed?

I had used version 0.5.3 an I updated now to 0.5.4. If it is a wrong action type, can I repair the database data? Or what else can I do?

Hmmm, I just got a message from my sysadmin telling me, that my piwik archive.sh doesn’t work anymore.

The errormessages are the same as stated above. Even if I found the “reverted by matt’s review”-remark in your bug-log I tried the “fix” (changeset #1754) again. At least the script runs now…but I afraid I’ll end up with a trashed piwik-database again. :frowning:

BTW: this happened on a fresh piwik 0.5.4 I installed manually from scratch to a completely empty database (ok, completely empty piwik-tables).

Any ideas?

regards

markus

I’ve just started to use Piwik, and have recently installed it on three hosts for different sites. All have been working fine, but one site has just started to have this error message. This instance of Piwik only has one live site, and one (little used) test site - which is behaving fine.

For yesterday and today, I’m getting the message in place of the Last Visits Graph, and the little graphs for Vists Overview & Frequency Overview are missing, although the data is displaying fine.
For Weds this week, though, I’m getting this message in place of every single widget…
For days prior to that, though, everything’s working fine.

It’s PHP 5.1.6 on CentOS 5.4, if it makes much difference.

Best way is update automatically if not possible then find you sure miss any library file.

For users who have the issue, please do the following:

  1. export your Piwik DB,
  2. PM me the URL
  3. also telling which dates does the archiving bug, and which website

I’ll take a look, thanks

[quote=matthieu @ Mar 9 2010, 03:47 PM]For users who have the issue, please do the following:

  1. export your Piwik DB,
  2. PM me the URL
  3. also telling which dates does the archiving bug, and which website

I’ll take a look, thanks[/quote]

PM sent, Matthieu.

Thanks AdrianC! I posted the patch in: http://dev.piwik.org/trac/ticket/1082#comment:28

All, please apply the patch to your Piwik and report here if it fixes the issue for you. Thanks!

Looks to have fixed it for me.