Thanks a lot for such a nice app, but decks are not saved to database. Probably, there is problem with PostgreSQL. Choosing participants does not work either.

Steps to reproduce

1. Open app.
2. Create board.
3. Reopen app.

Expected behaviour

The created board is present.

Actual behaviour

No boards are present.

Server configuration

Web server: nginx/1.10.3 (fpm-fcgi)

Database: pgsql PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (Alpine 6.2.1) 6.2.1 20160822, 64-bit

PHP version: 7.0.15

Nextcloud version: 11.0.1 (daily) Build:2017-01-31T21:01:21+00:00 97a4688580997d6d80ead7fa7102ffd2414b9234 - 11.0.1.2

deck version: 0.1.0

Log:

Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO "oc_deck_board_acl"("board_id","type","participant","permission_edit","permission_share","permission_manage") VALUES(?,?,?,?,?,?)' with params [3, "user", "franta", null, null, null]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "user"

Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO "oc_deck_board_acl"("board_id","type","participant","permission_edit","permission_share","permission_manage") VALUES(?,?,?,?,?,?)' with params [3, "group", "admin", null, null, null]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "group"

Error Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT id, title, owner, color, archived, 0 as shared FROM oc_deck_boards WHERE owner = ? UNION SELECT boards.id, title, owner, color, archived, 1 as shared FROM oc_deck_boards as boards JOIN oc_deck_board_acl as acl ON boards.id=acl.board_id WHERE acl.participant=? AND acl.type='user' AND boards.owner != ?' with params ["jmeno", "jmeno", "jmeno"]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "user" LINE 1: ...cl.board_id WHERE acl.participant=$2 AND acl.type='user' AND... ^

Thank you.

No need to run the js stuff on every build in the matrix

Is it possible to share the Markdown code with the Note-App?
The main feature i am missing is the live-edit mode (one edits and the text is directly formatted while typing).

Steps to reproduce

1. Create a deck
2. click on automatic assigned user (you)
3. watch screen
4. choose another app (calendar, files, whatever)
5. choose Deck again and watch screen

Expected behaviour

Related to 2: Something about your account should be visible
Related to 5: Created decks should be shown

Actual behaviour

Related to 2: Message "Error while loading stacks"

Related to 5: Already created decks are not shown, onliest choice: create new deck. Created decks are in database (_deck_boards), no other entry in deck related tables except _deck_labels (preset).

Server configuration

Operating system:
Debian
Web server:
Apache
Database:
mysql 5.5.54
PHP version:
7.0.15, memory limit 512 MB
Server version: (see your admin page)
nextcloud 11.0.1.2
Deck version: (see the apps page)
0.1.1

Updated from an older installed version or fresh install:
both
** apps installed **
files, activity, gallery,calendar, email, contacts, tasks, notes, bookmarks, deck
The content of config/config.php:

'default_language' => 'de',
'defaultapp' => 'calendar,documents,gallery,files',
'knowledgebaseenabled' => true,
'enable_avatars' => true,
'theme' => '',
'loglevel' => 4,
'trashbin_retention_obligation' => 'auto',
'app.mail.transport' => 'php-mail',
'appcodechecker' => true,
'updatechecker' => true,
'has_internet_connection' => true,
'check_for_working_webdav' => true,
'check_for_working_htaccess' => true,
'appstoreenabled' => true,
'appstore.experimental.enabled' => true,
'enable_previews' => true,
'preview_max_x' => 2048,
'preview_max_y' => 2048,
'preview_max_scale_factor' => 10,
'preview_max_filesize_image' => 50,
'logtimezone' => 'Europe/Berlin',
'updater.release.channel' => 'stable',

Are you using external storage, if yes which one: local/smb/sftp/...
no
Are you using encryption: yes/no
no, because recovery is unreliable
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no

Client configuration

Browser:
Firefox, Edge
Operating system:
Win, Linux, BSD, Android

Log file (data/nextcloud.log)

No entry since several days

cu, diri

The behavior of keyboard shortcuts/keys is IMO confusing. Pressing ctrl-s opens the page file dialog, tab jumps to the next input field. What I would expect is:

When editing a card:

• ctrl-s to save the card

When in detail view:

• tab to indent line
• shift-tab to remove indentation

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Steps to reproduce

1.Click on the three dots next to a board

Expected behaviour

It should provide the ability to archive the board instead of deleting the board.
An archived board should have the ability to be deleted.

This way there are two benefits

• Old boards can be hidden from the main view because they're archived
• It's harder to accidentally delete a board (there is no recovery option, or so it seems)

Actual behaviour

