What is mysql error?

Question

MariaDB

On the mysql5.6 locale, the query works, on the mariadb5.5.4 server it swears at the query

SQLSTATE[HY000]: General error: 2053 (SQL: INSERT IGNORE INTO viewed (user_id, post_id) SELECT users_subscriptions.user_id, data.id FROM users_subscriptions LEFT JOIN data ON data.entity_id = users_subscriptions.entity_id AND data.entity_type = 2 WHERE users_subscriptions.user_id = 2 GROUP BY data.id )

What could be the problem?

Answer 1

I recommend updating Maria to version 10. She is still based on mysql56