Issue while installing Wallabag 2.6.1

[prbt2016]

Hello ,

I was in the process of manual installation of wallabag 2.6.1 using Github release package on Centos 7 with PHP 7.4, MYSQL 5.5, Apache 2.2 using the following steps i.e :

https://doc.wallabag.org/en/admin/installation/installation.html#on-shared-hosting

However after filling in parameters.yml and executing the following command i.e :

php bin/console wallabag:install --env=prod

The following error is thrown ON MYSQL 5.5 and on MYSQL 5.6 environment as well i.e :

 [WARNING] Some commands could not be registered:


In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't
  exist


In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In Statement.php line 121:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't
  exist


In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In Statement.php line 121:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't
  exist


In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In Statement.php line 121:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist




 [WARNING] Some commands could not be registered:


In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't
  exist


In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In Statement.php line 121:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't
  exist


In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In Statement.php line 121:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In ExceptionConverter.php line 49:

  An exception occurred while executing a query: SQLSTATE[42S02]: Base table
  or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't
  exist


In Exception.php line 28:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist


In Statement.php line 121:

  SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}}.{{DBPREFIX}}internal_setting' doesn't exist

wallabag installer
==================

Step 1 of 4: Checking system requirements.
------------------------------------------

 ------------------------ -------- ----------------
  Checked                  Status   Recommendation
 ------------------------ -------- ----------------
  PDO Driver (pdo_mysql)   OK!
  Database connection      OK!
  Database version         OK!
  curl_exec                OK!
  curl_multi_init          OK!
 ------------------------ -------- ----------------


 [OK] Success! Your system can run wallabag properly.


Step 2 of 4: Setting up database.
---------------------------------

 It appears that your database already exists. Would you like to reset it? (yes/no) [no]:
 > no

 Creating schema...

In InstallCommand.php line 361:

  The command "doctrine:migrations:migrate" generates some errors:

  [notice] Migrating up to Application\Migrations\Version20230613121354
  [notice] Migration Application\Migrations\Version20161214094402 skipped dur
  ing Execution. Reason: "It seems that you already played this migration."
  [notice] Migration Application\Migrations\Version20170606155640 skipped dur
  ing Execution. Reason: "It seems that you already played this migration."
  [notice] Migration Application\Migrations\Version20190619093534 skipped dur
  ing Execution. Reason: "Migration can only be executed safely on 'sqlite'."
  [error] Migration Application\Migrations\Version20221221092957 failed durin
  g Execution. Error: "An exception occurred while executing a query: SQLSTAT
  E[42000]: Syntax error or access violation: 1064 You have an error in your
  SQL syntax; check the manual that corresponds to your MySQL server version
  for the right syntax to use near 'JSON DEFAULT NULL' at line 1"
  06:08:46 CRITICAL  [console] Error thrown while running command "doctrine:m
  igrations:migrate --no-interaction=1 --no-debug=1 --env=prod". Message: "An
   exception occurred while executing a query: SQLSTATE[42000]: Syntax error
  or access violation: 1064 You have an error in your SQL syntax; check the m
  anual that corresponds to your MySQL server version for the right syntax to
   use near 'JSON DEFAULT NULL' at line 1" ["exception" => Doctrine\DBAL\Exce
  ption\SyntaxErrorException { …},"command" => "doctrine:migrations:migrate -
  -no-interaction=1 --no-debug=1 --env=prod","message" => "An exception occur
  red while executing a query: SQLSTATE[42000]: Syntax error or access violat
  ion: 1064 You have an error in your SQL syntax; check the manual that corre
  sponds to your MySQL server version for the right syntax to use near 'JSON
  DEFAULT NULL' at line 1"]

  In ExceptionConverter.php line 86:


    An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check themanual that corresponds to your MySQL server version for the right syntax to use near 'JSON DEFAULT NULL' at line 1




  In Exception.php line 28:


    SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JSON DEFAULT NULL' at line 1




  In Connection.php line 70:


    SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JSON DEFAULT NULL' at line 1

I checked the same on MYSQL 5.7 environment as well there too I get the following errors thrown on above command i.e :

wallabag installer
==================

