MySQL Warning: Statement may not be safe to log in statement form #4156

Closed
anonymous-piwik-user opened this Issue Sep 15, 2013 · 2 comments

2 participants

@anonymous-piwik-user

When using replication, MySQL Reports the following error:

mysqld: [Warning] Statement may not be safe to log in statement format. Statement: DELETE FROM piwik_log_conversion_item WHERE idvisit <= '61828' LIMIT 100000

The solution is to add ORDER_BY to the statement. See https://dev.mysql.com/doc/refman/5.1/en/replication-features-limit.html

@mattab
Piwik Open Source Analytics member

In ce6254e: Thanks for the report. Could you apply this patch and confirm it is working for you?

Fixes #4156 Adding ORDER BY clause when DELETING so that it works with replication
https://dev.mysql.com/doc/refman/5.1/en/replication-features-limit.html

@mattab
Piwik Open Source Analytics member

In e1a7aca: Thanks for the report. Could you apply this patch and confirm it is working for you?

Fixes #4156 Adding ORDER BY clause when DELETING so that it works with replication
https://dev.mysql.com/doc/refman/5.1/en/replication-features-limit.html
(cherry picked from commit ce6254e)

@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@mattab mattab Thanks for the report. Could you apply this patch and confirm it is w…
…orking for you?

Fixes #4156 Adding ORDER BY clause when DELETING so that it works with replication
https://dev.mysql.com/doc/refman/5.1/en/replication-features-limit.html
ce6254e
@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@mattab mattab Thanks for the report. Could you apply this patch and confirm it is w…
…orking for you?

Fixes #4156 Adding ORDER BY clause when DELETING so that it works with replication
https://dev.mysql.com/doc/refman/5.1/en/replication-features-limit.html
(cherry picked from commit ce6254e)
e1a7aca
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment