Shopify / Shopify/shopify-app-template-php
Issue when changing database to clearDB mysql in heroku
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 340
- Forks
- 108
- PR merge metrics
- No merged PRs in 30d
Description
Issue summary
The template was working fine with sqlite locally and after moving it into heroku, I changed db to mysql and setup clearDB. Now the app return "could not find driver (SQL: select exists(select * from sessions where shop = xxxx.myshopify.com and access_token is not null) as exists)" error. PDO extension seems available.
Expected behavior
Expected to connect to database and run migration
Actual behavior
When running php artisan migrate, it reurns
Illuminate\Database\QueryException
could not find driver (SQL: select exists(select * from sessions where shop = xxxx.myshopify.com and access_token is not null) as exists)
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the Heroku and ClearDB database configuration used when running php artisan migrate, then reproduce the reported could not find driver error. Done means the app connects to MySQL and the migration completes successfully instead of issuing the QueryException.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- laravel, mysql, php
- Domain
- cloud, database
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100