Announcement

#1 2014-12-23 22:51:49

matthys
Member
2014-04-02
188

MySQL warning

Hello,

I just notice this warning in MySQL, any idea what this is or if I should take any action?

[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave. Statement: UPDATE piwigo_categories AS t1, piwigo_categories_1419362528057973 AS t2
  SET t1.rank = t2.rank
    , t1.global_rank = t2.global_rank
  WHERE t1.id = t2.id

Thanks,
Matthijs

        Piwigo version:  2.7.2
        Operating system: Linux Ubuntu 14.10
        PHP: 5.5.12-2ubuntu4.1 (Show info) [2014-12-23 22:46:56]
        MySQL: 5.5.40-0ubuntu1-log [2014-12-23 22:46:56]
        Graphics Library: External ImageMagick 6.7.7-10
        Piwigo URL: http://www.vanwageningen.net/

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact