Bug 4099 - Can't add a new Patron categories
Summary: Can't add a new Patron categories
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: Main
Hardware: PC All
: P5 - low blocker (vote)
Assignee: Galen Charlton
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-02 10:30 UTC by Chris Cormack
Modified: 2019-06-27 09:24 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 01:23:09 UTC


---- Reported by thehaven104@gmail.com 2010-02-02 22:30:13 ----

On the Current Version (3.01.00.110)

The forms all load and we're able to enter in information to create a new patron category, but when we hit save --> Nothing is saved.

I will start troubleshooting - any hints are welcome.



---- Additional Comments From thehaven104@gmail.com 2010-02-03 21:30:01 ----

seems that my update missed this - 
ALTER TABLE `categories` ADD COLUMN `enrolmentperioddate` DATE NULL DEFAULT NULL AFTER `enrolmentperiod`;

after manually doing this - it worked.

will leave open until galen tells me to close it



---- Additional Comments From gmcharlt@gmail.com 2010-02-03 21:48:44 ----

Patch pushed, please test and close.  Note that this bug manifested only in a fresh install of 3.2-alpha, not one that had been tracking HEAD and applying database updates.



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:23 UTC  ---

This bug was previously known as _bug_ 4099 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4099

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was thehaven104@gmail.com.
Setting qa contact to the default for this product.
   This bug either had no qa contact or an invalid one.
CC member thehaven104@gmail.com does not have an account here

Comment 1 Hend 2011-07-11 08:03:55 UTC
I am working on version 3.2.9  but still have this problem.
I saw that the columns[enrolmentperioddate  ,enrolmentperiod] already exits with the specified properties.
I have found in koha-error_log this error :
categorie.pl: DBD::mysql::st execute failed: Incorrect date value: '' for colu
mn 'enrolmentperioddate' at row 1 at /usr/share/koha/intranet/cgi-bin/admin/cate
gorie.pl line 136.