Forum

Unable to delete an...
 
Notifications
Clear all

Unable to delete an access mode I created

14 Posts
2 Users
0 Reactions
8,585 Views
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 
[#4202]

Hello

I created a new access mode "GestionnaireR".

After many tries without success to use it in screen "Data access (project dependant)" (this access was visible in the list, but impossible to save), I decided ti delete it.

But when I go on the screen "Access mode", I see it but can't delete 🙁 . Projeqtor tell me this item seems to be recently deleted (see image below).

I didn't delete it....but I want to....but I can't :silly:

I understand now why it didn't work in screen "Data access" but I don't understand why it is like that...and how delete it really.

Could you help me ?

Thanks


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 14 Mar 2017 19H43
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

And now, the situation is worse 😳

I created a new access mode, I save and.......all my access mode are no more visible !

I disconnect, delete my browser cache, reconnect, it's always the same.

I try with another admin account, it's the same : I don't have anymore access to the access mode ...


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 14 Mar 2017 20H09
(@babynus)
Posts: 14952
Member Admin
 

First issue may be due to some caching (most habilitation parameters use cache)

Second is more blocking. Possibily can be due to unexpected character in name ?
Can you check for errors in the log file or in the browser console ?


 
Posted : 14 Mar 2017 22H15
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hello Babynus,

This not a problem of cache, I delete always my cache when I quit my browsers : the problem occurs with IE, Firefox, Chrome, with empty cache.

There are no errors in log or console, absolutely nothing.

And for specific characters, I don't think : I have created GestionnaireR and GestionnaireP (but maybe a special character by error, it can be possible).

Is there a way to go directly with Mysql to the table(s) to delete some entry that cause the problem ? (the last 2 entries I created ?)

Thanks


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 15 Mar 2017 10H48
(@babynus)
Posts: 14952
Member Admin
 

Hi,

For Access Mode, there is not problem to delete in the DB, as long as you are sure they are not used yet.
This is because there is no automation that will create other items automatically.

But I would be interested in projeqtor log report and browser console errors to identify source of error.


 
Posted : 15 Mar 2017 11H16
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Can you tell me what is the name of the tble concerned ? The items concerned are not used yet, so I can delete them without problem.

For error log, I send you the log from yesterday (see attached file)

For console message, how can I send you ? I don't have anything displayed yet. Is there a log I can send ?


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 15 Mar 2017 11H28
(@babynus)
Posts: 14952
Member Admin
 

it is "accessprofile"


 
Posted : 15 Mar 2017 11H34
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Here what I have in this table

The two last lines have an id =0 : is it the source of the problem ?

I want to delete theses two entries but I can't (I have a message on the top of the screen that deny me to do that).

Can you help me ?


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 15 Mar 2017 13H13
(@babynus)
Posts: 14952
Member Admin
 

2 items with same id : sure it is the source of issue.
If you cannot delete line through phpMyAdmin it may be because you connect with user with unsufficient privileges.
You can also try to change id of these lines, it should solve the issue.


 
Posted : 15 Mar 2017 13H22
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

ok, I create a little sql request to update the id with 14 and 15 : the problem is solved.

Thanks for your help.

Il will test now if the same problem occurs when I create a new accesseprofil (is the id=0 or not)

In wich case Projqtor give 0 for id and why two times the same id ? I did something wrong when I created a new access profile ?


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 15 Mar 2017 13H35
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hello

I did today some additional tests and the problem is still present

  • If I create a new access profile, it is created but with an id=0
  • It can also be not used, and not deleted in Projeqtor (I need to execute an SQL request (update) to give a ID to this new access profile
  • Even this new access profile has an correct ID, it can be use as choice in screen "Data Access (project dependant)" (I can select it, save the change (no error message) but if I go on a other screen and come back to screen "Data Access (project dependant), the precedent modification was not take into account !!!
  • Actually, each time I try to create a new access profile, it is created with an id=0 and it can't be use 🙁

There is no particular message in Console when I create it or save it , and no error message in log file

11:40] Paramètres sauvegardés
[11:32] Mode d'accès # inséré

Some help would be appreciate 😉 , I don't know how to do now


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 17 Mar 2017 13H52
(@babynus)
Posts: 14952
Member Admin
 

Can you check and post description for table ?
id should have extra "AUTO_INCREMENT"


 
Posted : 17 Mar 2017 19H29
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Here is the structure


Regards,
Damien
-----------------------------------------------
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2

 
Posted : 20 Mar 2017 11H42
(@babynus)
Posts: 14952
Member Admin
 

That's what I thought : id has not the "auto_increment" extra.
That's why id is set to zero.
I don't know how this could happen...
Just fix this to fix behavior.


 
Posted : 20 Mar 2017 12H07
Share:

Scroll to Top