[Koha-win32] marc test fails at default values

Sun Jul 29 00:19:53 CEST 2007

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
>> Koha-win32 at nongnu.org
>> 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
> Koha-win32 at nongnu.org
> http://lists.nongnu.org/mailman/listinfo/koha-win32

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-win32/attachments/20070728/f893e913/attachment-0001.htm>