Kovah / LinkAce

LinkAce is a self-hosted archive to collect links of your favorite websites.
https://www.linkace.org
GNU General Public License v3.0
2.56k stars 160 forks source link

v2: NOT NULL constraint failed: links.visibility #843

Open Kovah opened 1 week ago

Kovah commented 1 week ago

From CLI:

In Connection.php line 829:

  SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: links.visibility (Connection: sqlite, SQL: insert into "links" ("user_id", "url", "title", "description", "icon", "visibilit
  y", "created_at", "updated_at") values (1, https://support.mozilla.org/products/firefox, Get Help, ?, link, ?, 2022-07-04 11:42:17, 2024-09-08 08:27:16))

and

In Connection.php line 587:

  SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: links.visibility

This same html file imports successfully in Linkace V1 Docker with MySQL. I believe it is the first link in the file. I will test with another backend on Beta 2 later.

Originally posted by @vfrex in https://github.com/Kovah/LinkAce/issues/836#issuecomment-2336636042

Kovah commented 1 week ago

@vfrex Could you share a file which causes this error? Couldn't find any obvious problem with the import process.

vfrex commented 1 week ago

Sure, just need to strip it down a bit when I have a few minutes later this week.