Level 104
Are you using a Postgres database?
Aug 1, 2019
13
Level 3
Migration Error on Heroku production.ERROR: SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for parameter "client_encoding": "utf8mb4"
Uploaded a web project to heroku successfully, but after running composer install and php artisan migrate i get *production.ERROR: SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for parameter "client_encoding": "utf8mb4". Please help!
Level 3
@tykus Yes pgsql
Level 104
Check in config/database.php that (i) the correct default connection is being used in production and (ii) that the connection charset is utf8 and not utf8mb4
3 likes
Level 5
Heroku default sets charset to utf8mb4 whiles Laravel sets it to utf8. But it wouldn't work unless the DB_CONNECTION env variable is set to DB_CONNECTION=pgsql. Because this is the only way you can reference the charset in the database configuration file for Postgres.
Level 3
@tykus thanks alot i did not change the default DB connection to pgsql so it was using the charset for default mysql connection which is utf8mb4
1 like
Level 104
i did not change the default DB connection to pgsql so it was using the charset for default mysql connection which is utf8mb4
Ask me how I knew... 😆
Level 1
I encounterred the same error. How did you fix this? I tried to change to from utf8mb4 to utf8 but still not worked. Any solution? I tried to change my tables to utf8 but still not worked. Please help me.
Level 3
@ramzkie are you using a Postgres Database?
Level 21
I am also getting same issue
Level 3
@manish049 Are you using a postgresql database?
Level 21
yes
Level 1
Make your default database connection to look like this 'default' => ('pgsql'),
Level 1
In my own case it happened when I uploaded my .env file to version control. So you need to change default database in your .env file to pgsql
Please or to participate in this conversation.