http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9293 Bug ID: 9293 Summary: action_logs not tracking payments Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Transaction logs Assignee: koha-bugs@lists.koha-community.org Reporter: nengard@gmail.com I have been checking the action_logs table to find payments and which user paid the fines, but I'm not seeing them at all. Below are my queries on the table. Logging is on, and it's tracking fines charged automatically and manually and it's tracking dropbox forgiving fines and writeoffs (i think). But not payments that I can see. The log should log all fines actions. mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and user != 0 limit 10; +---------------------+--------+--------+---------+-----------------------------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-----------------------------------------------------+ | 2012-09-02 11:40:50 | 146258 | | 1058715 | due=09/01/2012 23:59 amount=0.1 itemnumber=252043 | | 2012-09-02 11:41:51 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=468810 | | 2012-09-02 11:43:23 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=292689 | | 2012-09-02 11:44:48 | 146258 | | 1098788 | due=01/30/2012 23:59 amount=3.00 itemnumber=395796 | | 2012-09-02 11:45:09 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=486769 | | 2012-09-02 11:47:06 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=491656 | | 2012-09-02 11:47:12 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=526858 | | 2012-09-02 11:47:16 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=537406 | | 2012-09-02 11:47:22 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=511679 | | 2012-09-02 11:47:41 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=489449 | +---------------------+--------+--------+---------+-----------------------------------------------------+ 10 rows in set (0.00 sec) mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and action='MODIFY' and user != 0 limit 10; +---------------------+--------+--------+---------+-----------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-----------------------------------+ | 2012-09-02 11:51:09 | 146257 | MODIFY | 1149266 | Dropbox adjustment 0, item 399887 | | 2012-09-02 11:51:18 | 146257 | MODIFY | 1149266 | Dropbox adjustment 0, item 537469 | | 2012-09-02 11:51:23 | 146257 | MODIFY | 1066164 | Dropbox adjustment 0, item 4588 | | 2012-09-02 11:56:03 | 146257 | MODIFY | 1104714 | Dropbox adjustment 0, item 541027 | | 2012-09-02 11:56:12 | 146257 | MODIFY | 1104714 | Dropbox adjustment 0, item 12471 | | 2012-09-02 11:57:03 | 146257 | MODIFY | 1182366 | Dropbox adjustment 0, item 84270 | | 2012-09-02 11:58:51 | 146257 | MODIFY | 1033313 | Dropbox adjustment 0, item 331794 | | 2012-09-02 11:59:27 | 146257 | MODIFY | 1066164 | Dropbox adjustment 0, item 538578 | | 2012-09-02 12:01:12 | 146257 | MODIFY | 1149753 | Dropbox adjustment 0, item 190944 | | 2012-09-02 14:17:32 | 146254 | MODIFY | 1052342 | Dropbox adjustment 0, item 553366 | +---------------------+--------+--------+---------+-----------------------------------+ 10 rows in set (0.00 sec) Database changed mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and action='MODIFY' and user != 0 and info not like '%dropbox%' limit 10; +---------------------+--------+--------+---------+-------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-------------------------------+ | 2012-09-04 08:38:51 | 146257 | MODIFY | 1175137 | Overdue forgiven: item 384714 | | 2012-09-04 08:39:23 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 205688 | | 2012-09-04 08:40:24 | 146257 | MODIFY | 1175137 | Overdue forgiven: item 394110 | | 2012-09-04 08:40:32 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 93445 | | 2012-09-04 08:40:36 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 366920 | | 2012-09-04 08:40:41 | 146257 | MODIFY | 1164307 | Overdue forgiven: item 373410 | | 2012-09-04 09:14:13 | 146257 | MODIFY | 751038 | Overdue forgiven: item 372751 | | 2012-09-04 09:18:16 | 146272 | MODIFY | 1180787 | Overdue forgiven: item 208422 | | 2012-09-04 09:23:14 | 146272 | MODIFY | 1180787 | Overdue forgiven: item 517498 | | 2012-09-04 09:25:53 | 146272 | MODIFY | 1180787 | Overdue forgiven: item 415316 | +---------------------+--------+--------+---------+-------------------------------+ 10 rows in set (0.01 sec) mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and action='MODIFY' and user != 0 and info not like '%dropbox%' and info not like '%forgiven%' limit 10; Empty set (2.28 sec) mysql> select timestamp, user, action, object, info from action_logs where module='FINES' and user != 0 and info not like '%dropbox%' and info not like '%forgiven%' limit 10; +---------------------+--------+--------+---------+-----------------------------------------------------+ | timestamp | user | action | object | info | +---------------------+--------+--------+---------+-----------------------------------------------------+ | 2012-09-02 11:40:50 | 146258 | | 1058715 | due=09/01/2012 23:59 amount=0.1 itemnumber=252043 | | 2012-09-02 11:41:51 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=468810 | | 2012-09-02 11:43:23 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=292689 | | 2012-09-02 11:44:48 | 146258 | | 1098788 | due=01/30/2012 23:59 amount=3.00 itemnumber=395796 | | 2012-09-02 11:45:09 | 146258 | | 1034172 | due=08/24/2012 23:59 amount=0.9 itemnumber=486769 | | 2012-09-02 11:47:06 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=491656 | | 2012-09-02 11:47:12 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=526858 | | 2012-09-02 11:47:16 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=537406 | | 2012-09-02 11:47:22 | 146258 | | 1058402 | due=09/01/2012 23:59 amount=0.1 itemnumber=511679 | | 2012-09-02 11:47:41 | 146258 | | 1098788 | due=02/06/2012 23:59 amount=3.00 itemnumber=489449 | +---------------------+--------+--------+---------+-----------------------------------------------------+ 10 rows in set (0.00 sec) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.