View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000408librarianBugpublic2023-04-24 11:582026-07-28 13:46
Reportermikee Assigned Tomikee  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
PlatformPCOSLinuxOS VersionOS
Summary0000408: insert_book_object fails when year is blank.
Description

Traceback (most recent call last):
File "/home/mikee/Projects/librarian/desktop/src/guiscan.py", line 445, in on_button_edit_clicked
last_id = db_query.insert_book_object(self.abook)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/mikee/Projects/librarian/desktop/src/db_queries.py", line 475, in insert_book_object
self.cur.execute("INSERT INTO books(title, author, isbn,abstract, \
File "/usr/lib64/python3.11/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
^^^^^^^^^^^^^^^^^^
File "/usr/lib64/python3.11/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/lib64/python3.11/site-packages/MySQLdb/connections.py", line 254, in query
_mysql.connection.query(self, query)
MySQLdb.OperationalError: (1366, "Incorrect integer value: '' for column books.books.year at row 1")

TagsNo tags attached.
Attach Tags
Git commit
GitLab/Hub Issue

Activities

git

2023-04-24 13:11

updater   ~0001429

Branch master - commit 95bff1593a462405213be046afe098207072d659
Author: Mike Evans <mikee@saxicola.co.uk>
Date: Mon Apr 24 12:13:05 2023 +0100

Bug-408

Revert to default meta provider.

src/lookup_books.py
src/version.py

Issue History

Date Modified Username Field Change
2023-04-24 11:58 mikee New Issue
2023-04-24 11:58 mikee Status new => assigned
2023-04-24 11:58 mikee Assigned To => mikee
2023-04-24 13:11 git Note Added: 0001429
2024-03-22 14:07 mikee Status assigned => feedback
2026-07-28 13:46 mikee Status feedback => closed
2026-07-28 13:46 mikee Resolution open => fixed