Skip to main content
deleted 15 characters in body
Source Link
Brad Bell
  • 67.6k
  • 6
  • 75
  • 145

I've been working through my long overdue updates. I'm now trying to go from 3.7.1 to 3.7.19 (note: I stop at increments that the CP Update list shows an "update warning triangle").

The composer update worked fine, but the migration failed, here's the migrations that were to be executed:

*Checking for pending migrations ...

  • Total 1 new Craft migration to be applied:

    - m210829_000000_element_index_tweak 
    
  • Total 3 new Social migrations to be applied:

    - m190304_031715_soft_delete_users
    - m190518_014619_soft_delete_users_fix
    - m190519_185640_soft_delete_login_accounts
    

The last migration m190519_185640_soft_delete_login_accountsm190519_185640_soft_delete_login_accounts failed, Here's the error:

*** applying m190519_185640_soft_delete_login_accounts Exception: SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "userelements" LINE 5: WHERE userElements.dateDeleted IS NOT NULL ^ The SQL being executed was: SELECT "social_login_accounts"."id", "social_login_accounts"."userId" FROM "social_login_accounts" "social_login_accounts" LEFT JOIN "elements" "userElements" ON "userElements"."id" = "social_login_accounts"."userId" LEFT JOIN "elements" "loginAccountElements" ON "loginAccountElements"."id" = "social_login_accounts"."userId" WHERE userElements.dateDeleted IS NOT NULL (/home/forge/www.myfaithvotessite.orgcom/vendor/yiisoft/yii2/db/Schema.php:676)

It appears the table, userelements is missing?

How do I move forward? THANK YOU!

Duane

I've been working through my long overdue updates. I'm now trying to go from 3.7.1 to 3.7.19 (note: I stop at increments that the CP Update list shows an "update warning triangle").

The composer update worked fine, but the migration failed, here's the migrations that were to be executed:

*Checking for pending migrations ...

  • Total 1 new Craft migration to be applied:

    - m210829_000000_element_index_tweak 
    
  • Total 3 new Social migrations to be applied:

    - m190304_031715_soft_delete_users
    - m190518_014619_soft_delete_users_fix
    - m190519_185640_soft_delete_login_accounts
    

The last migration m190519_185640_soft_delete_login_accounts failed, Here's the error:

*** applying m190519_185640_soft_delete_login_accounts Exception: SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "userelements" LINE 5: WHERE userElements.dateDeleted IS NOT NULL ^ The SQL being executed was: SELECT "social_login_accounts"."id", "social_login_accounts"."userId" FROM "social_login_accounts" "social_login_accounts" LEFT JOIN "elements" "userElements" ON "userElements"."id" = "social_login_accounts"."userId" LEFT JOIN "elements" "loginAccountElements" ON "loginAccountElements"."id" = "social_login_accounts"."userId" WHERE userElements.dateDeleted IS NOT NULL (/home/forge/www.myfaithvotes.org/vendor/yiisoft/yii2/db/Schema.php:676)

It appears the table, userelements is missing?

How do I move forward? THANK YOU!

Duane

I've been working through my long overdue updates. I'm now trying to go from 3.7.1 to 3.7.19 (note: I stop at increments that the CP Update list shows an "update warning triangle").

The composer update worked fine, but the migration failed, here's the migrations that were to be executed:

*Checking for pending migrations ...

  • Total 1 new Craft migration to be applied:

    - m210829_000000_element_index_tweak 
    
  • Total 3 new Social migrations to be applied:

    - m190304_031715_soft_delete_users
    - m190518_014619_soft_delete_users_fix
    - m190519_185640_soft_delete_login_accounts
    

The last migration m190519_185640_soft_delete_login_accounts failed, Here's the error:

*** applying m190519_185640_soft_delete_login_accounts Exception: SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "userelements" LINE 5: WHERE userElements.dateDeleted IS NOT NULL ^ The SQL being executed was: SELECT "social_login_accounts"."id", "social_login_accounts"."userId" FROM "social_login_accounts" "social_login_accounts" LEFT JOIN "elements" "userElements" ON "userElements"."id" = "social_login_accounts"."userId" LEFT JOIN "elements" "loginAccountElements" ON "loginAccountElements"."id" = "social_login_accounts"."userId" WHERE userElements.dateDeleted IS NOT NULL (/home/forge/www.site.com/vendor/yiisoft/yii2/db/Schema.php:676)

It appears the table, userelements is missing?

How do I move forward? THANK YOU!

Source Link

Upgrading from Craft 3.7.1 to 3.7.19

I've been working through my long overdue updates. I'm now trying to go from 3.7.1 to 3.7.19 (note: I stop at increments that the CP Update list shows an "update warning triangle").

The composer update worked fine, but the migration failed, here's the migrations that were to be executed:

*Checking for pending migrations ...

  • Total 1 new Craft migration to be applied:

    - m210829_000000_element_index_tweak 
    
  • Total 3 new Social migrations to be applied:

    - m190304_031715_soft_delete_users
    - m190518_014619_soft_delete_users_fix
    - m190519_185640_soft_delete_login_accounts
    

The last migration m190519_185640_soft_delete_login_accounts failed, Here's the error:

*** applying m190519_185640_soft_delete_login_accounts Exception: SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "userelements" LINE 5: WHERE userElements.dateDeleted IS NOT NULL ^ The SQL being executed was: SELECT "social_login_accounts"."id", "social_login_accounts"."userId" FROM "social_login_accounts" "social_login_accounts" LEFT JOIN "elements" "userElements" ON "userElements"."id" = "social_login_accounts"."userId" LEFT JOIN "elements" "loginAccountElements" ON "loginAccountElements"."id" = "social_login_accounts"."userId" WHERE userElements.dateDeleted IS NOT NULL (/home/forge/www.myfaithvotes.org/vendor/yiisoft/yii2/db/Schema.php:676)

It appears the table, userelements is missing?

How do I move forward? THANK YOU!

Duane