Good morning, I'm a new member in this list. I,ve installed koha-3.00.00 and it works perfectly. But I have a problem with diacritics. In cataloguing, when I put a character whith diacritic mark (á, é ...) or the letter ñ, I get the next error The following fatal error has occurred: Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl line 193. Apache Server version: Apache/2.2.3 Server built: Jan 15 2008 20:33:41 Koha 3.00.00.107 Koha DB 3.0000107 MySQL mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0 OS Linux sanmillan.loading.es 2.6.18-028stab057.4 #1 SMP Fri Aug 1 10:47:59 MSD 2008 x86_64 x86_64 x86_64 GNU/Linux Perl 5.008008 The mysql, according to Joshua Ferraro http://wiki.koha.org/doku.php?id=encodingscratchpad is correct: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | utf8_unicode_ci | | collation_database | utf8_unicode_ci | | collation_server | utf8_unicode_ci | +--------------------------+----------------------------+ 11 rows in set (0.00 sec) My question is: Which is the problem? Should I change the DBD::mysql configuration to enable utf-8? Thanks in advance. ---------- José Luis Rodríguez System Librarian Real Biblioteca - Patrimonio Nacional Palacio Real. C. Bailén, s.n. E28071 Madrid Tel. +34 914548700 #7582 Fax +34 914548867 http://www.realbiblioteca.es ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.f-secure.com/
My question is: Which is the problem? Should I change the DBD::mysql configuration to enable utf-8? <http://lists.koha.org/mailman/listinfo/koha-devel>
Your mysqld setup appears correct. I am curious about your desktop OS and language settings. Are you using Windows? What keyboard do you have setup? And how do you input the diacritical characters? I am experiencing differences in the the default diacritical representations between Mac OSX and WinXP. --Joe Atzberger
Joe Atzberger a écrit :
My question is: Which is the problem? Should I change the DBD::mysql configuration to enable utf-8?
Your mysqld setup appears correct. I am curious about your desktop OS and language settings.
Are you using Windows? What keyboard do you have setup? And how do you input the diacritical characters?
I am experiencing differences in the the default diacritical representations between Mac OSX and WinXP.
--Joe Atzberger ------------------------------------------------------------------------
other question can be : which marc flavour are you using ? MARC 21 ? UNIMARC ? are your utf8 encoding (8th caracter in leader for MARC21, frey50 in 100$a field for UNIMARC) marker correctly set ?
Joe Atzberger a écrit :
My question is: Which is the problem? Should I change the DBD::mysql configuration to enable utf-8?
Your mysqld setup appears correct. I am curious about your desktop OS and language settings.
Are you using Windows? What keyboard do you have setup? And how do you input the diacritical characters?
I am experiencing differences in the the default diacritical representations between Mac OSX and WinXP.
--Joe Atzberger ------------------------------------------------------------------------
other question can be : which marc flavour are you using ? MARC 21 ? UNIMARC ? are your utf8 encoding (8th caracter in leader for MARC21, frey50 in 100$a field for UNIMARC) marker correctly set ? I'm using MARC21. I tested this option. If I import Marc records with diacritics, when I make a search for any criteria I get this error: No results found You did not specify any search criteria. Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133. ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.f-secure.com/
$ uname -a Linux asymmetry.*. 2.6.26-1-686 #1 SMP Wed Sep 10 16:46:13 UTC 2008 i686 GNU/Linux (Debian - Lenny) US keyboard - I did not type the diacritics (I think the problem is with the character "ϊ" of the eu2.marc file) I uploaded, staged and imported a file with records that contain amongst other MANY titles the word "Ευρωαπαϊκή" (it means European) as a title of a book. After that, any catalog search that contains a word that was in that file gives me the error page: Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133. I undid the import but nothing happened. The BIG problem is that it contained many many widely used words like "economics" or "environment" or "statistics". So now that I search for these words I get the same error page. Could you please provide me with a work around in order to remove this staged file please? ######## Way to reproduce: ######## Download: http://costis.name/eu2.marc : this file contains various entries amongst them there is a book written by McCann, and in a later line another book that contains the string "Ευρωπαϊκ" in its title, written by "Μούσης". 1. I have a clean installation of koha and import eu2.marc 2. I search for McCann, and I get the result I should 3. I search for Μούσης and I get the error (Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133.) 4. I search for McCann, and I get the same Error!... Isn't it weird that I did not get it in step 2? How could i resolve this? ######## Unsuccessful solution: ######## In the database, I removed from the import_batches table the entries of the import_batch_id 13,14,15 (these correspond to the files that contained the entries with the diacritics and are like the eu2.marc file), but the problem persists. What else should I do ? -- View this message in context: http://www.nabble.com/Problems-with-diacritics-tp19547458p19847757.html Sent from the Koha - Dev mailing list archive at Nabble.com.
I'm seeing this same "Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133." I started seeing the error on searches after I deleted an item and biblio record added from an import. What's the best way to get searching working again? Any ideas on how I can avoid these problems in the future? We're running Koha 3.0 on Ubuntu with Marc21 records. Thanks, Eric Constantine Tsardounis wrote:
$ uname -a Linux asymmetry.*. 2.6.26-1-686 #1 SMP Wed Sep 10 16:46:13 UTC 2008 i686 GNU/Linux (Debian - Lenny) US keyboard - I did not type the diacritics (I think the problem is with the character "ϊ" of the eu2.marc file)
I uploaded, staged and imported a file with records that contain amongst other MANY titles the word "Ευρωαπαϊκή" (it means European) as a title of a book. After that, any catalog search that contains a word that was in that file gives me the error page:
Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133.
I undid the import but nothing happened.
The BIG problem is that it contained many many widely used words like "economics" or "environment" or "statistics". So now that I search for these words I get the same error page.
Could you please provide me with a work around in order to remove this staged file please?
######## Way to reproduce: ######## Download: http://costis.name/eu2.marc : this file contains various entries amongst them there is a book written by McCann, and in a later line another book that contains the string "Ευρωπαϊκ" in its title, written by "Μούσης".
1. I have a clean installation of koha and import eu2.marc 2. I search for McCann, and I get the result I should 3. I search for Μούσης and I get the error (Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133.) 4. I search for McCann, and I get the same Error!... Isn't it weird that I did not get it in step 2?
How could i resolve this?
######## Unsuccessful solution: ######## In the database, I removed from the import_batches table the entries of the import_batch_id 13,14,15 (these correspond to the files that contained the entries with the diacritics and are like the eu2.marc file), but the problem persists. What else should I do ?
-- View this message in context: http://www.nabble.com/Problems-with-diacritics-tp19547458p20623611.html Sent from the Koha - Dev mailing list archive at Nabble.com.
Constantine -- I don't seem to have any problem with the steps you enumerate. For example, in my version 3.01.00.006 system step three produces these results: http://atz.dev.kohalibrary.com/cgi-bin/koha/opac-search.pl?q=%CE%9C%CE%BF%CF... Perhaps you can update your codebase and try again? Please also mention whether you (or your browser) represents "Μούσης" with any combining characters (as opposed to their normalized unicode representations). In any case, please also verify the utf8-ness of your setup as described here: http://wiki.koha.org/doku.php?id=encodingscratchpad Thank you for providing a concrete set of steps with data so that we at least have something to test! --Joe Atzberger, LibLime On Mon, Oct 6, 2008 at 5:45 PM, Constantine Tsardounis < costas.magnuse@gmail.com> wrote:
$ uname -a Linux asymmetry.*. 2.6.26-1-686 #1 SMP Wed Sep 10 16:46:13 UTC 2008 i686 GNU/Linux (Debian - Lenny) US keyboard - I did not type the diacritics (I think the problem is with the character "ϊ" of the eu2.marc file)
I uploaded, staged and imported a file with records that contain amongst other MANY titles the word "Ευρωαπαϊκή" (it means European) as a title of a book. After that, any catalog search that contains a word that was in that file gives me the error page:
Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133.
I undid the import but nothing happened.
The BIG problem is that it contained many many widely used words like "economics" or "environment" or "statistics". So now that I search for these words I get the same error page.
Could you please provide me with a work around in order to remove this staged file please?
######## Way to reproduce: ######## Download: http://costis.name/eu2.marc : this file contains various entries amongst them there is a book written by McCann, and in a later line another book that contains the string "Ευρωπαϊκ" in its title, written by "Μούσης".
1. I have a clean installation of koha and import eu2.marc 2. I search for McCann, and I get the result I should 3. I search for Μούσης and I get the error (Error: Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2133.) 4. I search for McCann, and I get the same Error!... Isn't it weird that I did not get it in step 2?
How could i resolve this?
######## Unsuccessful solution: ######## In the database, I removed from the import_batches table the entries of the import_batch_id 13,14,15 (these correspond to the files that contained the entries with the diacritics and are like the eu2.marc file), but the problem persists. What else should I do ? -- View this message in context: http://www.nabble.com/Problems-with-diacritics-tp19547458p19847757.html Sent from the Koha - Dev mailing list archive at Nabble.com.
participants (5)
-
Constantine Tsardounis -
Eric Sigler -
Henri-Damien LAURENT -
Joe Atzberger -
Rodríguez, José L.