There is no option to archive a board. Instead there is an option to delete the board.
When the delete button is accidentally clicked, the complete board is gone. There doesn't seem to be a recovery option.
If you want to keep the history of boards, you can end up with a big list

Would be nice to be able to split tasks in swimlanes.
A swimlane is a horizontal categorisation of cards in the active Kanban board on a board.

There is a $15 open bounty on this issue. Add to the bounty at Bountysource.

As an option is available but not working though. It can find my NC members but when I press on a member name it's not sharing anything. NC server 11

There are a few issues with usability and rendering in mobile browsers.

Show stoppers are mainly that there is no drag & drop to move cards, so maybe there could be an alternative way to move cards between stacks via a drop-down menu of some sort?

The other thing is that you have to scroll horizontally a lot, which is not working so well especially as the left-hand menu is triggering it's slide to open feature all the time. Maybe the stacks could be automatically rearranged vertically in a mobile browser?

When one deletes a board or a card, there should be an undo operation available for 4 seconds, so if a user deletes something by accident, it can be easily restored with a single click.

Steps to reproduce

1. Click on any card within your board - the card details appear on the right side of the screen
2. Click outside of the card details (somewhere on the left of the screen)

Expected behaviour

The card details should close, like it does when clicking the X on the right-hand side

Actual behaviour

The card stays opened, requiring to click on the little X on the right side of the screen.
In order to work more fluently and faster, it should close when clicked outside of the card.

Otherwise it looks a little bit glitchy:

(i mean the gray background)

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Looks a bit strage, also some screenshots for markdown editing, labels might be nice.

Steps to reproduce

1. Use Safari for Mac OS
2. Klick on the detail menu icon
3. ....

Expected behaviour

The detail frame should be visible with its functions

Actual behaviour

Nothing is shown - only a white frame

Server configuration

Web server:

Database:
MySQL

PHP version:
7.0

Server version: (see your admin page)
11.0.1

Deck version: (see the apps page)
0.1.1

Updated from an older installed version or fresh install:
fresh

Signing status:

No errors have been found.

List of activated apps:

The content of config/config.php:

Are you kidding?
I want to let you know bugs in your software not to know all about my server ...

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no
yes

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

Client configuration

Browser:
Safari

Operating system:
Mac OS Sierra

Logs

Web server error log

Log file (data/nextcloud.log)

Browser log

Similar to the files app it should be possible for users to comment on each card.

• Check if it is possible to use the server comments app

The $120 bounty on this issue has been claimed at Bountysource.

The current start screen is just another view of the list of boards that is also present in the sidebar.

There is a $5 open bounty on this issue. Add to the bounty at Bountysource.

Steps to reproduce

1. Open Safari Web Browser
2. Go to Deck app
3. Open a Board Details

Expected behaviour

The board details should be visible (like under chrome or firefox)

Actual behaviour

The board details is not visible, the panel is blank.

Server configuration

Operating system: Ubuntu 16.04

**Web server:**Apache

Database: MySQL

**PHP version:**7

Server version: 11.0.2 (stable)

Deck version: 0.1.1

Updated from an older installed version or fresh install: Updated

Signing status:

No errors have been found.

List of activated apps:

  - activity: 2.4.1
  - admin_notifications: 1.0.0
  - announcementcenter: 3.0.0
  - apporder: 0.3.3
  - calendar: 1.5.1
  - comments: 1.1.0
  - dav: 1.1.1
  - deck: 0.1.1
  - federatedfilesharing: 1.1.1
  - federation: 1.1.1
  - files: 1.6.1
  - files_markdown: 1.0.1
  - files_pdfviewer: 1.0.1
  - files_sharing: 1.1.1
  - files_texteditor: 2.2
  - files_trashbin: 1.1.0
  - files_versions: 1.4.0
  - files_videoplayer: 1.0.0
  - firstrunwizard: 2.0
  - gallery: 16.0.0
  - logreader: 2.0.0
  - lookup_server_connector: 1.0.0
  - nextcloud_announcements: 1.0
  - notes: 2.2.0
  - notifications: 1.0.1
  - password_policy: 1.1.0
  - provisioning_api: 1.1.0
  - rainloop: 4.27.0
  - serverinfo: 1.1.1
  - sharebymail: 1.0.1
  - spreed: 1.2.0
  - survey_client: 0.1.5
  - systemtags: 1.1.3
  - tasks: 0.9.5
  - theming: 1.1.1
  - twofactor_backupcodes: 1.0.0
  - updatenotification: 1.1.1
  - workflowengine: 1.1.1

The content of config/config.php:

