On 14 April 2010 09:04, Shane Skeens <shane@indigospin.com> wrote:

unfortunately, no.  it's a hosted installation through LibLime.  no access to db or SSH.

Ahh, that's a real shame. You should press them for access to your data. In the meantime though, I suspect that the value for that preference is not a 1 or 0, but is something like Yes instead, which is causing that error, you will need to fix it in the db. So maybe someone at PTFS can fix that for you. Chris

I've followed up on this with the helpdesk. Many of us are out at conferences this week, but we should be able to get someone to fix it at the database level. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner@ptfs.com -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Shane Skeens Sent: Tuesday, April 13, 2010 5:17 PM To: Chris Cormack Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] [SPAM] Re: [SPAM] Re: Has anyone seen this before? thank you, Chris. you are correct, as the values available for that preference are "yes" or "no". how the db gets hung as the result of a change from one to the other is beyond me, but this isn't the first time we've had db problems with the LibLime installation. i've emailed support@LibLime.com as well, so hopefully as you say, someone over there will help us out. PTFS did talk about offering better support for LibLime after the acquisition, so i hope that's going to be the case. Thank You for your help! -ss shane skeens ceo, senior strategist indigospin : media+marketing 806.438.3021 www.indigospin.com ----- Original Message ----- From: "Chris Cormack" <chris@bigballofwax.co.nz> To: "Shane Skeens" <shane@indigospin.com> Cc: <koha@lists.katipo.co.nz> Sent: Tuesday, April 13, 2010 4:07 PM Subject: [SPAM] Re: [SPAM] Re: [Koha] Has anyone seen this before? On 14 April 2010 09:04, Shane Skeens <shane@indigospin.com> wrote:

unfortunately, no. it's a hosted installation through LibLime. no access to db or SSH.

Ahh, that's a real shame. You should press them for access to your data. In the meantime though, I suspect that the value for that preference is not a 1 or 0, but is something like Yes instead, which is causing that error, you will need to fix it in the db. So maybe someone at PTFS can fix that for you. Chris _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Wow! i concur with Chris completly! Thank You for the support! it would also be helpful if we knew how to keep this from hapening again. -ss shane skeens ceo, senior strategist indigospin : media+marketing 806.438.3021 www.indigospin.com ----- Original Message ----- From: "Chris Cormack" <chris@bigballofwax.co.nz> To: "Jane Wagner" <jwagner@ptfs.com> Cc: "Shane Skeens" <shane@indigospin.com>; <koha@lists.katipo.co.nz> Sent: Tuesday, April 13, 2010 5:23 PM Subject: [SPAM] Re: [Koha] [SPAM] Re: [SPAM] Re: Has anyone seen this before? On 14 April 2010 10:20, Jane Wagner <jwagner@ptfs.com> wrote:

I've followed up on this with the helpdesk. Many of us are out at conferences this week, but we should be able to get someone to fix it at the database level.

Excellent :) Committing to fix it, and using the public mailing lists, thats already 50 points ahead of the previous support provider Chris

thanks, Chris. wouldn't surprise me. unfortunately, LibLime has been running several stable versions behind everyone else. There are numerous bugs that have fixes which can't be employed due to the "closed" nature of their hosted system. LibLime doesn't even offer a per-incident support option, just a $10,500 annual support subscription. i have high hopes that the new management will step up their product support (& upgrade schedule!). if they don't, i don't see a future for LibLime; i couldn't recommend them based upon our experiance thus far. -ss shane skeens ceo, senior strategist indigospin : media+marketing 806.438.3021 www.indigospin.com ----- Original Message ----- From: "Chris Cormack" <chris@bigballofwax.co.nz> To: "Shane Skeens" <shane@indigospin.com> Cc: "Jane Wagner" <jwagner@ptfs.com>; <koha@lists.katipo.co.nz> Sent: Tuesday, April 13, 2010 7:23 PM Subject: [SPAM] Re: [SPAM] Re: [Koha] [SPAM] Re: [SPAM] Re: Has anyone seen this before? On 14 April 2010 10:42, Shane Skeens <shane@indigospin.com> wrote:

Wow! i concur with Chris completly! Thank You for the support! it would also be helpful if we knew how to keep this from hapening again. -ss

I think there is a bug in your version of Koha. I will test in 3.0.5 (the latest stable release) and see if it still exists there. Chris