Re: [Koha] OPAC User Can Not Login to Koha

Hi Chris, On Wed, Jun 6, 2012 at 3:56 PM, Chris Cormack wrote: > On 6 June 2012 20:54, Andi Sugandi wrote: > What user are you trying to login as? kohaadmin user. > You can not login to the opac as the kohaadmin user, you will need to > make a real user in the staff interface first. afaik, k

Re: [Koha] Help with sql statement.

This should work: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <> AND <> and b.code = <> GROUP BY c.code ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listi

Re: [Koha] Unable to update form

Hi Stew, Il 10/06/2012 13:03, Stew Wilson ha scritto: > I tried editing my own MARC framework. This worked well, until I > accidentally deleted a tag that I wanted to keep. which tag do you deleted ? Bye Zeno Tajoli -- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CI

Re: [Koha] OPAC User Can Not Login to Koha

Hi Mason, On Mon, Jun 11, 2012 at 5:44 PM, Mason James wrote: > load a dump from your working local Koha, into your borked VDS Koha... > > does it work? Unfortunately no, it doesn't. The issue still remains: http://goo.gl/AEo13 (screenshot) "... Software error: Can't use an undefined value a

Re: [Koha] Help with sql statement.

Hi Jared, Thanks for responding on a weekend :). I changed the statement to: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <> AND DATE(dateenrolled) <> and b.code<> GROUP BY c.code but its still not producing any data, I am thinking that I am missing somet

Re: [Koha] Help with sql statement.

This should work: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <> AND <> and b.code = <> GROUP BY c.code On Sat, Jun 9, 2012 at 7:55 PM, Jared Camins-Esakov wrote: > James, > > > I am trying to get the new patron report developed by Sharon Moreland, to >>

Re: [Koha] Help with sql statement.

At 05:35 PM 6/9/2012 -0700, James Ghiorzi wrote: Hi Jared, Thanks for responding on a weekend :). I changed the statement to: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <(-mm-dd)>> AND DATE(dateenrolled) <> and b.code> GROUP BY c.