Most of my projects are missing from the projects screen. All of them do show up in the "today" screen, and if I click one there, it then shows up in the projects screen,, at least for a while. The Projects table in MySQL looks ok, I'm not sure if this is database corruption that I'm just not seeing, or something else. Is there a way to pull logs that would be helpful, or does someone have any other advice in troubleshooting this? This happened after my computer shut down improperly (the servers are on this machine as well.) The activity I've created doesn't show up in activities either.
Try and repair your db.
You can use mysqlcheck for instance (search the web for help)
I ran a check on the full projeqtor database, all tables are good.
I tried repair, and get "The storage engine for the table doesn't support repair" apparently this is InnoDB, which doesn't support repair. Optimize did a recreate+analyze, which completed successfully.
The problem still exists unchanged after these actions, to be clear.
Thank you
Mybe you can try export (dump) db and reimport (with new name) and use new db.
Also try consistency check in Adlinistration screen.
Thank you again. I tried exporting the database, then creating a new one with a different name and importing into it, the problem remains as before. I also did a consistency check earlier, no problems were found.
Just to be sure, did you select a project in the project selector ?
Or any filter applied ?