search

gbook / nidb

NeuroInformatics Database
GNU General Public License v3.0
26 stars 8 forks source link

Search query empty, but results found. #124

Closed andersonwinkler closed 1 year ago

andersonwinkler commented 1 year ago

Describe the bug Search query doesn't show table with results.

Steps to reproduce behavior Go to Search, put some criteria, then search.

Screenshots Capture

OS or web browser Firefox or Edge, on Windows

Additional context I must have done something wrong. I began importing a new batch of data of a project. The first subject has 2 visits, the first belonging to an existing project; those images were already there and assigned to that old project. The second visit belongs to the new one. But I had forgotten to create the new project. Then I created it, and re-imported the batch from start. Then the search stopped working.

If I go to phpMyAdmin and run the corresponding SQL query, it works and gives the result. But in the search.php page, it's as in the screenshot.

andersonwinkler commented 1 year ago

The enrollment table has the project_id "-1" for 3 subjects. Could that be the reason? (the 3 that were imported before I realized my error in not creating the project in advance). Could I delete these rows?

andersonwinkler commented 1 year ago

Never mind, it looks like somehow I didn't have permissions to any project anymore. After granting permissions to myself again, I can see everything!