Hi Louis, list, As requested:
> root@pf:~# mysql -upf -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 480 > Server version: 5.5.44-0+deb7u1-log (Debian) > > Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. > > mysql> use pf; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> SELECT > -> SUM(radacct_log.acctinputoctets) AS acctinputoctets, > -> SUM(radacct_log.acctoutputoctets) AS acctoutputoctets, > -> SUM( > -> radacct_log.acctinputoctets + > -> radacct_log.acctoutputoctets > -> ) AS accttotaloctets > -> FROM radacct_log > -> WHERE radacct_log.timestamp BETWEEN '2015-07-18' AND '2015-08-17'; > ERROR 1690 (22003): BIGINT value is out of range in > '(`pf`.`radacct_log`.`acctinputoctets` + > `pf`.`radacct_log`.`acctoutputoctets`)' > mysql> SELECT > -> SUM(radacct_log.acctinputoctets) AS acctinputoctets, > -> SUM(radacct_log.acctoutputoctets) AS acctoutputoctets, > -> SUM( > -> CAST(radacct_log.acctinputoctets AS UNSIGNED ) + > -> CAST(radacct_log.acctoutputoctets AS UNSIGNED) > -> ) AS accttotaloctets > -> FROM radacct_log > -> WHERE radacct_log.timestamp BETWEEN '2015-07-18' AND '2015-08-17'; > +---------------------+---------------------+----------------------+ > | acctinputoctets | acctoutputoctets | accttotaloctets | > +---------------------+---------------------+----------------------+ > | 9223372037051623824 | 9223372038435321394 | 18446744075486945218 | > +---------------------+---------------------+----------------------+ > 1 row in set (0.00 sec) > > mysql> So the second one works a lot better.... ------------------------------------------------------------------------------ _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
