No weekly, monthly, yearly stats in Flash charts #811

Reported by maxhb (Marc) on the forum.

Daily stats work and Marc reports there are recorded visits in log_visits and the archive tables have rows for all period types.

Entering the data-file URL into the browser's address bar, I get the error:

Fatal error: Call to undefined method Piwik_DataTable_Array::getColumn() in /usr/home/quadra/quadracom.de_subdomains/piwik/core/ViewDataTable/GenerateGraphData.php on line 127

Piwik 0.4; Apache 2.2.2; PHP 5.2.0

Ok, I shouldn't be debugging in the wee hours of the morning -- I must have typo'd it because now I get the message:

{ "elements": [ ], "title": { "text": "No data for this graph", "style": "{font-size: 25px;}" }, "num_decimals": 0, "is_fixed_num_decimals_forced": true, "is_decimal_separator_comma": false, "is_thousand_separator_disabled": false, "x_axis": { "colour": "<a href='/596171'>#596171</a>", "grid-colour": "#E0E1E4", "steps": 2, "labels": { "size": 11, "labels": [ ], "steps": 2 } }, "y_axis": { "colour": "#ffffff", "grid-colour": "#E0E1E4", "min": 0, "max": 1, "steps": 0 }, "tooltip": { "shadow": true, "stroke": 1 }, "bg_colour": "#ffffff" }

Further investigation required.

Marc writes, "Deleteing and recreating those tables on online server did NOT work." (FreeBSD, Apache 2.2.2, PHP 5.2.0, mySQL 4.1.19) However, it worked in his dev environment. (Debian, PHP 5.2.6, mySQL 5.0.32)

http://forum.piwik.org/index.php?showtopic=1088

Unable to reproduce. Re-open if new information available.

Marc reports that upgrading to 5.2.10 fixed the problem.

Probably should recommend that non-Linux users use the latest PHP versions as these tend to lag Linux in terms of platform compatibility. eg http://bugs.php.net/bug.php?id=45044