Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: relation "swp_user_reset_password_request" does not exist #1221

Open
billux opened this issue Mar 30, 2023 · 0 comments
Open

ERROR: relation "swp_user_reset_password_request" does not exist #1221

billux opened this issue Mar 30, 2023 · 0 comments

Comments

@billux
Copy link

billux commented Mar 30, 2023

When trying to setup web-publisher using docker-compose, I encounter the folowing error when populating the DB:

~/superdesk-publisher/etc/docker# docker-compose run php php -d memory_limit=-1 bin/console doctrine:fixtures:load
Creating docker_php_run ... done

 Careful, database "publisher_dev" will be purged. Do you want to continue? (yes/no) [no]:
 > yes

   > purging database
10:47:33 CRITICAL  [console] Error thrown while running command "doctrine:fixtures:load". Message: "An exception occurred while executing 'DELETE FROM swp_user_reset_password_request':

SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "swp_user_reset_password_request" does not exist
LINE 1: DELETE FROM swp_user_reset_password_request
                    ^" ["exception" => Doctrine\DBAL\Exception\TableNotFoundException^ { …},"command" => "doctrine:fixtures:load","message" => """  An exception occurred while executing 'DELETE FROM swp_user_reset_password_request':\n  \n  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "swp_user_reset_password_request" does not exist\n  LINE 1: DELETE FROM swp_user_reset_password_request\n                      ^  """]

In AbstractPostgreSQLDriver.php line 82:
                                                                                                        
  An exception occurred while executing 'DELETE FROM swp_user_reset_password_request':                  
                                                                                                        
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "swp_user_reset_password_request" does not exis  
  t                                                                                                     
  LINE 1: DELETE FROM swp_user_reset_password_request                                                   
                      ^                                                                                 
                                                                                                        

In Exception.php line 18:
                                                                                                        
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "swp_user_reset_password_request" does not exis  
  t                                                                                                     
  LINE 1: DELETE FROM swp_user_reset_password_request                                                   
                      ^                                                                                 
                                                                                                        

In PDOConnection.php line 55:
                                                                                                        
  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "swp_user_reset_password_request" does not exis  
  t                                                                                                     
  LINE 1: DELETE FROM swp_user_reset_password_request                                                   
                      ^                                                                                 
                                                                                                        

doctrine:fixtures:load [--append] [--group GROUP] [--em EM] [--purger PURGER] [--purge-exclusions PURGE-EXCLUSIONS] [--shard SHARD] [--purge-with-truncate]

ERROR: 1

Indeed, It can't see any table named swp_user_reset_password_request in publisher_dev DB.

FYI, the migrations were correctly applied:

~/superdesk-publisher/etc/docker# docker-compose run php php bin/console doctrine:migrations:migrate
Creating docker_php_run ... done

 WARNING! You are about to execute a migration in database "publisher_dev" that could result in schema changes and data loss. Are you sure you wish to continue? (yes/no) [yes]:
 > yes

[notice] Migrating up to SWP\Migrations\Version20210426085015
[warning] Migration SWP\Migrations\Version20170221091231 was executed but did not result in any SQL statements.
[warning] Migration SWP\Migrations\Version20180118194100 was executed but did not result in any SQL statements.
[warning] Migration SWP\Migrations\Version20180223095718 was executed but did not result in any SQL statements.
[warning] Migration SWP\Migrations\Version20180605111249 was executed but did not result in any SQL statements.
[warning] Migration SWP\Migrations\Version20181008115755 was executed but did not result in any SQL statements.
fetching 2000 starting from 0fetching 2000 starting from 0
[warning] Migration SWP\Migrations\Version20210112135555 was executed but did not result in any SQL statements.
[warning] Migration SWP\Migrations\Version20210119142827 was executed but did not result in any SQL statements.
[warning] Migration SWP\Migrations\Version20210330074519 was executed but did not result in any SQL statements.
[notice] finished in 1232.1ms, used 36.5M memory, 118 migrations executed, 618 sql queries
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant