Forum

Very serious proble...
 
Notifications
Clear all

Very serious problem with plugin Screen Customisation

15 Posts
2 Users
0 Reactions
6,971 Views
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 
[#3986]

Hello

First, happy new year for all of you for this year 2017 🙂

I've got a very serious problem with plugin Screen Customisation since the ProjeQtor upgrade in v6.0.5 (wich would be corrected a previous problem withe this plugin)

When I try to display a field (which is masked for the moment), I have this message

and nothing is changed and can be saved.

What is more serious is....when I select a field to be masked and save my change, it is saved but all my settings disappear :sick:

All my settings in ScreeCustomisation, for all screen are disappear :sick: and all my users see now all the fields.

And more serious, I can't reapply theses settings, all my new settings can't be saved :blush:

I can reproduce thes problem on my "ProjeQtor" test environnment.

I think there is a big problem in the last 6.0.5 version.


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 : 05 Jan 2017 13H52
(@babynus)
Posts: 14952
Member Admin
 

Hi,

We'll investigate.

Did you clear browser cache to be sure ?


 
Posted : 05 Jan 2017 13H54
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hi Babynus,

Yes, I did it

I have done many tests, with different browser (Opera, IE and Firefox) and it is the same.


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 : 05 Jan 2017 13H58
(@babynus)
Posts: 14952
Member Admin
 

Hi,
I thing I can find a patch for saving issue when you "unmask" an item, but I'm struck with saving issue making your configuration disepearing when you add some hidden field.

First, please confirm that you try and hide some fields "for a given type".
(a print screen could help)

Then, also confirm wersions for
ProjeQtOr : V6.0.5 ?
Screen Customization plugin : V3.0 ?

Can you please provide a dump or print screen for table "extrahiddenfield" (it contains only configuration data, no confidential data) ?
Thanks in advance.


 
Posted : 07 Jan 2017 22H17
(@babynus)
Posts: 14952
Member Admin
 

Your issue raised a compatibility issue that was not checked.

It seems versions below V3 of plug-in Screen Customization is not compatible with V6.0.6.
We correcly check minimum version of ProjeQtOr for plugin compatibility, but not maximum version.
The compatibility control will be deployed in coming patch V6.0.6.
In parallel we will also deploy new patched version of plugin Screen Customisation (a fix not linked to this issue, but that will allow hiding Work Elements for Tickets or Planning Elements on Activities depending on profile).

If after migrating to V6.0.6 and plugin V3.1 you still face your issue or weird behaviors, please send us a dump of your table "extrahiddenfields". We'll help you fix its content.


 
Posted : 08 Jan 2017 13H28
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hi Babynus,

Thanks for your answers.

I confirme I'm in version 6.0.5 for ProjeqTor but in version 2.1 for plugin Screen customization (I didn't know there was a new version of the plugin 🙁 ).

I will upgrade to the news versions (ProjeqTor and Screen Customization but have some questions to be sure not to make mistakes

  • First upgrade Screen Customization plugin then ProjeqTor or the opposite ?
  • For upgrade the plugin, is it like for ProjeQtor ? simply download the new version on the plugin directory ? Or should I proceed with a new installation of the plugin ?

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 : 09 Jan 2017 11H53
(@babynus)
Posts: 14952
Member Admin
 

Hi,

So issue is what I guessed.

You can right now install V3.0 of plugin Screen Customization on V6.0.5.
It will work much better.
V3.1 of plugin will bring improved management of hiding fields that appear on a table manner (like dates and work on activity) but it is compatible.
V6.0.6 of ProjeQtOr will require V3.1 of plugin, but this will be controlled when installing V6.0.6 : plugin V3.0 or below will be disabled and message will appear during migration.

To anwser your questions, my advise is :
- install V3.0 right now on V6.0.5
- When ProjeQtOr V6.0.6 and plugin V3.1 are available : install ProjeQtOr V6.0.6 : it will disable plugin V3.0, then install plugin V3.1
To upgrade a plugin, just install new version as if is was a new plugin.

Regards.


 
Posted : 09 Jan 2017 12H28
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hello,

I have installed new plugin version (v3.0), disconnect me from my application, quit my browser (and clear cache twice)....but it is the same as before:(

I didn't retrieve my "old" parameters
I can't create news (when I save my modification, Projeqtor says me "modifications saved" but nothing appears (and I see all my fields in screen).

I attach here the dump you ask me (extrahiddenfields) : hope it's can help you.

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 : 09 Jan 2017 13H28
(@babynus)
Posts: 14952
Member Admin
 

There are duplicates in the table that has been added using old version of Screen Customization.
I'll have a look to propose you a fix


 
Posted : 09 Jan 2017 14H41
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Thanks for you help.


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 : 09 Jan 2017 16H11
(@babynus)
Posts: 14952
Member Admin
 

Here is the quey to execute :

DELETE FROM `${prefix}tempupdate` WHERE 1=1;
INSERT INTO `${prefix}tempupdate` (SELECT max(id), scope, idType, null, null, null FROM `${prefix}extrahiddenfield` 
group by scope, idType, field
having count(*) >1 or scope not like '%#%');
delete from `${prefix}extrahiddenfield` where id in (select id from `${prefix}tempupdate`);

(replace ${prefix} with your own prefix
Something like that in your case :

DELETE FROM `prjtempupdate` WHERE 1=1;
INSERT INTO `prjtempupdate` (SELECT max(id), scope, idType, null, null, null FROM prjextrahiddenfield` 
group by scope, idType, field
having count(*) >1 or scope not like '%#%');
delete from `prjextrahiddenfield` where id in (select id from `prjtempupdate`);

 
Posted : 09 Jan 2017 17H00
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Just to be sure not make mistake :

I execute this query on my Database directly ?


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 : 09 Jan 2017 17H58
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

I have executed the query on my "test environnement", in my base "ad_geodetest"

PhpMyAdmin generate an error 🙁


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 : 09 Jan 2017 18H35
(@babynus)
Posts: 14952
Member Admin
 

Try and execute each query one by one.
Older versions of phpMyAdmin don't allow several queries at once.


 
Posted : 09 Jan 2017 21H18
Damien
(@dnaton)
Posts: 248
Active Member
Topic starter
 

Hello Babynus

It works now and I retrieve all my settings 🙂

Just one thing, a character is missing in the SQL code you sent me, that's why I had an error mesage on te execution

The character ` is missing here, at the end on the code, on the name of the table prjextrahiddenfield

INSERT INTO `prjtempupdate` (SELECT MAX(id), scope, idType, NULL, NULL, NULL FROM prjextrahiddenfield`

Thanks a lot for your help


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 : 10 Jan 2017 11H12
Share:

Scroll to Top