- Status changed to Fixed
over 1 year ago 5:15am 29 June 2023 Automatically closed - issue fixed for 2 weeks with no activity.
I got following error:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd9.consumer' doesn't exist: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "consumer" "base_table" GROUP BY base_table.id) "subquery"; Array ( ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 266 of /app/core/lib/Drupal/Core/Entity/Query/Sql/Query.php).
I installed and enable simple oauth → and consumers → using composer and drush.
When I clicked on 'Client' tab ('admin/config/services/consumer') under Configuration >> People >> Simple Oauth, I got error: "The website encountered an unexpected error. Please try again later."
I checked the error log message and found that it's related to
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd9.consumer' doesn't exist: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "consumer" "base_table" GROUP BY base_table.id) "subquery"; Array ( ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 266 of /app/core/lib/Drupal/Core/Entity/Query/Sql/Query.php).
NOTE: when I check the database, I could not find the 'consumer' table though it has 'consumer__roles' table.
Fixed
1.11
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Automatically closed - issue fixed for 2 weeks with no activity.