Bug: Plugin Installation Failing for SQLite Database Type

[aljawaid]

• v1.1
• Sqlite

Found in debug.log:
[2023-07-03 09:56:01] [critical] AddressBook: Unable to migrate schema for the plugin: AddressBook => SQLSTATE[HY000]: General error: 1 near "AUTO_INCREMENT": syntax error

Originally posted by @PopovIG in #5 (reply in thread)

[aljawaid]

Hi @PopovIG can you make a manual edit to the schema file and test the change for me to see if it works?

[PopovIG]

I tried version 1.2 - the plugin was displayed and working in the project settings.
But there are a couple of new bugs:

1. When opening a task
   Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 ambiguous column name: contacts_id
2. When deleting a contact
   Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 foreign key mismatch - "address_book_contacts_task_has_contact" referencing "address_book_contacts_contact"

[aljawaid]

What do you mean when opening a task? After you assigned contacts to it?

[PopovIG]

No, just after clicking on the task on the board

[PopovIG]

When deleting a contact
Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 foreign key mismatch - "address_book_contacts_task_has_contact" referencing "address_book_contacts_contact"

I changed "contacts_id INTEGER KEY NOT NULL" to "contacts_id INTEGER PRIMARY KEY NOT NULL" in Sqlite.php, it fixed this problem