Changeset 7613


Ignore:
Timestamp:
Jun 29, 2018, 12:12:39 PM (16 months ago)
Author:
mabarracus
Message:

Fix bug mysql > 5.5

Location:
lliurex-analytics-server/trunk/fuentes
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • lliurex-analytics-server/trunk/fuentes/debian/changelog

    r7577 r7613  
     1lliurex-analytics-server (0.3.2) xenial; urgency=medium
     2
     3  * Fix bug mysql > 5.5
     4
     5 -- M.Angel Juan <m.angel.juan@gmail.com>  Fri, 29 Jun 2018 12:11:58 +0200
     6
    17lliurex-analytics-server (0.3.1) xenial; urgency=medium
    28
  • lliurex-analytics-server/trunk/fuentes/lliurex-analytics-server/usr/lib/analytics-server/analytics/db.php

    r7577 r7613  
    413413       
    414414        $sql_nhosts=array();
    415         $sql_nhosts[]="/*Num total hosts detailed*/ create temporary table if not exists nhosts_detail engine=memory as (select * from compat_rf left join (select year,month,rel,fla,ifnull(count(*),0) as total_hosts from (select year(date) as year,month(date) as month,Releases_name as rel,Flavours_name as fla,Client_uid from (select Client_uid,Releases_name,Flavours_name,date from $table order by date desc)t group by year(date),month(date),Client_uid)unique_last_clients group by year,month,rel,fla)detailed using (year,month,rel,fla));";
     415        $sql_nhosts[]="/*Num total hosts detailed*/ create temporary table if not exists nhosts_detail engine=memory as (select * from compat_rf left join (select year,month,rel,fla,ifnull(count(*),0) as total_hosts from (select year(date) as year,month(date) as month,Releases_name as rel,Flavours_name as fla,Client_uid from (select Client_uid,Releases_name,Flavours_name,date from $table order by date desc)t group by year(date),month(date),Releases_name,Flavours_name,Client_uid)unique_last_clients group by year,month,rel,fla)detailed using (year,month,rel,fla));";
    416416        $sql_nhosts[]="/*Num total hosts*/ create temporary table if not exists nhosts engine=memory as (select year,month,sum(total_hosts) as total_hosts from nhosts_detail group by year,month);";
    417417        $sql_upd=array();
Note: See TracChangeset for help on using the changeset viewer.