Error Unknown table 'CHECK_CONSTRAINTS' in information_schema during install/update

[xyychenchen]

Shlink version

4.4.0

PHP version

8.3

How do you serve Shlink

Self-hosted Apache

Database engine

MariaDB

Database version

5.5.68

Current behavior

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.

Generating proxies... Success!
Clearing entities cache... Success!
Downloading GeoLite2 db file... Success!
Downloading RoadRunner binary... Success!

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

Minimum steps to reproduce

[acelaya]

Please, provide the output of the command when run with -vvv

[xyychenchen]

Please, provide the output of the command when run with -vvv

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 indicate

[xyychenchen]

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)
 > 

like this

[acelaya]

I'm going to need the full output, not just the first question

[xyychenchen]

I'm going to need the full output, not just the first question

you mean the full output when I finish the all questions of the installtion script?

[acelaya]

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]

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

[acelaya]

Are you trying to create a new Shlink installation, or updating an existing one?

[acelaya]

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.

[acelaya]

You are getting a different error now: There is no table with name ".domains".

That's pretty weird, but it could be a side effect of a half-baked database from previous attempts.

You didn't confirm if you were originally trying to install Shlink from scratch or update an older instance, so I'm going to assume the former.

The best you can do is delete the database and try the installation from scratch. It should work now that your database is up to date.

On the other hand, if you were trying to update, then you'll need to restore a database backup.

Since the original error was caused by an unsupported MariaDB version, I'll mark that as the discussion answer. Feel free to open a new discussion if you run into new errors.

[xyychenchen]

to your quesiton, i installed it for the first time on this server, not updating older version, since i purchase this server today and try to deploy shlink service and it kept occur these errors~~

[acelaya]

Cool. That's the best scenario.

[xyychenchen]

so i deleted the mariadb right? and re-install it? should i delete shlink too? or just delete and reinstall mariadb, and then run vendor/bin/shlink-installer install again

[acelaya]

No need to reinstall MariaDB, just delete the database.

[xyychenchen]

Are you trying to create a new Shlink installation, or updating an existing one?

i ran installtion for several times before, and ran update several times before, because it kept failed