{
    "system": {
        "instanceid": "oc1fgv54ghl5",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "207.154.204.96",
            "focus.sh",
            "cloud.focus.sh"
        ],
        "datadirectory": "\/var\/www\/nextcloud\/data",
        "overwrite.cli.url": "http:\/\/207.154.204.96\/nextcloud",
        "dbtype": "mysql",
        "version": "11.0.2.7",
        "dbname": "cloud",
        "dbhost": "localhost",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "UTC",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "maintenance": false,
        "mail_from_address": "etienne",
        "mail_smtpmode": "php",
        "mail_domain": "focus.sh",
        "theme": "",
        "loglevel": 2
    }
}

Are you using external storage, if yes which one: No

Are you using encryption: No

Are you using an external user-backend, if yes which one:

Client configuration

Browser: Safari Version 10.0.3 (12602.4.8)

Operating system: MacOS 10.12.3 (16D32)

Logs

Web server error log

Nothing special

Log file (data/nextcloud.log)

Nothing special

Browser log

Nothing special

The css code has grown over the time and needs some cleanup.

Since SCSS is coming with Nc12 this might be helpful.

Hi there!
Awesome idea, currently i use trello.
It would be a pain to migrate by hand, however, trello offers a API.
Would it be possible to write some kind of importer?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

It is hard to see if some cards have an optional description, but you wouldn't want to miss the information in there. So maybe a small icon or shade or anything on the card could point you in the direction that extra description is available for that card?

That would save endless opening and closing cards just to see if there's more information...

... so one can write native applications that are in sync with the web interface :)

The $25 bounty on this issue has been claimed at Bountysource.

Hello

This is nice project! I like it!
I noticed today, deck details is not showing on Safari browser.

Currently each stack has a fixed width. This is a bad use of the given space.
If you have only one stack, 80% of your screen is unused while you have little space to view your cards.
If you have many stacks, you have to scroll vertical, which is an unnatural gesture and causes some layout issues (e. g. a dragged card has another position on the screen than the mouse).

Proposal: The stacks should stretch to maximum width when possible (this means, one stack: 100% width, two stacks: 50% width, ...) of course, when you have very much stacks (and "much" is depending on the screen width), each stack should have a minimum width, so they do not get too small.

Hello Devs.

I have a litte problem. When i try to share a deck with colleagues only the uuid are shown (see screenshot)

I have a setup running where users are authenticated via LDAP. When sharing files there is not such a problem. Any hints how to solve this?

My System:
Nextcloud 11.0.2
Deck current

thanks and cheers

Notifications should appear when:

• Board is shared with users
• Card is over due date
• Card is assigned to a user #11
• User is mentioned in comments #10 (part of the comments app)

For reference: https://github.com/owncloud/notifications/blob/master/docs/notification-workflow.md

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Hello,
First, thanks for you great work !

I would like to know if you plan to support markdown ? I mean like for github issue but for card details ? It would be a great improvement 😄

edit: see #53 (comment)

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Some rows/stacks might be rarely used and thus vertically collapsed or somehow hidden by default.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

This issue is about integrating deck with Nextclouds CalDAV API.

Current plan from the discussion below:

Tags, assigning users, attachments and recurrence is not supported by Tasks yet either, but it would make much sense to implement these features. And if we see that it is not really possible to implement this with pure CalDAV I would be open to implement it without syncing it via CalDAV and have it only available in the webinterface. This would still be better than not having it at all in Tasks and would not limit Deck.

1. Expose deck boards as VCALENDAR, try to map as much data from deck to the VTODO (read only access) #1545
2. Allow updating VCALENDAR entries, try to map as much as possible from vtodo to the deck database and store the rest as plain vtodo data, so we can still push it out over CalDAV (write access) #2399
3. Deck data could be moved to the DAV backend.

• Allow to assign multiple users to cards
• Show small avatar on cards

The $85 bounty on this issue has been claimed at Bountysource.

In addition to the sharing with internal users, it should be possible to share a board by generating a public link, similar to the files app. When a board is shared via link it should be possible to protect it with a password and to enable or disable write permissions for guest users.

The public share link then shows the corresponding board (without the left sidebar). Functionality that is only available with managing permissions must not be available on public shares (like the board share sidebar, the label management sidebar)

similar to https://github.com/nextcloud/server/blob/master/CONTRIBUTING.md#sign-your-work

It should be possible to have a top down view of all the stacks instead of left to right. This would be helpful for visibility if stack order is not important.

Steps to reproduce

1. share a board to a LDAP group but not the individual users.
2. open the board with the userID belonging to that group

Expected behavior

the board should open
paged search is not available for me - maybe the error results in this one?

Actual behavior

