Bonjour,
Ayant découvert cette WebApp hier, je cherche à l'installer.
Je précise que j'utilise l'installation simple. L'installation se passe bien, jusqu'à la migration de la database.
En effet, j'ai un encadré en rouge qui écrit ceci :
Details
== 20200210102030 CreateBills: migrating
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JSON NOT NULL, `degressive_rate` DECIMAL(4,2) NOT NULL, `discount_rate` DECIMAL(' at line 1 in /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:184
Stack trace:
#0 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(184): PDO->exec()
#1 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(301): Phinx\Db\Adapter\PdoAdapter->execute()
#2 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(366): Phinx\Db\Adapter\MysqlAdapter->createTable()
#3 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php(120): Phinx\Db\Adapter\AdapterWrapper->createTable()
#4 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(366): Phinx\Db\Adapter\TimedOutputAdapter->createTable()
#5 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TablePrefixAdapter.php(67): Phinx\Db\Adapter\AdapterWrapper->createTable()
#6 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php(148): Phinx\Db\Adapter\TablePrefixAdapter->createTable()
#7 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(722): Phinx\Db\Plan\Plan->execute()
#8 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Db/Table.php(616): Phinx\Db\Table->executeActions()
#9 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/database/migrations/20200210102030_create_bills.php(46): Phinx\Db\Table->create()
#10 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(108): CreateBills->up()
#11 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(374): Phinx\Migration\Manager\Environment->executeMigration()
#12 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(347): Phinx\Migration\Manager->executeMigration()
#13 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(120): Phinx\Migration\Manager->migrate()
#14 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/symfony/console/Command/Command.php(255): Phinx\Console\Command\Migrate->execute()
#15 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/symfony/console/Application.php(1000): Symfony\Component\Console\Command\Command->run()
#16 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/symfony/console/Application.php(271): Symfony\Component\Console\Application->doRunCommand()
#17 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(69): Symfony\Component\Console\Application->doRun()
#18 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Wrapper/TextWrapper.php(239): Phinx\Console\PhinxApplication->doRun()
#19 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/robmorgan/phinx/src/Phinx/Wrapper/TextWrapper.php(117): Phinx\Wrapper\TextWrapper->executeRun()
#20 [internal function]: Phinx\Wrapper\TextWrapper->getMigrate()
#21 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/install/Install.php(234): call_user_func()
#22 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/install/Install.php(114): Robert2\Install\Install::_executePhinxCommand()
#23 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/App/Controllers/HomeController.php(80): Robert2\Install\Install::createMissingTables()
#24 [internal function]: Robert2\API\Controllers\HomeController->install()
#25 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func()
#26 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke()
#27 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke()
#28 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/Route.php(268): Slim\Route->callMiddlewareStack()
#29 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/App.php(503): Slim\Route->run()
#30 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/App/Middlewares/Pagination.php(20): Slim\App->__invoke()
#31 [internal function]: Robert2\API\Middlewares\Pagination->__invoke()
#32 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
#33 [internal function]: Slim\DeferredCallable->__invoke()
#34 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
#35 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/App/Middlewares/Acl.php(18): Slim\App->Slim\{closure}()
#36 [internal function]: Robert2\API\Middlewares\Acl->__invoke()
#37 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
#38 [internal function]: Slim\DeferredCallable->__invoke()
#39 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
#40 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/tuupola/callable-handler/src/CallableHandler.php(51): Slim\App->Slim\{closure}()
#41 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/tuupola/slim-jwt-auth/src/JwtAuthentication.php(123): Tuupola\Middleware\CallableHandler->handle()
#42 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/tuupola/callable-handler/src/DoublePassTrait.php(47): Tuupola\Middleware\JwtAuthentication->process()
#43 [internal function]: Tuupola\Middleware\JwtAuthentication->__invoke()
#44 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
#45 [internal function]: Slim\DeferredCallable->__invoke()
#46 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
#47 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/http-cache/src/Cache.php(55): Slim\App->Slim\{closure}()
#48 [internal function]: Slim\HttpCache\Cache->__invoke()
#49 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/DeferredCallable.php(57): call_user_func_array()
#50 [internal function]: Slim\DeferredCallable->__invoke()
#51 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func()
#52 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}()
#53 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/App.php(392): Slim\App->callMiddlewareStack()
#54 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/vendor/slim/slim/Slim/App.php(297): Slim\App->process()
#55 /var/www/vhosts/{MY_SUBDOMAIN}/httpdocs/src/public/index.php(12): Slim\App->run()
#56 {main}
Je vous avoue que là, je n'y comprends pas grand chose, alors si quelqu'un peut m'aider ce serait cool!
Merci d'avance!
