>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3208566. --> Reported by: [rkoller](https://www.drupal.org/user/3217695) >>> <p>I ran into something odd. I've performed a fresh install of Drupal 9.1.6 (on php 7.4 and mariadb 10.3 - i am using DDEV and was testing Mutagen for caching and speeding up my local environment). I've used an ansible script to set up a new ddev project, then perform a <code>composer create</code> to create a fresh drupal 9 project, then install <code>drush</code>, afterwards perform a <code>drush si standard</code> creating an admin user, then <code>composer require</code> the <code>admin_toolbar</code> and the <code>storage</code> module and afterwards install the two with <code>drush en</code>. When I've first experienced the error I haven't had setup a storage type yet and went directly to <code>/admin/content/storage</code> and got the following error (admin user as user in the log messages table view): </p> <p>Location: <code>https://storageentity.ddev.site/admin/content/storage</code><br> Referer: <code>https://storageentity.ddev.site/user/1</code><br> Message:<br> <code>Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Storage[storage]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '***VIEW_OWN_UNPUBLISHED_MEDIA*** = 1) OR ***ADMINISTER_MEDIA*** = 1)) "subquery"' at line 6: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM {storage_field_data} "storage_field_data" WHERE (storage_field_data.status = 1 OR (storage_field_data.user_id = 1 AND 1 &lt;&gt; 0 AND ***VIEW_OWN_UNPUBLISHED_MEDIA*** = 1) OR ***ADMINISTER_MEDIA*** = 1)) "subquery"; Array ( ) in Drupal\views\Plugin\views\query\Sql-&gt;execute() (line 1548 of /var/www/html/web/core/modules/views/src/Plugin/views/query/Sql.php).</code></p> <p>the referer varied when testing different scenarios debugging the issue but the location and error message remained identical </p> <p><code>https://storageentity.ddev.site/admin/structure/storage_types/storage/edit/form-display</code></p> <p><code>https://storageentity.ddev.site/</code></p> <p><code>https://storageentity.ddev.site/admin/reports/dblog/event/47</code></p> <p><code>https://test.ddev.site/admin/structure/storage_types/mystorageentity/edit/fields?destinations%5B0%5D=/admin/structure/storage_types/mystorageentity/edit/fields/add-field&amp;field_config=storage.mystorageentity.field_one_long_body_text</code></p> <p>i've tried deactivating mutagen in the project i ran first into the issue. also tried to create a storage type and then try to access <code>/admin/content/storage</code> to create an entity for that storage type. always the same error. also tried to create a new project and create a storage type first and then go to <code>/admin/content/storage</code> - again the same error. the interesting part is i've then started the sandbox project i've first tested the storage module with (where i also have already created a storage type with storage entities) and there the error doesn't take place - i tried it with mutagen activated as well as deactivated both working without a problem. that project is also on drupal <code>9.1.6</code>. the only possible difference drupal <code>9.1.6</code> was released 6 days ago and i've created the project which is working with drupal <code>9.1.5</code> according to the timestamps in the storage module issue queue. if you need more informations how i could help debug things let me know. </p> <p>after writing that i had an idea. i've set up a new project now locked on drupal <code>9.1.5</code>. but somehow the same result. :( </p> <p><code>Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Storage[storage]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '***VIEW_OWN_UNPUBLISHED_MEDIA*** = 1) OR ***ADMINISTER_MEDIA*** = 1)) "subquery"' at line 6: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM {storage_field_data} "storage_field_data" WHERE (storage_field_data.status = 1 OR (storage_field_data.user_id = 1 AND 1 &lt;&gt; 0 AND ***VIEW_OWN_UNPUBLISHED_MEDIA*** = 1) OR ***ADMINISTER_MEDIA*** = 1)) "subquery"; Array ( ) in Drupal\views\Plugin\views\query\Sql-&gt;execute() (line 1548 of /var/www/html/web/core/modules/views/src/Plugin/views/query/Sql.php).</code></p> <p>accessing <code>/admin/content</code> or <code>/admin/content/comment</code> or <code>/admin/content/files</code> still works</p>