wallabag icon indicating copy to clipboard operation
wallabag copied to clipboard

Issue while installing Wallabag 2.6.1

Open prbt2016 opened this issue 2 years ago • 12 comments

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: [email protected]
  fosuser_registration: true
  fosuser_confirmation: true
  fos_oauth_server_access_token_lifetime: 3600
  fos_oauth_server_refresh_token_lifetime: 1209600
  from_email: [email protected]
  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

prbt2016 avatar Jun 22 '23 11:06 prbt2016

I was trying to update the Cloudron package and it errors here as well. We use MySQL 8.0.31 . The command appears to succeed in the end but it reports a bynch of errors in the beginning. Calling doctrine:migrations:migrate after installation fails as well.

root@1f3ea1a3-6559-4447-b66c-0907ff20a33f:/app/code/wallabag#     $gosu php bin/console wallabag:install --env prod --no-interaction

                                                                                                                        
 [WARNING] Some commands could not be registered:                                                                       
                                                                                                                        

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does no  
  t exist                                                                                                                                  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                                                               
                                                               ^                                                                           
                                                                                                                                           

In Exception.php line 28:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In Statement.php line 121:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does no  
  t exist                                                                                                                                  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                                                               
                                                               ^                                                                           
                                                                                                                                           

In Exception.php line 28:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In Statement.php line 121:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does no  
  t exist                                                                                                                                  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                                                               
                                                               ^                                                                           
                                                                                                                                           

In Exception.php line 28:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In Statement.php line 121:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   


                                                                                                                        
 [WARNING] Some commands could not be registered:                                                                       
                                                                                                                        

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does no  
  t exist                                                                                                                                  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                                                               
                                                               ^                                                                           
                                                                                                                                           

In Exception.php line 28:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In Statement.php line 121:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does no  
  t exist                                                                                                                                  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                                                               
                                                               ^                                                                           
                                                                                                                                           

In Exception.php line 28:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In Statement.php line 121:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does no  
  t exist                                                                                                                                  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                                                               
                                                               ^                                                                           
                                                                                                                                           

In Exception.php line 28:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   

In Statement.php line 121:
                                                                                                   
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_internal_setting" does not exist  
  LINE 1: ..., t0.name AS name_2, t0.section AS section_3 FROM "wallabag_...                       
                                                               ^                                   
                                                                                                   


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

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

 ------------------------ -------- ---------------- 
  Checked                  Status   Recommendation  
 ------------------------ -------- ---------------- 
  PDO Driver (pdo_pgsql)   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.
---------------------------------

 Creating schema...
 Clearing the cache...

 Database successfully setup.

Step 3 of 4: Administration setup.
----------------------------------

 Administration successfully setup.

Step 4 of 4: Config setup.
--------------------------

 Config successfully setup.

                                                                                                                        
 [OK] wallabag has been successfully installed.                                                                         
                                                                                                                        

                                                                                                                        
 [OK] You can now configure your web server, see https://doc.wallabag.org                                               
                                                                                                                        

Later, calling doctrine:migrations:migrate:

root@1f3ea1a3-6559-4447-b66c-0907ff20a33f:/app/code/wallabag# $gosu php bin/console doctrine:migrations:migrate --env prod --no-interaction
[notice] Migrating up to Application\Migrations\Version20230613121354
[notice] Migration Application\Migrations\Version20161022134138 skipped during Execution. Reason: "This migration only apply to MySQL"
[notice] Migration Application\Migrations\Version20161214094402 skipped during Execution. Reason: "It seems that you already played this migration."
[notice] Migration Application\Migrations\Version20170510082609 skipped during Execution. Reason: "This migration only apply to MySQL"
[error] Migration Application\Migrations\Version20170606155640 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_craue_config_setting" does not exist
LINE 1: SELECT * FROM "wallabag_craue_config_setting" WHERE name = '...
                      ^"
11:43:00 CRITICAL  [console] Error thrown while running command "doctrine:migrations:migrate --env prod --no-interaction". Message: "An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_craue_config_setting" does not exist
LINE 1: SELECT * FROM "wallabag_craue_config_setting" WHERE name = '...
                      ^" ["exception" => Doctrine\DBAL\Exception\TableNotFoundException^ { …},"command" => "doctrine:migrations:migrate --env prod --no-interaction","message" => """  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_craue_config_setting" does not exist\n  LINE 1: SELECT * FROM "wallabag_craue_config_setting" WHERE name = '...\n                        ^  """]

In ExceptionConverter.php line 71:
                                                                                                                                           
  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_craue_config_setting" doe  
  s not exist                                                                                                                              
  LINE 1: SELECT * FROM "wallabag_craue_config_setting" WHERE name = '...                                                                  
                        ^                                                                                                                  
                                                                                                                                           

In Exception.php line 28:
                                                                                                       
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_craue_config_setting" does not exist  
  LINE 1: SELECT * FROM "wallabag_craue_config_setting" WHERE name = '...                              
                        ^                                                                              
                                                                                                       

In Connection.php line 70:
                                                                                                       
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "wallabag_craue_config_setting" does not exist  
  LINE 1: SELECT * FROM "wallabag_craue_config_setting" WHERE name = '...                              
                        ^                                                                              
                                                                                                       

doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]

gramakri avatar Jun 22 '23 11:06 gramakri

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

j0k3r avatar Jun 22 '23 11:06 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.

j0k3r avatar Jun 22 '23 11:06 j0k3r

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.

prbt2016 avatar Jun 22 '23 12:06 prbt2016

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

j0k3r avatar Jun 22 '23 12:06 j0k3r

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: [email protected]
    fosuser_registration: true
    fosuser_confirmation: true
    fos_oauth_server_access_token_lifetime: 3600
    fos_oauth_server_refresh_token_lifetime: 1209600
    from_email: [email protected]
    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 avatar Jun 22 '23 12:06 prbt2016

Hello @j0k3r ,

Any updates regarding the same ?.

Kindly let me know.

prbt2016 avatar Jun 27 '23 10:06 prbt2016

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

jerryc127 avatar Jul 14 '23 18:07 jerryc127

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.

nicosomb avatar Jul 17 '23 12:07 nicosomb

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

j0k3r avatar Jul 17 '23 12:07 j0k3r

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.

nicosomb avatar Jul 17 '23 12:07 nicosomb

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)

doc75 avatar Apr 07 '24 11:04 doc75