WallyJ
3 months ago
749
8
Laravel

Cashier Issue - No Subscriptions Table

Posted 3 months ago by WallyJ

Some time ago I installed Cashier, then gave up on my Braintree integration.

Came back and upgraded my Laravel app to 6.0 and continued with trying to use Stripe instead.

Paused my efforts for a bit, came back, and everything was going swimmingly until I tried to create a subscription. I received this error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'livewire.subscriptions' doesn't exist (SQL: insert into subscriptions (name, stripe_id, stripe_status, stripe_plan, quantity, trial_ends_at, ends_at, user_id, updated_at, created_at) values (Pro, sub_HQ0mXbcjZM4IkC, active, plan_HL5jsx4kxls9W7, 1, ?, ?, 1, 2020-06-06 22:45:09, 2020-06-06 22:45:09))

I then looked to find that there was no "subscriptions" table... so I checked and found there is no migration for that table either. Not sure why this didn't install, though I have moved my app via Laragon a few times.

I figured I would "reinstall" Cashier. But when I run:

composer require laravel/cashier

I get this:

The "https://repo.packagist.org/packages.json" file could not be downloaded: SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed Failed to enable crypto failed to open stream: operation failed https://repo.packagist.org could not be fully loaded, package information was loaded from the local cache and may be out of date

[Composer\Downloader\TransportException] The "https://packagist.org/p/laravel/cashier%245c4d356393720d50a9e647db17075c43fc310cbb72d4e700636f870c4b9be393.json" file could not b e downloaded: SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed Failed to enable crypto failed to open stream: operation failed

require [--dev] [--prefer-source] [--prefer-dist] [--no-progress] [--no-suggest] [--no-update] [--no-scripts] [--update-no-dev] [--update-with-dependencies] [--update-with-all-dependencies] [--ignore-platform-reqs] [--prefer-stable] [--prefer-lowest] [--sort-packages] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--] []...

How do I fix this?

Please sign in or create an account to participate in this conversation.