ProjeQtOr free project management software - [SOLVED] Empty Project Slots since upgrade to v8.2.4 - Page 2 - ProjeQtOr
 

[SOLVED] Empty Project Slots since upgrade to v8.2.4

More
15 Dec 2019 18:59 #7 by babynus

I tried to do the delete thing that you described and I had a problem at the the first step. I am in the Administrator Account, click on projects and applied the filter for "name" as empty. The results came back as 0 projects.

It seems name is not null but empty string (or just spaces)
You can possibly locate them on list of project and select them in multiple-update mode to delete them

I discovered that I can I cannot delete each project individually either. The delete button is greyed out even when I click on one of these empty projects

Strange, it seem you have no right to delete them...
Did you connect as admin ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
16 Dec 2019 01:49 #8 by iconic
I am connected as ADMIN Account but the the delete button is greyed out. Is there something I am doing wrong, or a feature I have to activate for Administrator to delete them one at a time.

Please Log in or Create an account to join the conversation.

More
16 Dec 2019 01:51 #9 by iconic
Using the Administrator Account I pressed on the multiple button (the button with the 2 save discs) displaying.
I selected these emply projects and when I clicked to delete them I receive this error.

#223 :
Invalid controls.
you don't have rights to delete this item
#197 :
Invalid controls.
you don't have rights to delete this item
#196 :
Invalid controls.
you don't have rights to delete this item
#195 :
Invalid controls.
you don't have rights to delete this item
#194 :
Invalid controls.
you don't have rights to delete this item
#193 :
Invalid controls.
you don't have rights to delete this item
#192 :
Invalid controls.
you don't have rights to delete this item
#191 :
Invalid controls.
you don't have rights to delete this item

Please Log in or Create an account to join the conversation.

More
17 Dec 2019 17:12 #10 by babynus
Can you chack access rights for Project ?.
On Acces Rights > Access to Data (project dependant), check that Admin profile hase mod e"Manager+" on Project.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
18 Dec 2019 01:23 #11 by iconic
Hi,
Using my administrator access login details, I logged in and checked and under Access to data (project dependent) Administrator has Manager+ showing. In fact in almost everything it has Manager+ selected.

Please Log in or Create an account to join the conversation.

More
21 Dec 2019 17:00 #12 by babynus
It's very strange, I never faced such issue.
I made several migrations to V8.3, on several systems (Linux / Windows, MySql / Postgres) without reproducing such isse.
I'm afraid you'll have to delete manualy (I hate this, but it seems to be the only solution).
Here is the query to do this :
delete from planningelement where refType='Project' and refId in (select id from project where idProjectType is null and creationDate is null);
delete from project where idProjectType is null and creationDate is null;
Please be sure to backup your database before executing the query in case of too large deletion.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.040 seconds