Re: [Koha-win32] marc test fails at default values

[John Choo]

Hi Youssef,

You can try my marc_subfields_structure.pl file. Just a small difference
from yours. No harm. See what happens. Its located at
C:\usr\koha227\intranet\cgi-bin\koha\admin\

http://www.nabble.com/file/p11849528/marc_subfields_structure.pl
marc_subfields_structure.pl 


Alaoui Youssef wrote:
> 
> Hi, John, hi, all-
> 
> couldn't navigate the command interface.  I think my files must have  
> different names or are in different places.  the cmd prompt didn't  
> like "D" for database or recognize "dkoha."   thought it was a  
> database named "k."
> 
> so here's apache's error log.  looks like I'm missing lines of  
> script?  how wacky.  I only just started with koha and just erased  
> everything and reinstalled it clean.  or so I thought...
> 
> so koha loads with this error?
> 
> [Sat Jul 28 14:04:53 2007] [error] [client 127.0.0.1] can't opendir c: 
> \\usr\\koha228\\intranet/value_builder: No such file or directory at  
> C:/usr/koha228/intranet/cgi-bin/koha/admin/ 
> marc_subfields_structure.pl line 143., referer: http://intranet/cgi- 
> bin/koha/admin/marc_subfields_structure.pl?tagfield=952&frameworkcode=
> 
> [Sat Jul 28 14:05:53 2007] [error] [client 127.0.0.1] Premature end  
> of script headers: marc_subfields_structure.pl, referer: http:// 
> intranet/cgi-bin/koha/admin/marc_subfields_structure.pl? 
> tagfield=942&frameworkcode=
> 
> [Sat Jul 28 14:05:53 2007] [error] [client 127.0.0.1] can't opendir c: 
> \\usr\\koha228\\intranet/value_builder: No such file or directory at  
> C:/usr/koha228/intranet/cgi-bin/koha/admin/ 
> marc_subfields_structure.pl line 143., referer: http://intranet/cgi- 
> bin/koha/admin/marc_subfields_structure.pl?tagfield=942&frameworkcode=
> 
> [Sat Jul 28 14:06:48 2007] [error] [client 127.0.0.1] DBD::mysql::st  
> execute failed: called with 2 bind variables when 3 are needed at C:/ 
> usr/koha228/intranet/cgi-bin/koha/admin/marc_subfields_structure.pl  
> line 383., referer: http://intranet/cgi-bin/koha/admin/ 
> marc_subfields_structure.pl?tagfield=952&frameworkcode=
> 
> [Sat Jul 28 14:06:48 2007] [error] [client 127.0.0.1] DBD::mysql::st  
> fetchrow_hashref failed: fetch() without execute() at C:/usr/koha228/ 
> intranet/cgi-bin/koha/admin/marc_subfields_structure.pl line 384.,  
> referer: http://intranet/cgi-bin/koha/admin/ 
> marc_subfields_structure.pl?tagfield=952&frameworkcode=
> 
> 
> 
> ps here's what the apache error log looks like when I run the "check  
> marc BEFORE importing records"
> 
> [Sat Jul 28 14:07:20 2007] [error] [client 127.0.0.1] TAGF : 952 at  
> C:/usr/koha228/intranet/cgi-bin/koha/admin/checkmarc.pl line 79.,  
> referer: http://intranet/cgi-bin/koha/admin-home.pl
> 
> 
> ALSO:
> found these two files in my directory.  can anyone else find these  
> documents?  and are they meant to solve issues like ours?
> 
> c:\usr\koha228\scripts\misc\marc_datas\marc21_en\structure_def  sql file
> c:\usr\koha228\scripts\misc\sql_datas\english 
> \authorities_normal_marc21 text file
> 
> thanks!!
> Youssef Alaoui
> New College of California
> 
> On Jul 27, 2007, at 9:26 AM, John Choo wrote:
> 
>>
>> Hi Youssef,
>>
>> Not quite sure what error you are having but I'll assume that  
>> you're having
>> problems trying to load the subfields page for the MARC Structure in
>> Parameters.
>>
>> You might want to post your appropriate lines in Apache's  
>> intranet_error_log
>> when that happens.
>> You might also want to post your marc_subfield_structure table,  
>> maybe it's a
>> wrong entry in that table. For this you can type the command at dos  
>> command
>> prompt (assuming default installation of MySQL without password with
>> database name koha227):
>>
>>> mysqldump -uroot -Dkoha227 marc_subfield_structure >
>> marc_subfield_structure.sql
>>
>> You can post that resulting file marc_subfield_structure.sql for us  
>> to have
>> a go.
>> Alternatively, you can download MySQL Query Browser
>> (http://www.mysql.com/products/tools/query-browser/) and export the  
>> rows in
>> that table to Excel.
>>
>> Regards,
>> John
>>
>>
>> Alaoui Youssef wrote:
>>>
>>> hi, just loaded koha 228 on xp and am getting marc "items" tab
>>> failure.  read up on it in the user guide, but no reference as to how
>>> to change said values or even where to look.  (w32 interface is
>>> different than the linux installation)
>>>
>>> closest I've come to a solution is this nabble thread:
>>> http://www.nabble.com/MARC-check...didn't-pass-the-test-t3994897.html
>>>
>>> with a great suggestion at the end by Olugbenga Adara MCP from  
>>> Nigeria.
>>>
>>> I went to look for that screen in my brand new installation of koha
>>> and found a 500 error where the "edit subfields" control should be.
>>>
>>> am I missing a script somewhere?  here's the intranet link:
>>> http://intranet/cgi-bin/koha/admin/marc_subfields_structure.pl?
>>> op=add_form&tagfield=942&frameworkcode=
>>>
>>> so,
>>>    does koha win32 load with a marc error?
>>>
>>> I have apache 224, and Koha version:        2.2.8
>>> OS version :        Microsoft Windows XP [Version 5.1.2600]
>>> Perl version:       5.008008
>>> MySQL version:      mysql Ver 12.22 Distrib 4.0.26, for Win32
>>>
>>> Thanks so much,
>>>
>>> Youssef Alaoui
>>> Library Tech
>>> New College of California
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Koha-win32 mailing list
>>> address@hidden
>>> http://lists.nongnu.org/mailman/listinfo/koha-win32
>>>
>>>
>>
>> -- 
>> View this message in context: http://www.nabble.com/marc-test-fails- 
>> at-default-values-tf4147194.html#a11832456
>> Sent from the Koha - Win32 mailing list archive at Nabble.com.
>>
>>
>>
>> _______________________________________________
>> Koha-win32 mailing list
>> address@hidden
>> http://lists.nongnu.org/mailman/listinfo/koha-win32
> 
> 
> _______________________________________________
> Koha-win32 mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/koha-win32
> 
> 

-- 
View this message in context: 
http://www.nabble.com/marc-test-fails-at-default-values-tf4147194.html#a11849528
Sent from the Koha - Win32 mailing list archive at Nabble.com.