[Bug 9732] New: timestamp not updated when modifying biblio
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732 Bug ID: 9732 Summary: timestamp not updated when modifying biblio Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: gmcharlt@gmail.com Reporter: fridolyn.somers@biblibre.com CC: m.de.rooy@rijksmuseum.nl When modifying a biblio, biblio.timestamp and biblioitems.timestamp are not updated. Isn't it the main purpose of those fields ? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732 Fridolyn SOMERS <fridolyn.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=7146 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732 Fridolyn SOMERS <fridolyn.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Assignee|gmcharlt@gmail.com |fridolyn.somers@biblibre.co | |m --- Comment #1 from Fridolyn SOMERS <fridolyn.somers@biblibre.com> --- Created attachment 15774 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15774&action=edit Proposed patch See commit comment -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA CC| |chris@bigballofwax.co.nz --- Comment #2 from Chris Cormack <chris@bigballofwax.co.nz> --- This shouldn't be needed Can you check your database structure, it should be `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, Which means MySQL will update it, can you do show create table biblio; select biblionumber,title,timestamp from biblio; +--------------+---------+---------------------+ | biblionumber | title | timestamp | +--------------+---------+---------------------+ | 1 | chris | 2012-07-01 16:21:13 | | 2 | chris 2 | 2012-06-11 23:14:39 | +--------------+---------+---------------------+ update biblio set title='test timestamp' where biblionumber=1; Query OK, 1 row affected (0.05 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select biblionumber,title,timestamp from biblio; +--------------+----------------+---------------------+ | biblionumber | title | timestamp | +--------------+----------------+---------------------+ | 1 | test timestamp | 2013-03-01 22:59:09 | | 2 | chris 2 | 2012-06-11 23:14:39 | +--------------+----------------+---------------------+ 2 rows in set (0.00 sec) -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732 Fridolyn SOMERS <fridolyn.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |RESOLVED Resolution|--- |INVALID --- Comment #3 from Fridolyn SOMERS <fridolyn.somers@biblibre.com> --- Your right Chris, I did not knew this behavior. On a biblio edition : biblioitems.timestamp is always updated (because marcxml and marc are updated), but biblio.timestamp is updated only if a concerned column is updated (title, author, ...). Closed. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org