http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9732
Chris Cormack <ch...@bigballofwax.co.nz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Needs Signoff |Failed QA
CC| |ch...@bigballofwax.co.nz
--- Comment #2 from Chris Cormack <ch...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
