View Issue Details

IDProjectCategoryView StatusLast Update
0000187Bacula-Webbug-phppublic2016-04-20 08:58
ReporterwandihuttelAssigned Todavide 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformDebianOSOS Version
Product Version7.1.0 
Target Version7.2.0Fixed in Version7.2.0 
Summary0000187: Total of bytes per pool problem in Pool and volumes report
DescriptionReported by: wandihuttel

Using a MySQL Bacula catalog, I see zero bytes for each pool in Pools and volumes report page

I've been able to fix it by adding an alias to sum and it worked fine.
$sql = "SELECT SUM(Media.volbytes) as SUM FROM Media WHERE Media.PoolId = '" . $pool['poolid'] . "'";

MySQL version: mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
Steps To ReproduceDisplay Pools and volumes report page using a MySQL Bacula catalog
Additional InformationApache error log shows this error

Undefined index: sum in /var/www/bweb/core/bweb.class.php on line 193
TagsNo tags attached.

Relationships

related to 0000175 closeddavide Display total of Bytes for each Pool 

Activities

davide

2016-04-20 08:58

manager   ~0000537

The problem with MySQL (which is case sensitive) is fixed now.

I'll release a new bugfix/maintenance release (7.1.1) by the new few days.

Regards

Davide

Issue History

Date Modified Username Field Change
2016-04-14 08:34 davide New Issue
2016-04-14 08:34 davide Status new => assigned
2016-04-14 08:34 davide Assigned To => davide
2016-04-14 08:36 davide Reporter davide => wandihuttel
2016-04-14 08:36 davide Target Version => 7.2.0
2016-04-14 08:37 davide Relationship added related to 0000175
2016-04-20 08:58 davide Note Added: 0000537
2016-04-20 08:58 davide Status assigned => resolved
2016-04-20 08:58 davide Fixed in Version => 7.2.0
2016-04-20 08:58 davide Resolution open => fixed