DEV Community

Discussion on: Deploy Laravel application with database to Heroku

Collapse
 
beingwaqas profile image
beingwaqas

Hey,

When I run the migration command

heroku run php artisan migrate

I get the following error:

In Connection.php line 671:

SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for param

eter "client_encoding": "utf8mb4" (SQL: select * from information_schema.ta

bles where table_schema = public and table_name = migrations and table_type

= 'BASE TABLE')

In PostgresConnector.php line 68:

SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for param

eter "client_encoding": "utf8mb4"

Collapse
 
safventure11000 profile image
Josafe Balili • Edited

hmmm. did you set pgsql as your default database? Alt Text