Error message: Error occurred, fetching boards failed.
Console states: GET http://domain.org/nextcloud/index.php/apps/deck/boards/1 403 (Forbidden)

Server configuration

Operating system:
Debian, lenny

Web server:
Apache 2.4
Database:
MySQL
PHP version:
7.0
Server version: (see your admin page)
11.01 and 11.02
Deck version: (see the apps page)
0.1.1 and compiled master of version of Feb 13

Updated from an older installed version or fresh install:
tried both

Signing status:

Login as admin user into your cloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your instance's installation folder

The content of config/config.php:

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your instance's installation folder

or 

Insert your config.php content here
(Without the database password, passwordsalt and secret)

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP

Client configuration

Browser:
Chrome, Iridium

Operating system:
OSX

Logs

Web server error log

[Mon Feb 13 16:12:05.865273 2017] [:error] [pid 9906] [client 192.168.178.45:60670] PHP Fatal error:  Uncaught Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:60\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\\DBAL\\Connection->detectDatabasePlatform()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): Doctrine\\DBAL\\Connection->getDatabasePlatform()\n#4 /var/www/nextcloud/lib/private/DB/Connection.php(147): Doctrine\\DBAL\\Connection->setTransactionIsolation(2)\n#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\\DB\\Connection->__construct(Array, Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Obj in /var/www/nextcloud/lib/private/DB/Connection.php on line 60
[Mon Feb 13 16:12:05.881276 2017] [:error] [pid 9862] [client 192.168.178.45:60938] PHP Fatal error:  Uncaught Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:60\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\\DBAL\\Connection->detectDatabasePlatform()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): Doctrine\\DBAL\\Connection->getDatabasePlatform()\n#4 /var/www/nextcloud/lib/private/DB/Connection.php(147): Doctrine\\DBAL\\Connection->setTransactionIsolation(2)\n#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\\DB\\Connection->__construct(Array, Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Obj in /var/www/nextcloud/lib/private/DB/Connection.php on line 60
[Mon Feb 13 16:12:05.881276 2017] [:error] [pid 9862] [client 192.168.178.45:60938] PHP Fatal error:  Uncaught Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:60\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\\DBAL\\Connection->detectDatabasePlatform()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(621): Doctrine\\DBAL\\Connection->getDatabasePlatform()\n#4 /var/www/nextcloud/lib/private/DB/Connection.php(147): Doctrine\\DBAL\\Connection->setTransactionIsolation(2)\n#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\\DB\\Connection->__construct(Array, Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Obj in /var/www/nextcloud/lib/private/DB/Connection.php on line 60
[Mon Feb 13 16:12:08.461698 2017] [mpm_prefork:notice] [pid 611] AH00169: caught SIGTERM, shutting down
[Mon Feb 13 16:12:36.219052 2017] [mpm_prefork:notice] [pid 562] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2k configured -- resuming normal operations
[Mon Feb 13 16:12:36.239053 2017] [core:notice] [pid 562] AH00094: Command line: '/usr/sbin/apache2'
Insert your webserver log here

Log file (data/nextcloud.log)

"Ready for a paged search","level":0,"time":"2017-02-13T18:12:15+00:00","method":"GET","url":"\/nextcloud\/index.php\/apps\/deck\/boards\/1","user":"some.body","version":"11.0.2.0"}
{"reqId":"yMmSWYb3f7+X0PpX4u88","remoteAddr":"192.168.178.45","app":"user_ldap","message":"initializing paged search for  Filter (&(objectclass=groupOfNames)(&(businessCategory=cloud))) base Array\n(\n    [0] => cn=some correct Ldap CN\n)\n attr Array\n(\n    [0] => cn\n)\
n limit 500 offset 0","level":0,"time":"2017-02-13T18:12:15+00:00","method":"GET","url":"\/nextcloud\/index.php\/apps\/deck\/boards\/1","user":"some.body","version":"11.0.2.0"}

Awesome addition to nextcloud!

Wouldn´t it be nice to have it integrated in the tasks app? To have boards integrate with lists?

Concept for integrating with other apps #15

Attachments of different types (File, Calendar entry, ...) can be added to cards.

It should be possible to change the order of the stacks by dragging them around.

When hovering over the colored label on cards it should show a tooltip with the name of the label.

When adding a new board the first color should be selected by default.

similar to
https://github.com/nextcloud/server/blob/master/issue_template.md

Adding Kanban with tasks integrated in Nextcloud is great!

But there are already more functional open-source products like Wekan
Why not to intergate with them instead of re-developping everything?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

IMO important enhancements
allow moving cards in stack and between stacks
allow moving stacks
allow sub stacks

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Reported by @ferdiga in #36