[Koha-bugs] [Bug 9732] timestamp not updated when modifying biblio

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732

Chris Cormack <chris at bigballofwax.co.nz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA
                 CC|                            |chris at bigballofwax.co.nz

--- Comment #2 from Chris Cormack <chris at 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.