Hello! Thanks x1000 for a really fabulous tool! I’ve set up a server and installed on linux via DEB, with Postgres as the backend, and I’m using Vivaldi as my default browser.
I could not reorder projects, but it turns out this is a bug related to Vivaldi & assigning colors to projects, oddly enough, per another article I found her entitled something like “Drag and drop projects in left column”. Sadly, I was not clever enough to do this search before poking around in the DB.
I looked at the “position” values in the Projects table and found that they indeed correlated to the GUI ordering, despite being large, non consecutive values where I expected “1, 2, 3, 4…”. But I swapped two values and found that they indeed affected the GUI layout.
But, when I then used Firefox to be able to drag & drop the project order, the position column now contains odd fractional values where before it was all integers.
Is this normal, or have I really “borked” the database? There’s no obvious ill effect, yet…
Thanks again for Vikunja, and thanks in advance for any advice re: my database issue.
FYI, DB table:
vikunja=# select id, title, owner_id, position from projects where owner_id =2 order by position;
id | title | owner_id | position |
---|---|---|---|
12 | Comm Planning | 2 | 589824 |
4 | 00 - Inbox | 2 | 429496729.6 |
10 | M & J | 2 | 858993459.2 |
6 | Facilities | 2 | 1288490188.8000002 |
13 | HR | 2 | 1717986918.4 |
11 | IT | 2 | 2147483648 |
15 | ML Policy | 2 | 2576980377.6000004 |
16 | Seasonal | 2 | 3006477107.2000003 |
(8 rows) |