Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
anonymous-matomo-user opened this issue Sep 15, 2013 · 2 comments
Closed
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc.

Comments

@anonymous-matomo-user
Copy link

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
Copy link
Member

mattab commented Sep 25, 2013

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
Copy link
Member

mattab commented Sep 25, 2013

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 pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
…orking for you?

Fixes matomo-org#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)
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

No branches or pull requests

2 participants