auth.wiki : Value already in database or empty

[A3]

I updated my old server to the lastest web2pu and python3

Most things are working but I have some problems with the auth.wiki.

I can't edit my old pages. I get: Value already in database or empty

I made a new site with only the auth.wiki:  

I can create a page but cannot update it.  I get the same error.

Any ideas how to fix this?

(I have a lot of info stored in my wiki, it was very useful)

  

[Clemens]

Hi, just a quick guess — are you using another web2py instance that’s accessing the same database? If so, try renaming the database folder of the new web2py instance (to avoid deleting it), and then create a new one.

Regards

Clemens

[A3]

As I wrote before, I created a completely new site with default sqlite database.

I tried to use auth.wiki(resolve=False)   to see whats happening in the database.

actually when I try to update a record of the db.wiki_page table I get the same error on Fields Slug and Titel.

Op maandag 7 april 2025 om 18:01:57 UTC+2 schreef Clemens:

[Dave S]

On Monday, April 7, 2025 at 11:09:23 PM UTC-7 A3 wrote:

As I wrote before, I created a completely new site with default sqlite database.

I tried to use auth.wiki(resolve=False)   to see whats happening in the database.

actually when I try to update a record of the db.wiki_page table I get the same error on Fields Slug and Titel.

From the error message in the title, one of the fields of the table has a validator that is either finding the field value already in the database (I'd suspect the title, subject, or name field ).  For a table I had that I wanted to update an entry, but failed the uniqueness check (because of the entry in question, of course), I had to find a harmless modification of the field.  (It was a URL, and I add "#DUP" to the end of it.)

I'm also using sqlite3 for that db, and I don't know if other DBMs fail the uniquess check when its because of the record you're updating, but may be worth exploring that.

/dps