Vox Populi(x) forum

Alexandria Book Library => Supporto (Support) => Topic started by: richardh9935 on 26 September 2026, 05:36:14

Title: Abook "state" column in abbook table
Post by: richardh9935 on 26 September 2026, 05:36:14
For context, I am trying to import a hundred or so editions of my club's newsletter. This means many columns of data are exactly the same.

However, the import sets the "state" column to "-2". None of my existing books have that value, so I don't know what it means. Secondly, it makes the imported items invisible to the Abook component.

Please tell me what the "state" = -2 means, and if possible how to remedy that issue.
Title: Re: Abook "state" column in abbook table
Post by: federica on 28 September 2026, 10:02:32
state=-2 means the book is in the trash.
Which type of import did you use? (SQL or CSV)
Title: Re: Abook "state" column in abbook table
Post by: richardh9935 on 28 September 2026, 12:02:14
SQL.

I probably made a mistake.

I can run the Import again.

Thanks.