[Koha-bugs] [Bug 10635] New: can't query for create in action_logs

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

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

            Bug ID: 10635
           Summary: can't query for create in action_logs
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Reports
          Assignee: gmcharlt at gmail.com
          Reporter: nengard at gmail.com
        QA Contact: testopia at bugs.koha-community.org

Created attachment 19888
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=19888&action=edit
error

I wrote this report:

SELECT p.cardnumber, p.surname, p.firstname, p.streetnumber, p.address,
p.address2, p.city, p.state, p.zipcode, p.email, p.phone, p.dateenrolled,
p.smsalertnumber, l.action, l.timestamp as 'action taken'
FROM borrowers p
left join action_logs l on (p.borrowernumber=l.object)
where l.module='MEMBERS' and date(l.timestamp) between date_sub(curdate(),
interval 1 week) and curdate() and l.action in ('MODIFY','CREATE')

And get the attached error which says I can't use the word 'CREATE' but that's
the word in the table ... so maybe we need to remove this restriction or change
the wording in the table so that it can be queried.

-- 
You are receiving this mail because:
You are watching all bug changes.