[Systems] Maintenance downtime today for OS upgrades

[Samuel Cantero]

Thanks Aleksey! Works perfect!

On Wed, Jul 27, 2016 at 5:06 AM, Aleksey Lim <me at alsroot.su> wrote:

> July 27 2016 6:32 AM, "Samuel Cantero" <scanterog at gmail.com> wrote:
> > Hello guys,
> >
> > I just realized that the statistics for aslo is not working. I execute
> the daily zzz-aslo cron job
> > manually and I get the following error:
> >
> > PHP Notice: MySQL Error 1690: BIGINT UNSIGNED value is out of range in
> > '(`activities`.`collections`.`upvotes` -
> `activities`.`collections`.`downvotes`)'
>
> diff --git a/bin/maintenance.php b/bin/maintenance.php
> index 39ae95b..0a4c00d 100755
> --- a/bin/maintenance.php
> +++ b/bin/maintenance.php
> @@ -592,7 +592,7 @@ switch ($action) {
>              UPDATE collections
>              SET rating=
>                IFNULL(
> -                CAST(upvotes - downvotes AS SIGNED) * LN(upvotes +
> downvotes),
> +                (CAST(upvotes AS SIGNED) - CAST(downvotes AS SIGNED)) *
> LN(upvotes + downvotes),
>                  0)
>          ");
>          $affected_rows = mysql_affected_rows();
>
> --
> Aleksey
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sugarlabs.org/archive/systems/attachments/20160727/359e1826/attachment.html>