Fatal error when adding a phone field on /admin/config/smsframework/phone_number/add

Created on 8 November 2017, about 7 years ago
Updated 14 April 2023, over 1 year ago

on http://mysite/admin/config/smsframework/phone_number/add

I associate the phone field in the profile.

When I click enter I get the following error and WSOD on that page:

Drupal\Core\Entity\Query\QueryException: Invalid specifier 'entity__target_type' in Drupal\Core\Entity\Query\Sql\Tables->addField() (line 289 of core/lib/Drupal/Core/Entity/Query/Sql/Tables.php).

πŸ› Bug report
Status

Closed: cannot reproduce

Version

1.0

Component

Core Framework

Created by

πŸ‡ΊπŸ‡ΈUnited States SocialNicheGuru

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States dereks

    @SocialNicheGuru - did you get any insight into this? I'm also getting an SQL error with an Open Social install.

    Here's the error I'm getting:

    Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fmpmobile.sms_phone_number_verification' doesn't exist: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "sms_phone_number_verification" "base_table" INNER JOIN "sms_phone_number_verification" "sms_phone_number_verification" ON "sms_phone_number_verification"."id" = "base_table"."id" WHERE ("sms_phone_number_verification"."entity__target_type" = :db_condition_placeholder_0) AND ("sms_phone_number_verification"."bundle" LIKE :db_condition_placeholder_1 ESCAPE '\\') AND ("sms_phone_number_verification"."status" = :db_condition_placeholder_2) AND ("sms_phone_number_verification"."created" < :db_condition_placeholder_3)) "subquery"; Array ( [:db_condition_placeholder_0] => user [:db_condition_placeholder_1] => user [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => 1681419327 ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 266 of core/lib/Drupal/Core/Entity/Query/Sql/Query.php).

    I don't know if it's related, but I thought I'd ask since both are SQL issues.

  • πŸ‡¦πŸ‡ΊAustralia dpi Perth, Australia

    Something has gone terribly wrong if you're missing an entity table. Consider re-installing the module or checking your database configuration.

    This is likely a problem with your setup/environment/host.

    Please create a new issue in the future

  • πŸ‡ΊπŸ‡ΈUnited States SocialNicheGuru

    It's been so long ago I do not remember.

Production build 0.71.5 2024