Here is a list of commong errors that we saw in GitHub's issues.
Migration script assumes quote table names are enabled for MySQL
If during migration you got some problems with MySQL with an error like that:
SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"wallabag_entry" ADD uuid LONGTEXT DEFAULT NULL' at line 1
It means you should enabled the
You can do that in your
# Doctrine Configuration doctrine: dbal: # ... options: # PDO::MYSQL_ATTR_INIT_COMMAND 1002: "SET SQL_MODE=ANSI_QUOTES"
"Incorrect string value" with MySQL
If when adding an article you got a MySQL error like:
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\x89</...'
It means the collation of the database is wrong. MySQL's utf8 doesn't support emoji, utf8mb4 does.
You can update your MySQL server configuration with:
[mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci