Error for anonymous users after updating to alpha2

This happens if, for some reason, the foreign key is not added to the file_metadata table.

In my scenario the error was coming from a view that had the "View published content" permission.

FYi the problem may stem from #2064305: DB error on fresh install of module using sqlite where the primary key was changed. I noticed that after running through all of the database updates for alpha2, the table structure was left with a primary key but no foreign keys.

This query should add the necessary foreign key:

ALTER TABLE file_metadata ADD CONSTRAINT file_managed FOREIGN KEY (fid) REFERENCES file_managed (fid);

For my own notes, it was the gallery_content view, block_5 display.

Just to note, I was looking at the wrong table, the primary keys are correct on the {file_metadata} table.

FYI I'm resolving the issue on this one site by granting anon users and auth users the 'bypass file access' permission as we're not using file permissions at all, though obviously that's far from an ideal scenario.

Further info - I added the foreign key to the table but the error still occurs.

Here's the query I get from the Views admin:

SELECT node_field_data_field_gallery_items.nid AS node_field_data_field_gallery_items_nid, field_data_field_gallery_items.delta AS field_data_field_gallery_items_delta, 'node' AS field_data_field_gallery_item_media_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_gallery_items} field_data_field_gallery_items ON node.nid = field_data_field_gallery_items.entity_id AND (field_data_field_gallery_items.entity_type = 'node' AND field_data_field_gallery_items.deleted = '0')
LEFT JOIN {node} node_field_data_field_gallery_items ON field_data_field_gallery_items.field_gallery_items_nid = node_field_data_field_gallery_items.nid
LEFT JOIN {file_usage} node_field_data_field_gallery_items__file_usage ON node_field_data_field_gallery_items.nid = node_field_data_field_gallery_items__file_usage.id AND node_field_data_field_gallery_items__file_usage.type = 'node'
INNER JOIN {file_managed} file_managed_file_usage ON node_field_data_field_gallery_items__file_usage.fid = file_managed_file_usage.fid
WHERE (( (node.status = '1') AND (node.type IN  ('gallery')) AND (node.nid = '8436' ) ))
ORDER BY field_data_field_gallery_items_delta ASC
LIMIT 6 OFFSET 0

Putting this back to the original bug as I opened another issue for the foreign key problem: #2069099: Foreign key missing on {file_metadata} table after updating to alpha2