Step 1 of 4: Checking system requirements.
------------------------------------------

 ------------------------ -------- ----------------
  Checked                  Status   Recommendation
 ------------------------ -------- ----------------
  PDO Driver (pdo_mysql)   OK!
  Database connection      OK!
  Database version         OK!
  curl_exec                OK!
  curl_multi_init          OK!
 ------------------------ -------- ----------------


 [OK] Success! Your system can run wallabag properly.


Step 2 of 4: Setting up database.
---------------------------------

 It appears that your database already exists. Would you like to reset it? (yes/no) [no]:
 > no

 Creating schema...

In InstallCommand.php line 361:

  The command "doctrine:migrations:migrate" generates some errors:

  [notice] Migrating up to Application\Migrations\Version20230613121354
  [notice] Migration Application\Migrations\Version20161214094402 skipped dur
  ing Execution. Reason: "It seems that you already played this migration."
  [notice] Migration Application\Migrations\Version20170606155640 skipped dur
  ing Execution. Reason: "It seems that you already played this migration."
  [notice] Migration Application\Migrations\Version20190619093534 skipped dur
  ing Execution. Reason: "Migration can only be executed safely on 'sqlite'."
  [error] Migration Application\Migrations\Version20221221092957 failed durin
  g Execution. Error: "An exception occurred while executing a query: SQLSTAT
  E[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_us
  er' doesn't exist"
  06:44:32 CRITICAL  [console] Error thrown while running command "doctrine:m
  igrations:migrate --no-interaction=1 --no-debug=1 --env=prod". Message: "An
   exception occurred while executing a query: SQLSTATE[42S02]: Base table or
   view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist" ["ex
  ception" => Doctrine\DBAL\Exception\TableNotFoundException { …},"command" =
  > "doctrine:migrations:migrate --no-interaction=1 --no-debug=1 --env=prod",
  "message" => "An exception occurred while executing a query: SQLSTATE[42S02
  ]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doe
  sn't exist"]

  In ExceptionConverter.php line 49:


    An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist




  In Exception.php line 28:


    SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist




  In Connection.php line 70:


    SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist

Environment

• Version: 2.6.1
• Installation: Using release package https://github.com/wallabag/wallabag/releases/download/2.6.1/wallabag-2.6.1.tar.gz and via following method https://doc.wallabag.org/en/admin/installation/installation.html#on-shared-hosting
• PHP version: 7.4
• OS: Centos 7
• Database: MYSQL 5.5/ 5.6 / 5.7

My app/config/parameters.yml is:

# This file is auto-generated during the composer install
parameters:
  database_driver: pdo_mysql
  database_host: {{DBHOST}}
  database_port: null
  database_name: {{DBNAME}}
  database_user: {{DBUSERNAME}}
  database_password: {{PASSWORD}}
  database_path: null
  database_table_prefix: {{DBPREFIX}}
  database_socket: null
  database_charset: utf8mb4
  domain_name: 'http://example.com/wallabag261/web'
  server_name: 'wallabag'
  mailer_dsn: 'smtp://127.0.0.1'
  locale: en
  secret: {{SECRET}}
  twofactor_auth: true
  twofactor_sender: no-reply@wallabag.org
  fosuser_registration: true
  fosuser_confirmation: true
  fos_oauth_server_access_token_lifetime: 3600
  fos_oauth_server_refresh_token_lifetime: 1209600
  from_email: no-reply@wallabag.org
  rss_limit: 50
  rabbitmq_host: localhost
  rabbitmq_port: 5672
  rabbitmq_user: guest
  rabbitmq_password: guest
  rabbitmq_prefetch_count: 10
  redis_scheme: tcp
  redis_host: localhost
  redis_port: 6379
  redis_path: null
  redis_password: null
  sentry_dsn: null

What steps will reproduce the bug?

1. Download wallabag.
2. Fill db details and url details in app/config/parameters.yml
3. Execute php bin/console wallabag:install --env=prod

[j0k3r]

@gramakri this is a different problem, you should have created a different issue. I moved your comment as a new issue #6660

[j0k3r]

The JSON type is only support since MySQL 5.7.8
https://dev.mysql.com/doc/refman/5.7/en/json.html

