New Plugin: AddressBook

Plugins
1

Introducing a way to manage contacts in Kanboard, the AddressBook plugin adds the possibility of having contacts within a project exclusive to certain tasks.

Available at a glance and in detail, contacts, or even places, can be linked to projects and tasks without having to repeat the information in the comments section.

The stable version of this plugin starts from v1.1 which will show in the Plugins Directory soon.

3 Likes
2

v1.2 has been released and addresses installation issues for SQLite and PostgreSQL backend databases.

3

Wow this looks great. I don’t have a need for a plugin like this right now because I’m the only one using my kanboard and I already know most of my contact details :smirk: But I’ll definitely keep this one in mind next time I’m in a multi-user project using kanboard.

2 Likes
4

Hello, thanks for the message and thats cool… although this plugin is not related to ‘multi-user’ situations. I think of it this way, a task has certain people non-Kanboard, like an office or company where I need to do certain things related to the task with them. This plugin lets me store their details as a contact. They are not kanboard users. Also, another way to see it, the address book could be full of a list of buildings etc.

1 Like
5

Oh, yes that makes sense. Thanks for clarifying! I’ll give it a try then I think.

1 Like
6

v1.3 has been released and should fix any final issues users are having using the plugin having SQLite as the Kanboard database backend.

7

looks great, we installed it via the plugin manager, but unfortunately it doesn’t show up under installed plugins. Our Kanboard version is 1.2.32.
Any suggestion?

8

Did you reload the page? PMGR might have some issues in that field…

9

yes, we tried on several hosts and even restarted the server. On filesystem level the plugin is present but doesn’t show up in the interface. Nor do we have any sign of the plugin elsewhere.

10

In this case, the installation failed. Please enable the log file, if not yet done.

11

We see plenty of these messages
[2023-08-03 13:53:06] [critical] AddressBook: Unable to migrate schema for the plugin: AddressBook => SQLSTATE[42703]: Undefined column: 7 ERROR: column “Name” does not exist
LINE 1: …(item, item_type, property_set, position) VALUES (“Name”, "t…

We are using postgres as DB backend

12

Hmm, I’m afraid, the schema for Postgres is not truly tested. Unfortunately, I don’t have any instance with Postgres available; thus, I’m unable to reproduce your issue.

13

Hello, thanks for reporting this. I have created an issue for it but @alfred is correct, Postgres is not fully tested.

1 Like
14

I pushed a fix to the repository, could you possibly test on your side?

1 Like
15

Hi,
the plugin now shows up, but breaks the “configure this project page” with the following error at the bottom of the page (even css styles are not loaded anymore) :
Internal Error: SQL Error[42803]: SQLSTATE[42803]: Grouping error: 7 ERROR: column “address_book_contacts_contact.item_id” must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT * FROM “address_book_contacts_contact” LEFT JOIN "ad… ^

1 Like
16

ok at least the previous error was fixed so that’s a start - thanks for confirming that.

Regarding the error above, I have created an issue here:

17

could you provide the full error please? Could you also check your server error logs.

18

[2023-08-04 11:54:29] [debug] SQL: SELECT * FROM “address_book_contacts_contact” LEFT JOIN “address_book_contacts_items” ON “address_book_contacts_items”.“id”=“address_book_contacts_contact”.“item_id” GROUP BY “contacts_id” ORDER BY address_book_contacts_items.position ASC, address_book_contacts_contact.contact_item_value ASC
[2023-08-04 11:54:29] [debug] SQL: SQLSTATE[42803]: Grouping error: 7 ERROR: column “address_book_contacts_contact.item_id” must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT * FROM “address_book_contacts_contact” LEFT JOIN "ad…
^