Hello, this is my first report, so I will surely do something wrong. I have been managing Drupal 8 systems for three years and have never needed to add a problem to the problem queue. This means that Drupal is a good CMS and that the Drupal community is great.
Today a problem has jumped that I could not solve via Google.
Today I have created a content type and a node of this type. Then I wanted to add another field for the web address, called field_web.
When I wanted to see the storage options for that field, and the famous white page appeared: "The website encountered an unexpected error. Please try again later."
Consulted reports/dblog says: Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_web_value' in 'where clause': SELECT 1 AS expression FROM {node_revision__field_web} t WHERE (field_web_value IS NOT NULL) OR (field_web_format IS NOT NULL) LIMIT 1 OFFSET 0; Array ( ) en Drupal\Core\Entity\Sql\SqlContentEntityStorage->countFieldData() (linea 1808 de /intentionally-removed/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
I have searched for the solution without success. Consequently, I thought that it was better to delete the field because the content type worked perfectly and was going to put it into production.
When I tried to remove the content type field the famous white screen came out again.
I have cleaned the caches and updated the database with update.php and with drush and the database was fine. I have verified that the tables in the field_web field have been created.
At this point I thought that if I deleted the tables "node_field_web" and "node_revision_field_web", the content type field would disappear, and I have done so.
The result is that now the website is not accessible to users, and it shows the famous white screen, but I can access the backend as administrator.
Consulted reports/dblog says: Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gcaravaning.node__field_web' doesn't exist: SELECT t.* FROM {node__field_web} t WHERE (entity_id IN (:db_condition_placeholder_0)) AND (deleted = :db_condition_placeholder_1) AND (langcode IN (:db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4)) ORDER BY delta ASC; Array ( [:db_condition_placeholder_0] => 230 [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => es [:db_condition_placeholder_3] => und [:db_condition_placeholder_4] => zxx ) en Drupal\Core\Entity\Sql\SqlContentEntityStorage->loadFromDedicatedTables() (linea 1261 de /intentionally-removed/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Thank you very much from Spain for your help.
Closed: cannot reproduce
9.5
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
There has been no response in 7 months and there are no steps to reproduce.
Therefore, closing as cannot reproduce. If you are experiencing this problem on a supported version of Drupal reopen the issue, by setting the status to 'Active', and provide complete steps to reproduce the issue → (starting from "Install Drupal core").
Thanks!