Wave install impossible
I am trying to install Wave:
PS C:\wamp64\www\skills> composer install composer : Installing dependencies from lock file (including require-dev) Au caractère Ligne:1 : 1
- composer install
-
+ CategoryInfo : NotSpecified: (Installing depe...ng require-dev):String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError
Verifying lock file contents can be installed on current platform.
Your lock file does not contain a compatible set of packages. Please run composer update.
Problem 1
- Root composer.json requires PHP extension ext-redis * but it is missing from your system. Install or enable PHP's redis
extension.
Problem 2
- lcobucci/jwt is locked to version 4.2.1 and an update of this package was not requested.
- lcobucci/jwt 4.2.1 requires ext-sodium * -> it is missing from your system. Install or enable PHP's sodium extension.
Problem 3
- lcobucci/jwt 4.2.1 requires ext-sodium * -> it is missing from your system. Install or enable PHP's sodium extension.
- tymon/jwt-auth dev-develop requires lcobucci/jwt ^3.4|^4.0 -> satisfiable by lcobucci/jwt[4.2.1].
- tymon/jwt-auth is locked to version dev-develop and an update of this package was not requested.
To enable extensions, verify that they are enabled in your .ini files:
- C:\wamp64\bin\php\php8.0.13\php.ini
You can also run php --ini in a terminal to see which files are used by PHP in CLI mode.
Alternatively, you can run Composer with --ignore-platform-req=ext-redis --ignore-platform-req=ext-sodium to temporarily ignore
these required extensions.
PS C:\wamp64\www\skills> composer install --ignore-platform-req=ext-redis --ignore-platform-req=ext-sodium composer : Installing dependencies from lock file (including require-dev) Au caractère Ligne:1 : 1
- composer install --ignore-platform-req=ext-redis --ignore-platform-re ...
-
+ CategoryInfo : NotSpecified: (Installing depe...ng require-dev):String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError
Verifying lock file contents can be installed on current platform. Package operations: 129 installs, 0 updates, 0 removals
- Downloading pestphp/pest-plugin (v1.1.0)
- Downloading devdojo/app (0.11)
- Downloading devdojo/themes (0.0.7)
- Downloading doctrine/cache (2.2.0)
- Downloading doctrine/deprecations (v1.0.0)
- Downloading doctrine/event-manager (1.2.0)
- Downloading doctrine/inflector (2.0.6)
- Downloading doctrine/lexer (1.2.3)
- Downloading symfony/polyfill-ctype (v1.26.0)
- Downloading webmozart/assert (1.11.0)
- Downloading dragonmantank/cron-expression (v3.3.2)
- Downloading symfony/deprecation-contracts (v3.0.2)
- Downloading psr/container (2.0.2)
- Downloading fakerphp/faker (v1.20.0)
- Downloading symfony/polyfill-mbstring (v1.26.0)
- Downloading symfony/http-foundation (v6.0.15)
- Downloading fruitcake/php-cors (v1.2.0)
- Downloading psr/http-client (1.0.1)
- Downloading ralouphie/getallheaders (3.0.3)
- Downloading psr/http-factory (1.0.1)
- Downloading guzzlehttp/psr7 (2.4.3)
- Downloading guzzlehttp/promises (1.5.2)
- Downloading guzzlehttp/guzzle (7.5.0)
- Downloading voku/portable-ascii (2.0.1)
- Downloading symfony/polyfill-php80 (v1.26.0)
- Downloading phpoption/phpoption (1.9.0)
- Downloading graham-campbell/result-type (v1.1.0)
- Downloading vlucas/phpdotenv (v5.5.0)
- Downloading symfony/css-selector (v6.0.11)
- Downloading tijsverkoyen/css-to-inline-styles (2.2.5)
- Downloading symfony/var-dumper (v6.0.14)
- Downloading symfony/polyfill-uuid (v1.26.0)
- Downloading symfony/uid (v6.0.13)
- Downloading symfony/routing (v6.0.15)
- Downloading symfony/process (v6.0.11)
- Downloading symfony/polyfill-php72 (v1.26.0)
- Downloading symfony/polyfill-intl-normalizer (v1.26.0)
- Downloading symfony/polyfill-intl-idn (v1.26.0)
- Downloading symfony/mime (v6.0.14)
- Downloading symfony/service-contracts (v3.0.2)
- Downloading psr/event-dispatcher (1.0.0)
- Downloading symfony/event-dispatcher-contracts (v3.0.2)
- Downloading symfony/event-dispatcher (v6.0.9)
- Downloading psr/log (3.0.0)
- Downloading egulias/email-validator (3.2.1)
- Downloading symfony/mailer (v6.0.15)
- Downloading symfony/error-handler (v6.0.15)
- Downloading symfony/http-kernel (v6.0.15)
- Downloading symfony/finder (v6.0.11)
- Downloading symfony/polyfill-intl-grapheme (v1.26.0)
- Downloading symfony/string (v6.0.15)
- Downloading symfony/console (v6.0.15)
- Downloading symfony/polyfill-php81 (v1.26.0)
- Downloading ramsey/collection (1.2.2)
- Downloading brick/math (0.10.2)
- Downloading ramsey/uuid (4.5.1)
- Downloading psr/simple-cache (3.0.0)
- Downloading nunomaduro/termwind (v1.14.2)
- Downloading symfony/translation-contracts (v3.0.2)
- Downloading symfony/translation (v6.0.14)
- Downloading nesbot/carbon (2.62.1)
- Downloading monolog/monolog (2.8.0)
- Downloading league/mime-type-detection (1.11.0)
- Downloading league/flysystem (3.10.2)
- Downloading nette/utils (v3.2.8)
- Downloading nette/schema (v1.2.2)
- Downloading dflydev/dot-access-data (v3.0.2)
- Downloading league/config (v1.1.1)
- Downloading league/commonmark (2.3.6)
- Downloading laravel/serializable-closure (v1.2.2)
- Downloading laravel/framework (v9.37.0)
- Downloading lab404/laravel-impersonate (1.7.3)
- Downloading php-webdriver/webdriver (1.13.1)
- Downloading laravel/dusk (v6.25.2)
- Downloading laravel/sail (v1.16.2)
- Downloading nikic/php-parser (v4.15.1)
- Downloading psy/psysh (v0.11.8)
- Downloading laravel/tinker (v2.7.2)
- Downloading stella-maris/clock (0.1.6)
- Downloading lcobucci/clock (2.2.0)
- Downloading livewire/livewire (v2.10.7)
- Downloading hamcrest/hamcrest-php (v2.0.1)
- Downloading mockery/mockery (1.5.1)
- Downloading filp/whoops (2.14.5)
- Downloading nunomaduro/collision (v6.3.1)
- Downloading sebastian/version (3.0.2)
- Downloading sebastian/type (3.2.0)
- Downloading sebastian/resource-operations (3.0.3)
- Downloading sebastian/recursion-context (4.0.4)
- Downloading sebastian/object-reflector (2.0.4)
- Downloading sebastian/object-enumerator (4.0.4)
- Downloading sebastian/global-state (5.0.5)
- Downloading sebastian/exporter (4.0.5)
- Downloading sebastian/environment (5.1.4)
- Downloading sebastian/diff (4.0.4)
- Downloading sebastian/comparator (4.0.8)
- Downloading sebastian/code-unit (1.0.8)
- Downloading sebastian/cli-parser (1.0.1)
- Downloading phpunit/php-timer (5.0.3)
- Downloading phpunit/php-text-template (2.0.4)
- Downloading phpunit/php-invoker (3.1.1)
- Downloading phpunit/php-file-iterator (3.0.6)
- Downloading theseer/tokenizer (1.2.1)
- Downloading sebastian/lines-of-code (1.0.3)
- Downloading sebastian/complexity (2.0.2)
- Downloading sebastian/code-unit-reverse-lookup (2.0.3)
- Downloading phpunit/php-code-coverage (9.2.18)
- Downloading phar-io/version (3.2.1)
- Downloading phar-io/manifest (2.0.3)
- Downloading myclabs/deep-copy (1.11.0)
- Downloading doctrine/instantiator (1.4.1)
- Downloading phpunit/phpunit (9.5.26)
- Downloading pestphp/pest (v1.22.1)
- Downloading pestphp/pest-plugin-laravel (v1.3.0)
- Downloading spatie/backtrace (1.2.1)
- Downloading spatie/flare-client-php (1.3.0)
- Downloading spatie/ignition (1.4.1)
- Downloading spatie/laravel-ignition (1.6.1)
- Downloading laravel/ui (v4.0.2)
- Downloading doctrine/dbal (2.13.9)
- Downloading larapack/doctrine-support (v0.1.9)
- Downloading intervention/image (2.7.2)
- Downloading arrilot/laravel-widgets (3.13.1)
- Downloading tcg/voyager (1.5.x-dev 4f3ba99)
- Downloading namshi/jose (7.2.3)
- Downloading lcobucci/jwt (4.2.1)
- Downloading tymon/jwt-auth (dev-develop 014be8d) 0/127 [>---------------------------] 0% 1/127 [>---------------------------] 0% 10/127 [==>-------------------------] 7% 13/127 [==>-------------------------] 10% 14/127 [===>------------------------] 11% 15/127 [===>------------------------] 11% 16/127 [===>------------------------] 12% 17/127 [===>------------------------] 13% 20/127 [====>-----------------------] 15% 23/127 [=====>----------------------] 18% 25/127 [=====>----------------------] 19% 27/127 [=====>----------------------] 21% 31/127 [======>---------------------] 24% 36/127 [=======>--------------------] 28% 39/127 [========>-------------------] 30% 45/127 [=========>------------------] 35% 47/127 [==========>-----------------] 37% 51/127 [===========>----------------] 40% 53/127 [===========>----------------] 41% 54/127 [===========>----------------] 42% 57/127 [============>---------------] 44% 59/127 [=============>--------------] 46% 60/127 [=============>--------------] 47% 61/127 [=============>--------------] 48% 63/127 [=============>--------------] 49% 64/127 [==============>-------------] 50% 68/127 [==============>-------------] 53% 69/127 [===============>------------] 54% 70/127 [===============>------------] 55% 71/127 [===============>------------] 55% 74/127 [================>-----------] 58% 75/127 [================>-----------] 59% 77/127 [================>-----------] 60% 78/127 [=================>----------] 61% 79/127 [=================>----------] 62% 80/127 [=================>----------] 62% 81/127 [=================>----------] 63% 82/127 [==================>---------] 64% 93/127 [====================>-------] 73% 102/127 [======================>-----] 80% 111/127 [========================>---] 87% 115/127 [=========================>--] 90% 121/127 [==========================>-] 95% 122/127 [==========================>-] 96% 125/127 [===========================>] 98% 126/127 [===========================>] 99% 127/127 [============================] 100%
- Installing pestphp/pest-plugin (v1.1.0): Extracting archive
- Installing devdojo/app (0.11): Extracting archive
- Installing devdojo/themes (0.0.7): Extracting archive
- Installing doctrine/cache (2.2.0): Extracting archive
- Installing doctrine/deprecations (v1.0.0): Extracting archive
- Installing doctrine/event-manager (1.2.0): Extracting archive
- Installing doctrine/inflector (2.0.6): Extracting archive
- Installing doctrine/lexer (1.2.3): Extracting archive
- Installing symfony/polyfill-ctype (v1.26.0): Extracting archive
- Installing webmozart/assert (1.11.0): Extracting archive
- Installing dragonmantank/cron-expression (v3.3.2): Extracting archive
- Installing symfony/deprecation-contracts (v3.0.2): Extracting archive
- Installing psr/container (2.0.2): Extracting archive
- Installing fakerphp/faker (v1.20.0): Extracting archive
- Installing symfony/polyfill-mbstring (v1.26.0): Extracting archive
- Installing symfony/http-foundation (v6.0.15): Extracting archive
- Installing fruitcake/php-cors (v1.2.0): Extracting archive
- Installing psr/http-message (1.0.1): Extracting archive
- Installing psr/http-client (1.0.1): Extracting archive
- Installing ralouphie/getallheaders (3.0.3): Extracting archive
- Installing psr/http-factory (1.0.1): Extracting archive
- Installing guzzlehttp/psr7 (2.4.3): Extracting archive
- Installing guzzlehttp/promises (1.5.2): Extracting archive
- Installing guzzlehttp/guzzle (7.5.0): Extracting archive
- Installing voku/portable-ascii (2.0.1): Extracting archive
- Installing symfony/polyfill-php80 (v1.26.0): Extracting archive
- Installing phpoption/phpoption (1.9.0): Extracting archive
- Installing graham-campbell/result-type (v1.1.0): Extracting archive
- Installing vlucas/phpdotenv (v5.5.0): Extracting archive
- Installing symfony/css-selector (v6.0.11): Extracting archive
- Installing tijsverkoyen/css-to-inline-styles (2.2.5): Extracting archive
- Installing symfony/var-dumper (v6.0.14): Extracting archive
- Installing symfony/polyfill-uuid (v1.26.0): Extracting archive
- Installing symfony/uid (v6.0.13): Extracting archive
- Installing symfony/routing (v6.0.15): Extracting archive
- Installing symfony/process (v6.0.11): Extracting archive
- Installing symfony/polyfill-php72 (v1.26.0): Extracting archive
- Installing symfony/polyfill-intl-normalizer (v1.26.0): Extracting archive
- Installing symfony/polyfill-intl-idn (v1.26.0): Extracting archive
- Installing symfony/mime (v6.0.14): Extracting archive
- Installing symfony/service-contracts (v3.0.2): Extracting archive
- Installing psr/event-dispatcher (1.0.0): Extracting archive
- Installing symfony/event-dispatcher-contracts (v3.0.2): Extracting archive
- Installing symfony/event-dispatcher (v6.0.9): Extracting archive
- Installing psr/log (3.0.0): Extracting archive
- Installing egulias/email-validator (3.2.1): Extracting archive
- Installing symfony/mailer (v6.0.15): Extracting archive
- Installing symfony/error-handler (v6.0.15): Extracting archive
- Installing symfony/http-kernel (v6.0.15): Extracting archive
- Installing symfony/finder (v6.0.11): Extracting archive
- Installing symfony/polyfill-intl-grapheme (v1.26.0): Extracting archive
- Installing symfony/string (v6.0.15): Extracting archive
- Installing symfony/console (v6.0.15): Extracting archive
- Installing symfony/polyfill-php81 (v1.26.0): Extracting archive
- Installing ramsey/collection (1.2.2): Extracting archive
- Installing brick/math (0.10.2): Extracting archive
- Installing ramsey/uuid (4.5.1): Extracting archive
- Installing psr/simple-cache (3.0.0): Extracting archive
- Installing nunomaduro/termwind (v1.14.2): Extracting archive
- Installing symfony/translation-contracts (v3.0.2): Extracting archive
- Installing symfony/translation (v6.0.14): Extracting archive
- Installing nesbot/carbon (2.62.1): Extracting archive
- Installing monolog/monolog (2.8.0): Extracting archive
- Installing league/mime-type-detection (1.11.0): Extracting archive
- Installing league/flysystem (3.10.2): Extracting archive
- Installing nette/utils (v3.2.8): Extracting archive
- Installing nette/schema (v1.2.2): Extracting archive
- Installing dflydev/dot-access-data (v3.0.2): Extracting archive
- Installing league/config (v1.1.1): Extracting archive
- Installing league/commonmark (2.3.6): Extracting archive
- Installing laravel/serializable-closure (v1.2.2): Extracting archive
- Installing laravel/framework (v9.37.0): Extracting archive
- Installing lab404/laravel-impersonate (1.7.3): Extracting archive
- Installing php-webdriver/webdriver (1.13.1): Extracting archive
- Installing laravel/dusk (v6.25.2): Extracting archive
- Installing laravel/sail (v1.16.2): Extracting archive
- Installing nikic/php-parser (v4.15.1): Extracting archive
- Installing psy/psysh (v0.11.8): Extracting archive
- Installing laravel/tinker (v2.7.2): Extracting archive
- Installing stella-maris/clock (0.1.6): Extracting archive
- Installing lcobucci/clock (2.2.0): Extracting archive
- Installing livewire/livewire (v2.10.7): Extracting archive
- Installing hamcrest/hamcrest-php (v2.0.1): Extracting archive
- Installing mockery/mockery (1.5.1): Extracting archive
- Installing filp/whoops (2.14.5): Extracting archive
- Installing nunomaduro/collision (v6.3.1): Extracting archive
- Installing sebastian/version (3.0.2): Extracting archive
- Installing sebastian/type (3.2.0): Extracting archive
- Installing sebastian/resource-operations (3.0.3): Extracting archive
- Installing sebastian/recursion-context (4.0.4): Extracting archive
- Installing sebastian/object-reflector (2.0.4): Extracting archive
- Installing sebastian/object-enumerator (4.0.4): Extracting archive
- Installing sebastian/global-state (5.0.5): Extracting archive
- Installing sebastian/exporter (4.0.5): Extracting archive
- Installing sebastian/environment (5.1.4): Extracting archive
- Installing sebastian/diff (4.0.4): Extracting archive
- Installing sebastian/comparator (4.0.8): Extracting archive
- Installing sebastian/code-unit (1.0.8): Extracting archive
- Installing sebastian/cli-parser (1.0.1): Extracting archive
- Installing phpunit/php-timer (5.0.3): Extracting archive
- Installing phpunit/php-text-template (2.0.4): Extracting archive
- Installing phpunit/php-invoker (3.1.1): Extracting archive
- Installing phpunit/php-file-iterator (3.0.6): Extracting archive
- Installing theseer/tokenizer (1.2.1): Extracting archive
- Installing sebastian/lines-of-code (1.0.3): Extracting archive
- Installing sebastian/complexity (2.0.2): Extracting archive
- Installing sebastian/code-unit-reverse-lookup (2.0.3): Extracting archive
- Installing phpunit/php-code-coverage (9.2.18): Extracting archive
- Installing phar-io/version (3.2.1): Extracting archive
- Installing phar-io/manifest (2.0.3): Extracting archive
- Installing myclabs/deep-copy (1.11.0): Extracting archive
- Installing doctrine/instantiator (1.4.1): Extracting archive
- Installing phpunit/phpunit (9.5.26): Extracting archive
- Installing pestphp/pest (v1.22.1): Extracting archive
- Installing pestphp/pest-plugin-laravel (v1.3.0): Extracting archive
- Installing spatie/backtrace (1.2.1): Extracting archive
- Installing spatie/flare-client-php (1.3.0): Extracting archive
- Installing spatie/ignition (1.4.1): Extracting archive
- Installing spatie/laravel-ignition (1.6.1): Extracting archive
- Installing symfony/polyfill-php56 (v1.20.0)
- Installing laravel/ui (v4.0.2): Extracting archive
- Installing doctrine/dbal (2.13.9): Extracting archive
- Installing larapack/doctrine-support (v0.1.9): Extracting archive
- Installing intervention/image (2.7.2): Extracting archive
- Installing arrilot/laravel-widgets (3.13.1): Extracting archive
- Installing tcg/voyager (1.5.x-dev 4f3ba99): Extracting archive
- Installing namshi/jose (7.2.3): Extracting archive
- Installing lcobucci/jwt (4.2.1): Extracting archive
- Installing tymon/jwt-auth (dev-develop 014be8d): Extracting archive 0/117 [>---------------------------] 0% 10/117 [==>-------------------------] 8% 20/117 [====>-----------------------] 17% 30/117 [=======>--------------------] 25% 40/117 [=========>------------------] 34% 50/117 [===========>----------------] 42% 60/117 [==============>-------------] 51% 70/117 [================>-----------] 59% 80/117 [===================>--------] 68% 90/117 [=====================>------] 76% 100/117 [=======================>----] 85% 110/117 [==========================>-] 94% 117/117 [============================] 100% Generating optimized autoload files
Illuminate\Foundation\ComposerScripts::postAutoloadDump @php artisan package:discover
INFO Discovering packages.
arrilot/laravel-widgets ....................................................................................... DONE intervention/image ............................................................................................ DONE lab404/laravel-impersonate .................................................................................... DONE larapack/doctrine-support ..................................................................................... DONE laravel/dusk .................................................................................................. DONE laravel/sail .................................................................................................. DONE laravel/tinker ................................................................................................ DONE laravel/ui .................................................................................................... DONE livewire/livewire ............................................................................................. DONE nesbot/carbon ................................................................................................. DONE nunomaduro/collision .......................................................................................... DONE nunomaduro/termwind ........................................................................................... DONE pestphp/pest .................................................................................................. DONE spatie/laravel-ignition ....................................................................................... DONE tcg/voyager ................................................................................................... DONE tymon/jwt-auth ................................................................................................ DONE
@php artisan storage:link
INFO The [C:\wamp64\www\skills\public\storage] link has been connected to [C:\wamp64\www\skills\storage\app/public].
INFO The [C:\wamp64\www\skills\public\wave/docs] link has been connected to [C:\wamp64\www\skills\wave/docs].
94 packages you are using are looking for funding.
Use the composer fund command to find out more!
PS C:\wamp64\www\skills> composer update composer : Loading composer repositories with package information Au caractère Ligne:1 : 1
- composer update
-
+ CategoryInfo : NotSpecified: (Loading compose...age information:String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError
Info from https://repo.packagist.org: #StandWithUkraine
Updating dependencies
Your requirements could not be resolved to an installable set of packages.
Problem 1
- Root composer.json requires PHP extension ext-redis * but it is missing from your system. Install or enable PHP's redis
extension.
To enable extensions, verify that they are enabled in your .ini files:
- C:\wamp64\bin\php\php8.0.13\php.ini
You can also run php --ini in a terminal to see which files are used by PHP in CLI mode.
Alternatively, you can run Composer with --ignore-platform-req=ext-redis to temporarily ignore these required extensions.
PS C:\wamp64\www\skills> php artisan migrate
INFO Preparing database.
Creating migration table ................................................................................. 15ms DONE
INFO Running migrations.
2014_10_12_000000_create_users_table ..................................................................... 38ms DONE 2014_10_12_100000_create_password_resets_table ........................................................... 52ms DONE 2016_01_01_000000_add_voyager_user_fields ................................................................ 27ms DONE 2016_01_01_000000_create_data_types_table ............................................................... 103ms DONE 2016_01_01_000000_create_pages_table ..................................................................... 43ms DONE 2016_01_01_000000_create_posts_table ..................................................................... 38ms DONE 2016_02_15_204651_create_categories_table ................................................................ 62ms DONE 2016_05_19_173453_create_menu_table ...................................................................... 75ms DONE 2016_10_21_190000_create_roles_table ..................................................................... 34ms DONE 2016_10_21_190000_create_settings_table .................................................................. 35ms DONE 2016_11_30_135954_create_permission_table ................................................................ 39ms DONE 2016_11_30_141208_create_permission_role_table .......................................................... 127ms DONE 2016_12_26_201236_data_types__add__server_side ........................................................... 23ms DONE 2017_01_13_000000_add_route_to_menu_items_table .......................................................... 23ms DONE 2017_01_14_005015_create_translations_table .............................................................. 15ms FAIL
Illuminate\Database\QueryException
SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 (SQL: alter table transl ations add unique translations_table_name_column_name_foreign_key_locale_unique(table_name, column_name, foreign_key, loca le))
at C:\wamp64\www\skills\vendor\laravel\framework\src\Illuminate\Database\Connection.php:760 756▕ // If an exception occurs when attempting to run a query, we'll format the error 757▕ // message to include the bindings with SQL, which will make this exception a 758▕ // lot more helpful to the developer instead of just the database's errors. 759▕ catch (Exception $e) { ➜ 760▕ throw new QueryException( 761▕ $query, $this->prepareBindings($bindings), $e 762▕ ); 763▕ } 764▕ }
1 C:\wamp64\www\skills\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDO\Exception.php:18 Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueu r maximale: 1000")
2 C:\wamp64\www\skills\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:119 Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
PS C:\wamp64\www\skills> php artisan db:seed
INFO Seeding database.
Database\Seeders\RolesTableSeeder .......................................................................... RUNNING
Database\Seeders\RolesTableSeeder ..................................................................... 1.99 ms DONE
Database\Seeders\UsersTableSeeder .......................................................................... RUNNING
Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Champ 'card_brand' inconnu dans field list (SQL: insert into users (avatar, card_brand, card_last_four, created_at, email, id, name, password, rememb er_token, role_id, settings, stripe_id, trial_ends_at, updated_at, username, verification_code, verified) values (users/default.png, ?, ?, 2017-11-21 16:07:22, [email protected], 1, Wave Admin, $
2y$10$L8MjmjVVOCbyLHbp7pq/9.1ZEEa5AqE67ZXLd2M4.res05a3Rz/G2, 4oXDVo48Lm1pc4j7NkWI9cMO4hv5OIEJFMrqjSCKQsIwWMGRFYDvNpdioBfo, 1, ?, ?, ?, 2018-09-22 23:34:02, admin, ?, 1))
at C:\wamp64\www\skills\vendor\laravel\framework\src\Illuminate\Database\Connection.php:760 756▕ // If an exception occurs when attempting to run a query, we'll format the error 757▕ // message to include the bindings with SQL, which will make this exception a 758▕ // lot more helpful to the developer instead of just the database's errors. 759▕ catch (Exception $e) { ➜ 760▕ throw new QueryException( 761▕ $query, $this->prepareBindings($bindings), $e 762▕ ); 763▕ } 764▕ }
i A column was not found: You might have forgotten to run your database migrations. https://laravel.com/docs/master/migrations#running-migrations
1 C:\wamp64\www\skills\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDO\Exception.php:18 Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[42S22]: Column not found: 1054 Champ 'card_brand' inconnu dans field list")
2 C:\wamp64\www\skills\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:87 Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
PS C:\wamp64\www\skills>
I installed redis ext and activated both the errors remain. Too much errors just at the first step, I am stuck.
Any help is welcome.
Hi there,
The Redis extension is not necessary but you need the sodium extension in order for everything to work as expected.
If you run php --ini do you see the extension in the list? If not follow these steps here on how to install sodum on WAMPL:
- Download the libsodium here: libsodium
- Extract the downloaded file and copy the
libsodium.dllfile to thewamp->bin->php->php(x).x.xxfolder - Next copy the
php_libsodium.dllfile from the extracted directory towamp->bin->php->php(x).x.xx ->extfolder - After that click on the WAMP System tray icon. Go to PHP -> PHP Settings and Click on the enabled from the menu of the WampManager from the system tray
- Then add the following line to
php.inifrom PHP ->php.inifrom the menu of Wampmanager, save and close it:
extension=php_libsodium.dll
Then Restart Apache.
You should now get your php_libsodium in the extensions of the php Up and Running.
EDIT 1: I've just created a step by step tutorial on how to set up Wave on Windows using Laragon :
How to setup Laravel Wave on Windows using Laragon?
EDIT 2: @zappik confirmed that the above tutorial seems to be working as expected!
Let me know how it goes.
An alternative option that I've been using is to create a remote dev server and then use VS code to develop my apps remotely directly on the dev server.
To do that, just create a new Laravel server using this 1 click here:
Then follow the steps here on how to setup VS Code for remote development:
Thank you for your help bobbyiliev but :
I checked out all config and extensions files without seeing anything wrong
The problem persists.
The solution to use remote dev is actually adding a layer of complexity to a stack that is intended to simplify application dev so I won't use it.
I have a php startup error PHP Startup: Unable to load dynamic library 'sodium' in php error log, I think it's here in wamp that the problem occurs.
Just looking through the output that you've shared above, it looks like that your migrations failed at the 2017_01_14_005015_create_translations_table migration.
What you have to do is:
- Drop all tables from the database that you are using
- Then edit the
config/database.phpfile and update line 60 from:
'engine' => null,
To:
'engine' => 'InnoDB',
- And then run the migrations again.
You need to make sure that the php artisan migration command succeeds successfully without any errors before running the php artisan db:seed command and the other steps.
Let me know how it goes.
Hey, just a quick follow-up, did this work with the change to the config file?
Interesting. I have a similar problem running composer install where I am receiving this error message:
PHP Warning: PHP Startup: Unable to load dynamic library 'igbinary' (tried: ext\igbinary (The specified module could not be found), ext\php_igbinary.dll (The specified module could not be found)) in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'igbinary' (tried: ext\igbinary (The specified module could not be found), ext\php_igbinary.dll (The specified module could not be found)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'redis' (tried: ext\redis (The specified module could not be found), ext\php_redis.dll (The specified module could not be found)) in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'redis' (tried: ext\redis (The specified module could not be found), ext\php_redis.dll (The specified module could not be found)) in Unknown on line 0 Installing dependencies from lock file (including require-dev) Verifying lock file contents can be installed on current platform. Your lock file does not contain a compatible set of packages. Please run composer update.
Problem 1 - Root composer.json requires PHP extension ext-redis * but it is missing from your system. Install or enable PHP's redis extension.
To enable extensions, verify that they are enabled in your .ini files:
- C:\Program Files\php\php.ini
You can also run php --ini in a terminal to see which files are used by PHP in CLI mode.
Alternatively, you can run Composer with --ignore-platform-req=ext-redis to temporarily ignore these required extensions.
If redis is not required, should I move forward with running Composer with --ignore-platform-req=ext-redis?
Interesting. I have a similar problem running composer install where I am receiving this error message:
PHP Warning: PHP Startup: Unable to load dynamic library 'igbinary' (tried: ext\igbinary (The specified module could not be found), ext\php_igbinary.dll (The specified module could not be found)) in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'igbinary' (tried: ext\igbinary (The specified module could not be found), ext\php_igbinary.dll (The specified module could not be found)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'redis' (tried: ext\redis (The specified module could not be found), ext\php_redis.dll (The specified module could not be found)) in Unknown on line 0
Warning: PHP Startup: Unable to load dynamic library 'redis' (tried: ext\redis (The specified module could not be found), ext\php_redis.dll (The specified module could not be found)) in Unknown on line 0 Installing dependencies from lock file (including require-dev) Verifying lock file contents can be installed on current platform. Your lock file does not contain a compatible set of packages. Please run composer update.
Problem 1 - Root composer.json requires PHP extension ext-redis * but it is missing from your system. Install or enable PHP's redis extension.
To enable extensions, verify that they are enabled in your .ini files:
- C:\Program Files\php\php.ini
You can also run php --ini in a terminal to see which files are used by PHP in CLI mode.
Alternatively, you can run Composer with --ignore-platform-req=ext-redis to temporarily ignore these required extensions.
If redis is not required, should I move forward with running Composer with --ignore-platform-req=ext-redis?
If I move forward with running Composer with '--ignore-platform-req=ext-redis' I'm able to complete running 'php artisan migrate' and 'php artisan db:seed' with no error messages but when I try to visit my URL inputted in the .env file it displays an error that the site cannot be reached.
I'm wondering if this is related to running composer ignoring the platform requirements or is there something else that could be causing this issue?
Hi, I asked my team to try the installation on their side and they aren't able to do it. They all work on Windows and as we host on CloudWays, we configured the DB to MariaDB. At the end, nothing works Do you consider developping an installer with a web interface?
Hey there,
@meaghanpsavage how are you accessing the site? The connection refused error indicates a problem with the way that you've setup your webserver rather than a problem with the composer installation.
@zappik, did you try to make the change to the database config file? What are the errors that they get when they try to complete the installation?
The Wave installation itself is the same as of any other Laravel application. So you could use Laragon for Windows.
Best,
Bobby
@meaghanpsavage, when I have problem running the site, I check or have checked the following:
WAMP:
- Make sure that Wampserver is running.
- Configure/Check virtual host (path). [Might help in new installations. Not so much afterwards.]
- Restart from zero.
Terminal:
- php artisan key:generate
- php artisan optimize:clear
.env
- Make sure that APP_URL match with my Wampserver virtual host.
I also ignored redis (composer update --ignore-platform-req=ext-redis) and I have no problem at all including recent composer updates. If needed, check this for more info: https://devdojo.com/questions/error-installing-wave
I hope it helps.
1
Hi,
I have completed all the steps. My database is seeded. I see all the tables in MySQL workbench and the serve looks to be working fine.
- Do you have a resource showing to set up a database for wave? I want to ensure I am not doing it wrong?
- If the data base is all set up and I am seeing the tables. Is there a step I am missing to see it in local host?
Hey @meaghanpsavage,
All that you need to do is:
- Create a database and a username as normal
- Define the database details in the
.envfile - Run the Laravel migrations:
php artisan migrate - Finally seed the database with data:
php artisan db:seed
The 'Site can not be reached' error is not related to the database but with your web server. What URL are you using to access your installation?
Best,
Bobby
App url= http://watchdog.test
Do I need the pro version? Is that the why this is not working?