search

spatie / mailcoach-support

Questions and support for Mailcoach
https://mailcoach.app
31 stars 2 forks source link

First Login: A table was not found #257

Closed surjithctly closed 3 years ago

surjithctly commented 3 years ago

After migrating database and creating user, I logged in, but it shows this error.

I tried to rollback and then ran migration again but same error.

Any help?

View error: https://flareapp.io/share/DPyLk86m#F61

image

freekmurze commented 3 years ago

It seems like the correct migration has not run. Did you publish the migration? How does your database/migrations directory look like?

surjithctly commented 3 years ago

I ran php artisan migrate this code.

database/migrations look like this:

image

riasvdv commented 3 years ago

Did you clone https://github.com/spatie/mailcoach? You should use

composer create-project spatie/mailcoach <project-name> to have everything set up correctly.

surjithctly commented 3 years ago

Yes. I used that command only.

Is this folder missing something? In local as well, I got the same files inside /migrations.

This is database looks like:

image

riasvdv commented 3 years ago

These commands should have ran after the create-project, you can try running them manually:

php artisan vendor:publish --tag mailcoach-migrations
php artisan vendor:publish --tag mailcoach-ui-migrations
php artisan mailcoach:prepare-git-ignore
php artisan mailcoach:execute-composer-hook
surjithctly commented 3 years ago

Oh I see. Its never documented, or not seen. Let me try it and get back to you.

riasvdv commented 3 years ago

Its never documented

No, because they normally run automatically. What OS and PHP version are you on?

surjithctly commented 3 years ago

Its a Linode Basic Server, PHP 7.4. Managed by Serverpilot.

Anyway, After running your command, Asked to Install Redis, this also not shown any steps, so found another article. Now I can see the campaigns page finally.

riasvdv commented 3 years ago

You can see the requirements here https://mailcoach.app/docs/v3/app/general/requirements

surjithctly commented 3 years ago

Okay. Now getting the following error on Test Email. after SES setup.

How to fix this?

Error
Class 'Aws\Ses\SesClient' not found
https://mail.web3creative.com/settings/send-test-mail

image

freekmurze commented 3 years ago

Please refer to the Laravel docs to learn how to get started sending mails via SES.

surjithctly commented 3 years ago

Okay. Following Laravel Docs fixed it. But I still wonder why these info missing in docs. Even if its a link to them, if something is definitely needed to work, it should be mentioned right?

surjithctly commented 3 years ago

Also, I checked the debug page and saw this. Is it fine? or any changes required from my side? @freekmurze

image