Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Projects Missing
 
Notifications
Clear all

Projects Missing

7 Posts
2 Users
0 Reactions
5,640 Views
(@piper8)
Posts: 4
Active Member
Topic starter
 
[#5903]

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.


 
Posted : 10 Apr 2019 20H17
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Try and repair your db.
You can use mysqlcheck for instance (search the web for help)


 
Posted : 10 Apr 2019 20H26
(@piper8)
Posts: 4
Active Member
Topic starter
 

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.


 
Posted : 10 Apr 2019 20H40
(@piper8)
Posts: 4
Active Member
Topic starter
 

The problem still exists unchanged after these actions, to be clear.
Thank you


 
Posted : 10 Apr 2019 20H44
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Mybe you can try export (dump) db and reimport (with new name) and use new db.

Also try consistency check in Adlinistration screen.


 
Posted : 11 Apr 2019 0H08
(@piper8)
Posts: 4
Active Member
Topic starter
 

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.


 
Posted : 11 Apr 2019 18H33
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Just to be sure, did you select a project in the project selector ?
Or any filter applied ?


 
Posted : 12 Apr 2019 2H17
Share:

Scroll to Top