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.

[SOLVED] Issues wit...
 
Notifications
Clear all

[SOLVED] Issues with user interface after moving to docker

5 Posts
2 Users
0 Reactions
1,591 Views
Timo Hocker
(@timohocker)
Posts: 23
Active Member
Topic starter
 
[#8444]

 After moving our projeqtor instance to docker and updating from 10.0.2 to 10.0.3 we have a few issues with the user interface.
[list=1]

  • In Ticket Treatment the progress flags are displayed as number fields instead of checkboxes
  • Changing a ticket status does not update the bottom flags 
  • The settings at the top right in kanban view are not kept between sessions (show work on items is always enabled on a new session
  • The instance is running on php:8.1-apache with postgresql 14.4 as database
    I have attached the configuration files we use for building and starting the container.

    Updating to 10.0.4 did not fix my issues.


     
    Posted : 29 Aug 2022 18H32
    (@babynus)
    Posts: 14952
    Member Admin
     

     moving our projeqtor instance to docker and updating from 10.0.2 to 10.0.3

    First it is a very bas idea to have technical migration (move to docker) and functional migration at the same time : you won't know where issues come from.
    Then, your issues are DB issues, it seems you did not crrectly reimport database to docker (possibly comments on columns have not been imported)
     


     
    Posted : 30 Aug 2022 21H56
    Timo Hocker
    (@timohocker)
    Posts: 23
    Active Member
    Topic starter
     

    Thank you for the quick answer. You're right, switching multiple things at once was a bad idea, but we can't move back now since it's already in use.

    The database did transfer the comments, but I noticed that the data types are different between the current system and a new installation. Many numeric columns are using bigint or integer instead of numeric. I have created a script with the schema diff tool in pgadmin and tried it on a copy of our current system. The checkboxes have returned and are now automatically set when the status changes. I'm going to apply the script to our main system tomorrow.

    The settings in the kanban view are still not persistent, so I guess they might have an issue with write protection or file ownership. Can you tell me where they are saved?


     
    Posted : 01 Sep 2022 13H17
    (@babynus)
    Posts: 14952
    Member Admin
     

    Definition of kanbans are stored in table kanban, in jSon format in column param


     
    Posted : 02 Sep 2022 13H43
    Timo Hocker
    (@timohocker)
    Posts: 23
    Active Member
    Topic starter
     

    Changing the column types fixed most of the issues we had, now we have just one remaining.

    I looked into the database to find where the parameters for kanban are stored, specifically the 'show work on elements'.
    For my user it is stored in parameter with parametercode kanbanSeeWork8 and value null.
    When I log in the checkbox is enabled and work is shown on all elements.
    Changing the value of the checkbox correctly writes null or 1 into the database and updates the display, but it doesn't read the value on login.


     
    Posted : 02 Sep 2022 14H54
    Share:

    Scroll to Top