You should have at least that version or a newer one.
Maybe we should check about that during the install process.

[prbt2016]

Hello @j0k3r ,

Thanks for your reply, but I have checked on MYSQL 5.7.42 as well and have mentioned the above issue which throws same above issue and also the default database prefix is being taken , if you check the error i.e :

  In ExceptionConverter.php line 49:


    An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist




  In Exception.php line 28:


    SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist




  In Connection.php line 70:


    SQLSTATE[42S02]: Base table or view not found: 1146 Table '{{DBNAME}.wallabag_user' doesn't exist

For your kind info I have used wb_ as dbprefix.

Also it would be great if you could please update the minimum required MYSQL version on official website , it isn't mentioned.

[j0k3r]

Does these values {{DBNAME}}.{{DBPREFIX}} are redacted manually from the log for the issue?
Can you show us your app/config/parameters.yml?

[prbt2016]

Does these values {{DBNAME}}.{{DBPREFIX}} are redacted manually from the log for the issue?

Yes for security reasons have masked those values.

Can you show us your app/config/parameters.yml?

# This file is auto-generated during the composer install
parameters:
    database_driver: pdo_mysql
    database_host: localhost
    database_port: null
    database_name: wallabag261
    database_user: {{DBUSER}}
    database_password: {{DBPASS}}
    database_path: null
    database_table_prefix: wb_
    database_socket: null
    database_charset: utf8mb4
    domain_name: 'http://example.com/wallabag261/web'
    server_name: 'wallabag'
    mailer_dsn: 'smtp://127.0.0.1'
    locale: en
    secret: {{SECRET}}
    twofactor_auth: true
    twofactor_sender: no-reply@wallabag.org
    fosuser_registration: true
    fosuser_confirmation: true
    fos_oauth_server_access_token_lifetime: 3600
    fos_oauth_server_refresh_token_lifetime: 1209600
    from_email: no-reply@wallabag.org
    rss_limit: 50
    rabbitmq_host: localhost
    rabbitmq_port: 5672
    rabbitmq_user: guest
    rabbitmq_password: guest
    rabbitmq_prefetch_count: 10
    redis_scheme: tcp
    redis_host: localhost
    redis_port: 6379
    redis_path: null
    redis_password: null
    sentry_dsn: null

[prbt2016]

Hello @j0k3r ,

Any updates regarding the same ?.

Kindly let me know.

[jerryc127]

I have a same problem use docker

how to solve it?

