You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[ERROR] Error updating database.. Run with -vvv to see specific error info. #2320
i run the installtion script and it keep saying [ERROR] Error updating database.. Run with -vvv to see specific error info.
i am pretty sure that the info about the mariadb database is correct, i try to set using unix socket and the port, either way won't work,
and i also try to run with -vvv, but i did not see anything info helpful
please tell me how to find the error, i really have no idea where went wrong,
after run the set option to re-type the database info, i run vendor/bin/shlink-installer update,and it always shows
[root@ecs-TZWsG shlink]# vendor/bin/shlink-installer update
Welcome to Shlink!!
This tool will guide you through the installation process.
Do you want to import configuration from previous installation? (You will still be asked for any new config option that did not exist in previous shlink versions) (yes/no) [yes]:
Previous shlink installation path from which to import config:
/data/shlink/
Custom configuration properly generated!
Updating database...
[ERROR] Error updating database.. Run with -vvv to see specific error info.
and by the way, i have been successfully generate an API key yet, my first installtion failed with the database and geoIP key , after I re-input the geoIP key , what is left is the database, keep saying error , i spent a day to fix this , not working still
Expected behavior
run the installion script supposed to run successfully
Please, provide the output of the command when run with -vvv
Welcome to Shlink!!
This tool will guide you through the installation process.
SERVER
======
Select the runtime you are planning to use to serve Shlink (this is only used to conditionally skip some follow-up questions) [RoadRunner]:
[0] RoadRunner
[1] Classic web server (Nginx, Apache, etc)
>
Yes. The installer runs a couple subprocesses at the end (like the one which is failing), and will print extra info when run in verbose mode.
Welcome to Shlink!!
This tool will guide you through the installation process.
SERVER
======
Select the runtime you are planning to use to serve Shlink (this is only used to conditionally skip some follow-up questions) [RoadRunner]:
[0] RoadRunner
[1] Classic web server (Nginx, Apache, etc)
>
[root@ecs-TZWsG shlink]# vendor/bin/shlink-installer install -vvv
Welcome to Shlink!!
This tool will guide you through the installation process.
SERVER
======
Select the runtime you are planning to use to serve Shlink (this is only used to conditionally skip some follow-up questions) [RoadRunner]:
[0] RoadRunner
[1] Classic web server (Nginx, Apache, etc)
>
What is the maximum amount of RAM every process run by Shlink should be allowed to use? (Provide a number for bytes, a number followed by K for kilobytes, M for Megabytes or G for Gigabytes) [512M]:
>
DATABASE
========
Select database type [MySQL]:
[0] MySQL
[1] MariaDB
[2] PostgreSQL
[3] MicrosoftSQL
[4] SQLite [Not supported for production]
> 1
Database name [shlink]:
>
Database host [localhost]:
>
Database port [3306]:
>
Database username:
> steven
Database password:
> woainenzu
Unix socket (leave empty to not use a socket):
> /var/lib/mysql/mysql.sock
Do you want the database connection to be encrypted? Enabling this will make database connections fail if your database server does not support or enforce encryption. (yes/no) [no]:
>
URL SHORTENER
=============
Default domain for generated short URLs:
> kv3389.xyz
Is HTTPS enabled on this server? (yes/no) [yes]:
>
What is the default length you want generated short codes to have? (You will still be able to override this on every created short URL) [5]:
>
Do you want Shlink to resolve the short URL title based on the long URL's title tag (if any)? Otherwise, it will be kept empty unless explicitly provided. (yes/no) [yes]:
>
Do you want Shlink to redirect short URLs as soon as the first segment of the path matches a short code?
append:
* {shortDomain}/{shortCode}/[...extraPath] -> {longUrl}/[...extraPath]
* https://s.test/abc123 -> https://www.example.com
* https://s.test/abc123/shlinkio -> https://www.example.com/shlinkio
ignore:
* {shortDomain}/{shortCode}/[...extraPath] -> {longUrl}
* https://s.test/abc123 -> https://www.example.com
* https://s.test/abc123/shlinkio -> https://www.example.com
[Match strictly]:
[default] Match strictly
[append ] Append extra path
[ignore ] Discard extra path
> default
Do you want to support short URLs with multi-segment custom slugs? (for example, https://example.com/foo/bar) [Slugs and short codes will support only one segment (https://example.com/foo). Orphan visits will have one of "base_url", "invalid_short_url" or "regular_404" type.]:
[yes] Custom slugs will support multiple segments (https://example.com/foo/bar/baz). Orphan visits will only have either "base_url" or "invalid_short_url" type.
[no ] Slugs and short codes will support only one segment (https://example.com/foo). Orphan visits will have one of "base_url", "invalid_short_url" or "regular_404" type.
> no
Do you want to support trailing slashes in short URLs? (https://s.test/foo and https://s.test/foo/ will be considered the same) (yes/no) [no]:
>
How do you want short URLs to be matched?
Warning! This feature is experimental. It only applies to public routes (short URLs and QR codes). REST API routes always use strict match.
[Short codes and custom slugs will be matched in a case-sensitive way ("foo" !== "FOO"). Generated short codes will include lowercase letters, uppercase letters and numbers.]:
[strict] Short codes and custom slugs will be matched in a case-sensitive way ("foo" !== "FOO"). Generated short codes will include lowercase letters, uppercase letters and numbers.
[loose ] Short codes and custom slugs will be matched in a case-insensitive way ("foo" === "FOO"). Generated short codes will include only lowercase letters and numbers.
> strict
Provide a GeoLite2 license key. Leave empty to disable geolocation. (Go to https://shlink.io/documentation/geolite-license-key to know how to generate it):
> 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
What kind of redirect do you want your short URLs to have? [All visits will always be tracked. Not that good for SEO. Only GET requests will be redirected.]:
[302] All visits will always be tracked. Not that good for SEO. Only GET requests will be redirected.
[301] Best option for SEO. Redirect will be cached for a short period of time, making some visits not to be tracked. Only GET requests will be redirected.
[307] Same as 302, but Shlink will also redirect on non-GET requests.
[308] Same as 301, but Shlink will also redirect on non-GET requests.
> 301
How long (in seconds) do you want your redirects to be cached by visitors? [30]:
>
TRACKING
========
Do you want to completely disable visits tracking? (yes/no) [no]:
>
Do you want track orphan visits? (visits to the base URL, invalid short URLs or other "not found" URLs) (yes/no) [yes]:
>
Provide a parameter name that you will be able to use to disable tracking on specific request to short URLs (leave empty and this feature won't be enabled):
>
Provide a comma-separated list of IP addresses, CIDR blocks or wildcard addresses (1.2.*.*) from which you want tracking to be disabled:
>
Do you want to disable tracking of visitors' IP addresses? (yes/no) [no]:
>
Do you want visitors' remote IP addresses to be anonymized before persisting them to the database? (yes/no) [yes]:
> no
[WARNING] Careful! If you disable IP address anonymization, you will no longer be in compliance with the GDPR and other
similar data protection regulations.
Do you still want to disable anonymization? (yes/no) [no]:
> yes
Do you want to disable tracking of visitors' "User Agents"? (yes/no) [no]:
>
Do you want to disable tracking of visitors' "Referrers"? (yes/no) [no]:
>
REDIRECTS
=========
Custom URL to redirect to when a user hits Shlink's base URL (If no value is provided, the user will see a default "404 not found" page):
> kv
[ERROR] Provided value "kv" is not a valid URL
Custom URL to redirect to when a user hits Shlink's base URL (If no value is provided, the user will see a default "404 not found" page):
> https://kv3389.xyz
Custom URL to redirect to when a user hits an invalid short URL (If no value is provided, the user will see a default "404 not found" page):
>
Custom URL to redirect to when a user hits a not found URL other than an invalid short URL (If no value is provided, the user will see a default "404 not found" page):
>
QR CODES
========
What's the default size, in pixels, you want generated QR codes to have (50 to 1000) [300]:
>
What's the default margin, in pixels, you want generated QR codes to have [0]:
>
What's the default format for generated QR codes [png]:
[0] png
[1] svg
>
What's the default error correction for generated QR codes [Low]:
[l] Low
[m] Medium
[q] Quartile
[h] High
>
Do you want the QR codes block size to be rounded by default? QR codes could end up having some extra margin, but it will improve readability [Round block size, improving readability]:
[yes] Round block size, improving readability
[no ] Do not round block size, preventing extra margin
>
What's the default foreground color for generated QR codes [#000000]:
>
What's the default background color for generated QR codes [#FFFFFF]:
>
Provide a URL for a logo to be placed inside the QR code (leave empty to use no logo):
>
Should Shlink be able to generate QR codes for short URLs which are not enabled? (Short URLs are not enabled if they have a "valid since" in the future, a "valid until" in the past, or reached the maximum amount of allowed visits) (yes/no) [yes]:
>
ROBOTS
======
Do you want all short URLs to be crawlable/allowed by the robots.txt file? You can still allow them individually, regardless of this. (yes/no) [no]:
>
Provide a comma-separated list of user agents for your robots.txt file. Defaults to all user agents (*):
>
APPLICATION
===========
What is the amount of visits from which the system will not allow short URLs to be deleted? Leave empty to always allow deleting short URLs, no matter what:
>
What is the path from which shlink is going to be served? (It must include a leading bar, like "/shlink". Leave empty if you plan to serve shlink from the root of the domain):
> /shlink
Set the timezone in which your Shlink instance is running (leave empty to use the one set in PHP config):
>
Prefix for cache entry keys. (Change this if you run multiple Shlink instances on this server, or they share the same redis instance) [Shlink]:
>
INTEGRATIONS
============
Do you want to use a redis instance, redis cluster or redis sentinels as a shared cache for Shlink? (recommended if you run a cluster of Shlink instances) (yes/no) [no]:
>
Do you want Shlink to publish real-time updates in a Mercure hub server? (yes/no) [no]:
>
Do you want Shlink to publish real-time updates in a RabbitMQ instance? (yes/no) [no]:
>
Do you want Shlink to send all visits to an external Matomo server? (yes/no) [no]:
>
Custom configuration properly generated!
Initializing database if needed... [Running "/usr/bin/php bin/cli db:create"] RUN '/usr/bin/php' 'bin/cli' 'db:create'
OUT
OUT [OK] Database already exists. Run "db:migrate" command to make sure it is up to
OUT date.
OUT
OUT
RES Command ran successfully
Success!
Updating database... [Running "/usr/bin/php bin/cli db:migrate"] RUN '/usr/bin/php' 'bin/cli' 'db:migrate'
OUT Migrating database...
OUT
ERR RUN '/usr/bin/php' 'vendor/doctrine/migrations/bin/doctrine-migrations.php' 'migrations:migrate' '--no-interaction'
ERR ERR
ERR ERR In ExceptionConverter.php line 91:
ERR ERR
ERR ERR [Doctrine\DBAL\Exception\DriverException (1109)]
ERR ERR An exception occurred while executing a query: SQLSTATE[42S02]: Base table
ERR ERR or view not found: 1109 Unknown table 'CHECK_CONSTRAINTS' in information_sc
ERR ERR hema
ERR ERR
ERR ERR
ERR ERR Exception trace:
ERR ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:91
ERR ERR Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:1373
ERR ERR Doctrine\DBAL\Connection->handleDriverException() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:1315
ERR ERR Doctrine\DBAL\Connection->convertExceptionDuringQuery() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:779
ERR ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php:403
ERR ERR Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns() at /data/shlink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:104
ERR ERR Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /data/shlink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:319
ERR ERR Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable() at /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php:199
ERR ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate() at /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php:181
ERR ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->ensureInitialized() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/Command/MigrateCommand.php:158
ERR ERR Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR ERR Symfony\Component\Console\Application->run() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/ConsoleRunner.php:95
ERR ERR Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /data/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:45
ERR ERR Doctrine\Migrations\{closure}() at /data/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:46
ERR ERR
ERR ERR In Exception.php line 28:
ERR ERR
ERR ERR [Doctrine\DBAL\Driver\PDO\Exception (1109)]
ERR ERR SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_CO
ERR ERR NSTRAINTS' in information_schema
ERR ERR
ERR ERR
ERR ERR Exception trace:
ERR ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
ERR ERR Doctrine\DBAL\Driver\PDO\Exception::new() at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:57
ERR ERR Doctrine\DBAL\Driver\PDO\Statement->execute() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:772
ERR ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php:403
ERR ERR Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns() at /data/shlink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:104
ERR ERR Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /data/shlink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:319
ERR ERR Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable() at /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php:199
ERR ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate() at /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php:181
ERR ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->ensureInitialized() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/Command/MigrateCommand.php:158
ERR ERR Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR ERR Symfony\Component\Console\Application->run() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/ConsoleRunner.php:95
ERR ERR Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /data/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:45
ERR ERR Doctrine\Migrations\{closure}() at /data/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:46
ERR ERR
ERR ERR In Statement.php line 55:
ERR ERR
ERR ERR [PDOException (42S02)]
ERR ERR SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_CO
ERR ERR NSTRAINTS' in information_schema
ERR ERR
ERR ERR
ERR ERR Exception trace:
ERR ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
ERR ERR PDOStatement->execute() at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
ERR ERR Doctrine\DBAL\Driver\PDO\Statement->execute() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:772
ERR ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php:403
ERR ERR Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns() at /data/shlink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:104
ERR ERR Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /data/shlink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:319
ERR ERR Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable() at /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php:199
ERR ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate() at /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.php:181
ERR ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->ensureInitialized() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/Command/MigrateCommand.php:158
ERR ERR Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR ERR Symfony\Component\Console\Application->run() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/ConsoleRunner.php:95
ERR ERR Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /data/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:45
ERR ERR Doctrine\Migrations\{closure}() at /data/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:46
ERR ERR
ERR ERR migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--no-all-or-nothing] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
ERR ERR
ERR ERR
ERR In Process.php line 270:
ERR
ERR [Symfony\Component\Process\Exception\ProcessFailedException]
ERR The command "'/usr/bin/php' 'vendor/doctrine/migrations/bin/doctrine-migrat
ERR ions.php' 'migrations:migrate' '--no-interaction'" failed.
ERR
ERR Exit Code: 255(Unknown error)
ERR
ERR Working directory: /data/shlink
ERR
ERR Output:
ERR ================
ERR
ERR
ERR Error Output:
ERR ================
ERR
ERR In ExceptionConverter.php line 91:
ERR
ERR
ERR [Doctrine\DBAL\Exception\DriverException (1109)]
ERR
ERR An exception occurred while executing a query: SQLSTATE[42S02]: Base tabl
ERR e
ERR or view not found: 1109 Unknown table 'CHECK_CONSTRAINTS' in information_
ERR sc
ERR hema
ERR
ERR
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConver
ERR ter.php:91
ERR Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at /data/shli
ERR nk/vendor/doctrine/dbal/src/Connection.php:1373
ERR Doctrine\DBAL\Connection->handleDriverException() at /data/shlink/vendor/d
ERR octrine/dbal/src/Connection.php:1315
ERR Doctrine\DBAL\Connection->convertExceptionDuringQuery() at /data/shlink/ve
ERR ndor/doctrine/dbal/src/Connection.php:779
ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/d
ERR bal/src/Schema/MySQLSchemaManager.php:403
ERR Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns() at /data/shl
ERR ink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:104
ERR Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /data/sh
ERR link/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:319
ERR Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable() at /data/shl
ERR ink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.ph
ERR p:199
ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate() a
ERR t /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadat
ERR aStorage.php:181
ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->ensureInitializ
ERR ed() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/Command/M
ERR igrateCommand.php:158
ERR Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /da
ERR ta/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/sy
ERR mfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vend
ERR or/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symf
ERR ony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/vendor/doctri
ERR ne/migrations/src/Tools/Console/ConsoleRunner.php:95
ERR Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /data/shlink/ven
ERR dor/doctrine/migrations/bin/doctrine-migrations.php:45
ERR Doctrine\Migrations\{closure}() at /data/shlink/vendor/doctrine/migrations
ERR /bin/doctrine-migrations.php:46
ERR
ERR In Exception.php line 28:
ERR
ERR
ERR [Doctrine\DBAL\Driver\PDO\Exception (1109)]
ERR
ERR SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_
ERR CO
ERR NSTRAINTS' in information_schema
ERR
ERR
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
ERR Doctrine\DBAL\Driver\PDO\Exception::new() at /data/shlink/vendor/doctrine/
ERR dbal/src/Driver/PDO/Statement.php:57
ERR Doctrine\DBAL\Driver\PDO\Statement->execute() at /data/shlink/vendor/doctr
ERR ine/dbal/src/Connection.php:772
ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/d
ERR bal/src/Schema/MySQLSchemaManager.php:403
ERR Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns() at /data/shl
ERR ink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:104
ERR Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /data/sh
ERR link/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:319
ERR Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable() at /data/shl
ERR ink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.ph
ERR p:199
ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate() a
ERR t /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadat
ERR aStorage.php:181
ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->ensureInitializ
ERR ed() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/Command/M
ERR igrateCommand.php:158
ERR Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /da
ERR ta/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/sy
ERR mfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vend
ERR or/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symf
ERR ony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/vendor/doctri
ERR ne/migrations/src/Tools/Console/ConsoleRunner.php:95
ERR Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /data/shlink/ven
ERR dor/doctrine/migrations/bin/doctrine-migrations.php:45
ERR Doctrine\Migrations\{closure}() at /data/shlink/vendor/doctrine/migrations
ERR /bin/doctrine-migrations.php:46
ERR
ERR In Statement.php line 55:
ERR
ERR
ERR [PDOException (42S02)]
ERR
ERR SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'CHECK_
ERR CO
ERR NSTRAINTS' in information_schema
ERR
ERR
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
ERR PDOStatement->execute() at /data/shlink/vendor/doctrine/dbal/src/Driver/PD
ERR O/Statement.php:55
ERR Doctrine\DBAL\Driver\PDO\Statement->execute() at /data/shlink/vendor/doctr
ERR ine/dbal/src/Connection.php:772
ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/d
ERR bal/src/Schema/MySQLSchemaManager.php:403
ERR Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns() at /data/shl
ERR ink/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:104
ERR Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns() at /data/sh
ERR link/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:319
ERR Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable() at /data/shl
ERR ink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadataStorage.ph
ERR p:199
ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate() a
ERR t /data/shlink/vendor/doctrine/migrations/src/Metadata/Storage/TableMetadat
ERR aStorage.php:181
ERR Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->ensureInitializ
ERR ed() at /data/shlink/vendor/doctrine/migrations/src/Tools/Console/Command/M
ERR igrateCommand.php:158
ERR Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /da
ERR ta/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/sy
ERR mfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vend
ERR or/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symf
ERR ony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/vendor/doctri
ERR ne/migrations/src/Tools/Console/ConsoleRunner.php:95
ERR Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /data/shlink/ven
ERR dor/doctrine/migrations/bin/doctrine-migrations.php:45
ERR Doctrine\Migrations\{closure}() at /data/shlink/vendor/doctrine/migrations
ERR /bin/doctrine-migrations.php:46
ERR
ERR migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--
ERR allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--no-all-or-nothin
ERR g] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/symfony/process/Process.php:270
ERR Symfony\Component\Process\Process->mustRun() at /data/shlink/module/CLI/src/Util/ProcessRunner.php:48
ERR Shlinkio\Shlink\CLI\Util\ProcessRunner->run() at /data/shlink/module/CLI/src/Command/Db/AbstractDatabaseCommand.php:30
ERR Shlinkio\Shlink\CLI\Command\Db\AbstractDatabaseCommand->runPhpCommand() at /data/shlink/module/CLI/src/Command/Db/MigrateDatabaseCommand.php:31
ERR Shlinkio\Shlink\CLI\Command\Db\MigrateDatabaseCommand->lockedExecute() at /data/shlink/module/CLI/src/Command/Util/AbstractLockedCommand.php:35
ERR Shlinkio\Shlink\CLI\Command\Util\AbstractLockedCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/bin/cli:10
ERR
ERR db:migrate
ERR
ERR
RES 1 Command did not run successfully
Generating proxies... [Running "/usr/bin/php bin/doctrine orm:generate-proxies"] RUN '/usr/bin/php' 'bin/doctrine' 'orm:generate-proxies'
ERR Processing entity "Shlinkio\Shlink\Core\Visit\Entity\Visit"
ERR Processing entity "Shlinkio\Shlink\Core\RedirectRule\Entity\ShortUrlRedirectRule"
ERR Processing entity "Shlinkio\Shlink\Core\Geolocation\Entity\GeolocationDbUpdate"
ERR Processing entity "Shlinkio\Shlink\Core\Tag\Entity\Tag"
ERR Processing entity "Shlinkio\Shlink\Core\Visit\Entity\OrphanVisitsCount"
ERR Processing entity "Shlinkio\Shlink\Core\Visit\Entity\VisitLocation"
ERR Processing entity "Shlinkio\Shlink\Core\ShortUrl\Entity\ShortUrl"
ERR Processing entity "Shlinkio\Shlink\Core\RedirectRule\Entity\RedirectCondition"
ERR Processing entity "Shlinkio\Shlink\Core\Domain\Entity\Domain"
ERR Processing entity "Shlinkio\Shlink\Core\Visit\Entity\ShortUrlVisitsCount"
ERR Processing entity "Shlinkio\Shlink\Rest\Entity\ApiKey"
ERR Processing entity "Shlinkio\Shlink\Rest\Entity\ApiKeyRole"
ERR
ERR Proxy classes generated to "/data/shlink/data/proxies"
ERR
RES Command ran successfully
Success!
Downloading GeoLite2 db file... [Running "/usr/bin/php bin/cli visit:download-db"] RUN '/usr/bin/php' 'bin/cli' 'visit:download-db'
OUT
OUT [INFO] GeoLite2 db file is up to date.
OUT
OUT
RES Command ran successfully
Success!
Generating first API key... [Running "/usr/bin/php bin/cli api-key:generate"] RUN '/usr/bin/php' 'bin/cli' 'api-key:generate'
ERR
ERR In ExceptionConverter.php line 40:
ERR
ERR [Doctrine\DBAL\Exception\TableNotFoundException (1146)]
ERR An exception occurred while executing a query: SQLSTATE[42S02]: Base table
ERR or view not found: 1146 Table 'shlink.api_keys' doesn't exist
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:40
ERR Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:1373
ERR Doctrine\DBAL\Connection->handleDriverException() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:1315
ERR Doctrine\DBAL\Connection->convertExceptionDuringQuery() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:779
ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27
ERR Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute() at /data/shlink/vendor/doctrine/orm/src/Query.php:296
ERR Doctrine\ORM\Query->_doExecute() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:935
ERR Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:891
ERR Doctrine\ORM\AbstractQuery->execute() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:738
ERR Doctrine\ORM\AbstractQuery->getOneOrNullResult() at /data/shlink/module/Rest/src/ApiKey/Repository/ApiKeyRepository.php:60
ERR Shlinkio\Shlink\Rest\ApiKey\Repository\ApiKeyRepository->nameExists() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:44
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->ensureUniqueName() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:30
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->Shlinkio\Shlink\Rest\Service\{closure}() at /data/shlink/vendor/doctrine/orm/src/EntityManager.php:183
ERR Doctrine\ORM\EntityManager->wrapInTransaction() at /data/shlink/vendor/doctrine/orm/src/Decorator/EntityManagerDecorator.php:72
ERR Doctrine\ORM\Decorator\EntityManagerDecorator->wrapInTransaction() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:29
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->create() at /data/shlink/module/CLI/src/Command/Api/GenerateKeyCommand.php:111
ERR Shlinkio\Shlink\CLI\Command\Api\GenerateKeyCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/bin/cli:10
ERR
ERR In Exception.php line 28:
ERR
ERR [Doctrine\DBAL\Driver\PDO\Exception (1146)]
ERR SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shlink.api_keys'
ERR doesn't exist
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
ERR Doctrine\DBAL\Driver\PDO\Exception::new() at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:57
ERR Doctrine\DBAL\Driver\PDO\Statement->execute() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:772
ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27
ERR Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute() at /data/shlink/vendor/doctrine/orm/src/Query.php:296
ERR Doctrine\ORM\Query->_doExecute() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:935
ERR Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:891
ERR Doctrine\ORM\AbstractQuery->execute() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:738
ERR Doctrine\ORM\AbstractQuery->getOneOrNullResult() at /data/shlink/module/Rest/src/ApiKey/Repository/ApiKeyRepository.php:60
ERR Shlinkio\Shlink\Rest\ApiKey\Repository\ApiKeyRepository->nameExists() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:44
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->ensureUniqueName() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:30
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->Shlinkio\Shlink\Rest\Service\{closure}() at /data/shlink/vendor/doctrine/orm/src/EntityManager.php:183
ERR Doctrine\ORM\EntityManager->wrapInTransaction() at /data/shlink/vendor/doctrine/orm/src/Decorator/EntityManagerDecorator.php:72
ERR Doctrine\ORM\Decorator\EntityManagerDecorator->wrapInTransaction() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:29
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->create() at /data/shlink/module/CLI/src/Command/Api/GenerateKeyCommand.php:111
ERR Shlinkio\Shlink\CLI\Command\Api\GenerateKeyCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/bin/cli:10
ERR
ERR In Statement.php line 55:
ERR
ERR [PDOException (42S02)]
ERR SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shlink.api_keys'
ERR doesn't exist
ERR
ERR
ERR Exception trace:
ERR at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
ERR PDOStatement->execute() at /data/shlink/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
ERR Doctrine\DBAL\Driver\PDO\Statement->execute() at /data/shlink/vendor/doctrine/dbal/src/Connection.php:772
ERR Doctrine\DBAL\Connection->executeQuery() at /data/shlink/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27
ERR Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute() at /data/shlink/vendor/doctrine/orm/src/Query.php:296
ERR Doctrine\ORM\Query->_doExecute() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:935
ERR Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:891
ERR Doctrine\ORM\AbstractQuery->execute() at /data/shlink/vendor/doctrine/orm/src/AbstractQuery.php:738
ERR Doctrine\ORM\AbstractQuery->getOneOrNullResult() at /data/shlink/module/Rest/src/ApiKey/Repository/ApiKeyRepository.php:60
ERR Shlinkio\Shlink\Rest\ApiKey\Repository\ApiKeyRepository->nameExists() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:44
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->ensureUniqueName() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:30
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->Shlinkio\Shlink\Rest\Service\{closure}() at /data/shlink/vendor/doctrine/orm/src/EntityManager.php:183
ERR Doctrine\ORM\EntityManager->wrapInTransaction() at /data/shlink/vendor/doctrine/orm/src/Decorator/EntityManagerDecorator.php:72
ERR Doctrine\ORM\Decorator\EntityManagerDecorator->wrapInTransaction() at /data/shlink/module/Rest/src/Service/ApiKeyService.php:29
ERR Shlinkio\Shlink\Rest\Service\ApiKeyService->create() at /data/shlink/module/CLI/src/Command/Api/GenerateKeyCommand.php:111
ERR Shlinkio\Shlink\CLI\Command\Api\GenerateKeyCommand->execute() at /data/shlink/vendor/symfony/console/Command/Command.php:279
ERR Symfony\Component\Console\Command\Command->run() at /data/shlink/vendor/symfony/console/Application.php:1076
ERR Symfony\Component\Console\Application->doRunCommand() at /data/shlink/vendor/symfony/console/Application.php:342
ERR Symfony\Component\Console\Application->doRun() at /data/shlink/vendor/symfony/console/Application.php:193
ERR Symfony\Component\Console\Application->run() at /data/shlink/bin/cli:10
ERR
ERR api-key:generate [-m|--name NAME] [-e|--expiration-date EXPIRATION-DATE] [-a|--author-only] [-d|--domain-only DOMAIN-ONLY] [-o|--no-orphan-visits]
ERR
ERR
RES 255 Command did not run successfully
Warning!
thanks for your time, this is the full output you asked for
The root of the issue is this error, when running database migrations: Unknown table 'CHECK_CONSTRAINTS' in information_schema, which is likely caused because you are using a veeeery old MariaDB version, and I don't think the database abstraction library supports it.
I'd suggest making sure you use a more recent version. The last one is 11.7, just as a reference.
Activity
acelaya commentedon Dec 31, 2024
Please, provide the output of the command when run with
-vvvxyychenchen commentedon Dec 31, 2024
output is the same as running
vendor/bin/shlink-installer install, so i do not know how it can help identify the issues as the prompt indicatexyychenchen commentedon Dec 31, 2024
like this
acelaya commentedon Dec 31, 2024
I'm going to need the full output, not just the first question
xyychenchen commentedon Dec 31, 2024
you mean the full output when I finish the all questions of the installtion script?
acelaya commentedon Dec 31, 2024
Yes. The installer runs a couple subprocesses at the end (like the one which is failing), and will print extra info when run in verbose mode.
xyychenchen commentedon Dec 31, 2024
thanks for your time, this is the full output you asked for
acelaya commentedon Dec 31, 2024
Are you trying to create a new Shlink installation, or updating an existing one?
acelaya commentedon Dec 31, 2024
The root of the issue is this error, when running database migrations:
Unknown table 'CHECK_CONSTRAINTS' in information_schema, which is likely caused because you are using a veeeery old MariaDB version, and I don't think the database abstraction library supports it.I'd suggest making sure you use a more recent version. The last one is 11.7, just as a reference.
xyychenchen commentedon Dec 31, 2024
i ran installtion for several times before, and ran update several times before, because it kept failed