[Bug 3887] New: Adding Authorized Values
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3887 Summary: Adding Authorized Values Product: Koha Version: HEAD Platform: PC OS/Version: Linux - Debian Status: NEW Severity: blocker Priority: P1 Component: Database AssignedTo: gmcharlt@gmail.com ReportedBy: ccurry@amphilsoc.org Estimated Hours: 0.0 Change sponsored?: --- Adding Authorized Values (/cgi-bin/koha/admin/authorised_values.pl) fails and generates the following error log @ /var/log/apache2/error.log: [Wed Dec 9 14:28:23 2009] authorised_values.pl: DBD::mysql::st execute failed: Unknown column 'lib_opac' in 'field list' at /usr/share/koha/intranet/cgi-bin/admin/authorised_values.pl line 41, <DATA> line 275. [Wed Dec 9 14:28:23 2009] authorised_values.pl: DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /usr/share/koha/intranet/cgi-bin/admin/authorised_values.pl line 42, <DATA> line 275. See IRC Chat #koha for more info: 9 Dec 2009 [Wednesday 14:42:26pm] --> [Wednesday 15:29:23pm] -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3887 Piotr Wejman <ropuch@bagno.be> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ropuch@bagno.be Priority|P1 |PATCH-Sent -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3887 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #1 from Galen Charlton <gmcharlt@gmail.com> 2010-02-10 12:49:09 --- The cause of this was fixed in commit 7cde8989f by Piotr Wejman. If the lib_opac column is still missing in your database, run the following SQL: ALTER TABLE authorised_values ADD COLUMN `lib_opac` VARCHAR(80) default NULL AFTER `lib`; Please test and close. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3887 Christopher Curry <ccurry@amphilsoc.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #2 from Christopher Curry <ccurry@amphilsoc.org> 2010-02-16 15:47:48 --- I got rid of that database long ago, because we're running stable, so I can't test, but I'll take your word for it. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠kohaorg.ec2.liblime.com