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…
^

19

Ola fiz a instalação, porem o plugin nao apareceu, nos log aparece isso

[critical] AddressBook: Unable to migrate schema for the plugin: AddressBook => SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable ‘sql_require_primary_key’ is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
[critical] AddressBook-master: Unable to load this plugin class: \Kanboard\Plugin\AddressBook-master\Plugin
[critical] AutomaticActionUX-master: Unable to load this plugin class: \Kanboard\Plugin\AutomaticActionUX-master\Plugin

Versão da aplicação: 1.2.20
Versão do PHP: 7.4.33
PHP SAPI: apache2handler
Cliente HTTP: cURL
Versão do sistema operacional: Linux 5.4.0-204-generic
Driver do banco de dados: mysql
Versão do banco de dados: 8.0.30

20

I don’t know from where you downloaded this plugin, but its path is obviously wrong. Please consider using the official plugin directory instead.