wallabag  | Starting wallabag ...
wallabag  | Waiting for database ...
wallabag  | Installing dependencies from lock file
wallabag  | Verifying lock file contents can be installed on current platform.
wallabag  | Nothing to install, update or remove
wallabag  | Package guzzlehttp/ringphp is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package guzzlehttp/streams is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/compiler is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/consistency is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/event is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/exception is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/file is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/iterator is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/math is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/protocol is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/regex is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/ruler is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/stream is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package hoa/ustring is abandoned, you should avoid using it. No replacement was suggested.wallabag  | Package hoa/visitor is abandoned, you should avoid using it. No replacement was suggested.wallabag  | Package hoa/zformat is abandoned, you should avoid using it. No replacement was suggested.wallabag  | Package lexik/form-filter-bundle is abandoned, you should avoid using it. Use spiriitlabs/form-filter-bundle instead.
wallabag  | Package php-http/message-factory is abandoned, you should avoid using it. Use psr/http-factory instead.
wallabag  | Package sensio/framework-extra-bundle is abandoned, you should avoid using it. Use Symfony instead.
wallabag  | Package true/punycode is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Package php-cs-fixer/diff is abandoned, you should avoid using it. No replacement was suggested.
wallabag  | Generating optimized autoload files
wallabag  | Class SimpleHtmlDom\simple_html_dom_node located in ./vendor/mgargano/simplehtmldom/src/simple_html_dom.php does not comply with psr-0 autoloading standard. Skipping.
wallabag  | Class SimpleHtmlDom\simple_html_dom located in ./vendor/mgargano/simplehtmldom/src/simple_html_dom.php does not comply with psr-0 autoloading standard. Skipping.
wallabag  | 54 packages you are using are looking for funding.
wallabag  | Use the `composer fund` command to find out more!
wallabag  | > Incenteev\ParameterHandler\ScriptHandler::buildParameters
wallabag  | Updating the "app/config/parameters.yml" file
wallabag  | > bin/console cache:clear --no-warmup
wallabag  | 
wallabag  | 
wallabag  |  [WARNING] Some commands could not be registered:                               
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  |  [WARNING] Some commands could not be registered:                               
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  |  // Clearing the cache for the prod environment with debug                      
wallabag  |  // false                                                                       
wallabag  | 
wallabag  | 
wallabag  |  [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
wallabag  | 
wallabag  | 
wallabag  | > bin/console assets:install web --symlink --relative
wallabag  | 
wallabag  | 
wallabag  |  [WARNING] Some commands could not be registered:                               
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  |  [WARNING] Some commands could not be registered:                               
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In ExceptionConverter.php line 49:
wallabag  |                                                                                
wallabag  |   An exception occurred while executing a query: SQLSTATE[42S02]: Base table   
wallabag  |   or view not found: 1146 Table 'wallabag.wallabag_internal_setting' doesn't   
wallabag  |   exist                                                                        
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Exception.php line 28:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | In Statement.php line 121:
wallabag  |                                                                                
wallabag  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wallabag.wallaba  
wallabag  |   g_internal_setting' doesn't exist                                            
wallabag  |                                                                                
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  | 
wallabag  |  Trying to install assets as relative symbolic links.
wallabag  | 
wallabag  | 
wallabag  |  --- ------------------------ ------------------ 
wallabag  |       Bundle                   Method / Error    
wallabag  |  --- ------------------------ ------------------ 
wallabag  |   ✔   NelmioApiDocBundle       relative symlink  
wallabag  |   ✔   CraueConfigBundle        relative symlink  
wallabag  |   ✔   BabDevPagerfantaBundle   relative symlink  
wallabag  |   ✔   FOSJsRoutingBundle       relative symlink  
wallabag  |  --- ------------------------ ------------------ 
wallabag  | 
wallabag  | 
wallabag  |  [OK] All assets were successfully installed.                                   
wallabag  | 
wallabag  | 
wallabag  | wallabag is ready!
wallabag-redis-1  | 1:C 14 Jul 2023 18:33:16.060 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
wallabag-redis-1  | 1:C 14 Jul 2023 18:33:16.060 # Redis version=7.0.12, bits=64, commit=00000000, modified=0, pid=1, just started
wallabag-redis-1  | 1:C 14 Jul 2023 18:33:16.060 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
wallabag-redis-1  | 1:M 14 Jul 2023 18:33:16.061 * monotonic clock: POSIX clock_gettime
wallabag-redis-1  | 1:M 14 Jul 2023 18:33:16.062 * Running mode=standalone, port=6379.
wallabag-redis-1  | 1:M 14 Jul 2023 18:33:16.062 # Server initialized
wallabag-redis-1  | 1:M 14 Jul 2023 18:33:16.063 * Ready to accept connections

[nicosomb]

FYI, we also have this error : https://github.com/wallabag/wallabag/actions/runs/5562660517/jobs/10161107194#step:8:19

But we didn't see it because it fails silently.

[j0k3r]

Well, it's not errors, it's warning.
During command registration, a connection to the database is required. During test, the initial database is the one from wallabag 2.0.0. wallabag_internal_setting didn't exist at that time.
Then we run migration and the table is created.

@jerryc127 from what log display, there is no error and wallabag seems running.
What you should do then is running migration https://github.com/wallabag/docker#upgrading

[nicosomb]

OK, it's warning, but all is in red on CLI 😬 that's why it can be worrying for users.

During test, the initial database is the one from wallabag 2.0.0. wallabag_internal_setting didn't exist at that time.

I can't find in the code used with what you mean by During test. I have these errors during make install command locally too.

[doc75]

Reproduced when trying to install the docker version 2.9.0 with PostgreSql from scratch. Procedure already tested on older version without any version (but before 2.6 as far as I can remember)