Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bug: SQLite Error When Deleting Contact #9

Closed
aljawaid opened this issue Jul 3, 2023 · 3 comments
Closed

Bug: SQLite Error When Deleting Contact #9

aljawaid opened this issue Jul 3, 2023 · 3 comments
Assignees
@aljawaid
Labels
bug Something isn't working help wanted Extra attention is needed
Milestone
Database Compatib...

Comments

@aljawaid
Copy link
Owner

aljawaid commented Jul 3, 2023

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"

Originally posted by @PopovIG in #6 (comment)
@aljawaid aljawaid self-assigned this Jul 3, 2023
@aljawaid aljawaid added the bug Something isn't working label Jul 3, 2023
@aljawaid aljawaid added this to the Database Compatibility milestone Jul 3, 2023
@aljawaid
Copy link
Owner Author

aljawaid commented Jul 3, 2023

#6 (comment)

@PopovIG Are you sure making the change of PRIMARY doesnt cause a problem when editig or saving contacts/properties? Because previously it created an issue for MySQL so I removed it for all database types

@PopovIG
Copy link

PopovIG commented Jul 3, 2023

I just re-tested.
Everything works correctly. At least in the project settings.
I'm not sure if this is the correct solution, but it works =)

@aljawaid
Copy link
Owner Author

aljawaid commented Jul 3, 2023

Haha I will edit the code and mark it as a solution tonight....until another error is reported lol

@aljawaid aljawaid added the help wanted Extra attention is needed label Jul 3, 2023
aljawaid added a commit that referenced this issue Jul 4, 2023
@aljawaid
FIX: SQLite Compatibility
490b4bb 
- fixes database errors, linking/delinking tasks
- #9
- #6
aljawaid added a commit that referenced this issue Jul 4, 2023
@aljawaid
FIX: Syntax Errors
0942311 
- #9
- #6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@aljawaid aljawaid

Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Milestone
Database Compatibility
Development

No branches or pull requests
2 participants
@aljawaid @PopovIG