Common errors

Here is a list of common errors that we have seen in GitHub’s issues.

Migration script assumes quote table names are enabled for MySQL

If during migration you experience problems with MySQL with an error like this:

SQLSTATE[42000]: 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

This means you should enable the ANSI_QUOTES of SQL_MODE.

You can do that in your app/config/config.yml file:

# Doctrine Configuration
doctrine:
    dbal:
        # ...
        options:
            # PDO::MYSQL_ATTR_INIT_COMMAND
            1002: "SET SQL_MODE=ANSI_QUOTES"

Related issue

“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

Also, checks your database parameter database_charset.

Related issue