Can anyone please help. I am trying to install this extension, but keep getting this error (logs):
Info:
FLARUM 0.1.0-BETA.15
PHP 7.4.11
MySQL 10.1.41-MariaDB
askvortsov/flarum-pwa (v2.0.4)
minishlink web push v5.2.5
Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxx_xxxxx.mfpush_subscriptions' doesn't exist (SQL: alter tablemfpush_subscriptionsdrop indexmfpush_subscriptions_endpoint_unique) in /home/xxx/xxx/vendor/illuminate/database/Connection.php:669
Stack trace:
#0 /home/xxx/xxx/vendor/illuminate/database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('alter tablemf...', Array, Object(Closure))
#1 /home/xxx/xxx/vendor/illuminate/database/Connection.php(464): Illuminate\Database\Connection->run('alter table mf...', Array, Object(Closure))
#2 /home/xxx/xxx/vendor/illuminate/database/Schema/Blueprint.php(97): Illuminate\Database\Connection->statement('alter tablemf...')
#3 /home/xxx/xxx/vendor/illuminate/database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /home/xxx/xxx/vendor/illuminate/database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /home/xxx/xxx/vendor/askvortsov/flarum-pwa/migrations/2020_08_02_000001_remove_unique_constraint.php(19): Illuminate\Database\Schema\Builder->table('push_subscripti...', Object(Closure))
#6 [internal function]: Illuminate\Filesystem\Filesystem->{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))`
(...)
Tried this:
php flarum migrate:reset --extension askvortsov-pwa
after this got error:
[2021-02-27 18:28:38] flarum.ERROR: Doctrine\DBAL\Schema\SchemaException: There is no column with name 'endpoint' on table 'mfpush_subscriptions'. in /home/xxx/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86
Stack trace:
#0 /home/xxx/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php(711): Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist('endpoint', 'mfpush_subscrip...')
#1 /home/xxx/xxx/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php(342): Doctrine\DBAL\Schema\Table->getColumn('endpoint')
#2 /home/xxx/xxx/vendor/illuminate/database/Schema/Grammars/ChangeColumn.php(106): Doctrine\DBAL\Schema\Table->changeColumn('endpoint', Array)
#3 /home/xxx/xxx/vendor/illuminate/database/Schema/Grammars/ChangeColumn.php(76): Illuminate\Database\Schema\Grammars\ChangeColumn::getDoctrineColumn(Object(Doctrine\DBAL\Schema\Table), Object(Illuminate\Database\Schema\ColumnDefinition))
#4 /home/xxx/xxx/vendor/illuminate/database/Schema/Grammars/ChangeColumn.php(60): Illuminate\Database\Schema\Grammars\ChangeColumn::getTableWithColumnChanges(Object(Illuminate\Database\Schema\Blueprint), Object(Doctrine\DBAL\Schema\Table))
#5 /home/xxx/xxx/vendor/illuminate/database/Schema/Grammars/ChangeColumn.php(37): Illuminate\Database\Schema\Grammars\ChangeColumn::getChangedDiff(Object(Illuminate\Database\Schema\Grammars\MySqlGrammar), Object(Illuminate\Database\Schema\Blueprint), Object(Doctrine\DBAL\Schema\MySqlSchemaManager))
#6 /home/xxx/xxx/vendor/illuminate/database/Schema/Grammars/Grammar.php(55): Illuminate\Database\Schema\Grammars\ChangeColumn::compile(Object(Illuminate\Database\Schema\Grammars\MySqlGrammar), Object(Illuminate\Database\Schema\Blueprint), Object(Illuminate\Support\Fluent), Object(Illuminate\Database\MySqlConnection))
#7 /home/xxx/xxx/vendor/illuminate/database/Schema/Blueprint.php(123): Illuminate\Database\Schema\Grammars\Grammar->compileChange(Object(Illuminate\Database\Schema\Blueprint), Object(Illuminate\Support\Fluent), Object(Illuminate\Database\MySqlConnection))
#8 /home/xxx/xxx/vendor/illuminate/database/Schema/Blueprint.php(96): Illuminate\Database\Schema\Blueprint->toSql(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#9 /home/xxx/xxx/vendor/illuminate/database/Schema/Builder.php(290): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#10 /home/xxx/xxx/vendor/illuminate/database/Schema/Builder.php(151): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#11 /home/xxx/xxx/vendor/askvortsov/flarum-pwa/migrations/2020_08_02_000000_change_endpoint_collation.php(19): Illuminate\Database\Schema\Builder->table('push_subscripti...', Object(Closure))
#12 [internal function]: Illuminate\Filesystem\Filesystem->{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
