<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2>
<DIV><FONT face=Arial size=2><SPAN class=262080911-08012007>Im a new koha
user trying to implement this software in a Public Library in Portugal. I've
imported UNIMARC records with bulkmarcimport and </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=262080911-08012007>I only get results
of my searches in the OPAC of the default theme. Any other searches in any other
theme result as 0. I have no erros in the MARC structure and when i made changes
to it i run rebuildnonmarc.pl. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=262080911-08012007>Besides this i have
imported the records with bulkmarcimport but i always get errors. First i got
these ones:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><FONT size=+0><SPAN class=262080911-08012007><FONT face=Arial><FONT
size=2>DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost'
to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm </FONT><FONT
size=2><SPAN class=262080911-08012007>l</SPAN>ine 333.</FONT> </FONT>
<P style="MARGIN-BOTTOM: 0cm"><FONT face=Arial><FONT size=2>DBD::mysql::db do
failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at
/usr/local/koha/intranet/modules/C4/Biblio.pm </FONT><FONT size=2>line
430.</FONT><BR><FONT size=2></FONT></FONT></P>
<P style="MARGIN-BOTTOM: 0cm"><SPAN style="BACKGROUND: #ffff00"><FONT face=Arial
size=2><SPAN class=262080911-08012007></SPAN></FONT></SPAN> </P>
<P style="MARGIN-BOTTOM: 0cm"><SPAN style="BACKGROUND: #ffff00"><FONT face=Arial
size=2></FONT></SPAN> </P></SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007>Now when i try to import i
got these messages:</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><SPAN class=262080911-08012007><FONT face=Arial>ERROR ==> insert into
marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values
(33146,concat(710,a),11,1,REPORT,soundex(REPORT)) </FONT>
<P style="MARGIN-BOTTOM: 0cm"><FONT face=Arial>DBD::mysql::st execute failed:
Duplicate entry '1' for key 3 at /usr/local/koha/intranet/modules/C4/Biblio.pm
line 1183.</FONT></P>
<P style="MARGIN-BOTTOM: 0cm"><FONT face=Arial>ERROR ==> insert into
marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values
(33146,concat(995,k),12,1,0148,soundex(0148))</FONT></P>
<P style="MARGIN-BOTTOM: 0cm"><FONT face=Arial>DBD::mysql::st execute failed:
Duplicate entry '1' for key 3 at /usr/local/koha/intranet/modules/C4/Biblio.pm
line 1183.</FONT></P>
<P style="MARGIN-BOTTOM: 0cm"><FONT face=Arial>ERROR ==> insert into
marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values
(33146,concat(090,9),13,1,33140,soundex(33140))</FONT></P></SPAN></DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><SPAN class=262080911-08012007><FONT face=Arial><SPAN
class=993302814-08012007>At the eng i get the message telling that the "x"
marc records have been imported. </SPAN>The records seem to be in the database
but something must be wrong.</FONT></SPAN></DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007>I'm using koha
2.2.4 Any help is welcome.</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=262080911-08012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN
class=262080911-08012007> Thanks.</SPAN></FONT></DIV></FONT></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial color=#808080 size=1><STRONG>Pedro
Maia</STRONG></FONT></DIV>
<DIV align=left><FONT face=Arial color=#808080 size=1>Centro de Informação e
Documentação</FONT></DIV>
<DIV align=left><FONT face=Arial color=#808080 size=1>Instituto de Informática
do Ministério das Finanças e da Administração Pública</FONT></DIV>
<DIV align=left><FONT face=Arial color=#808080 size=1><A
href="mailto:pedro.maia@inst-informatica.pt">pedro.maia@inst-informatica.pt</A></FONT></DIV>
<DIV align=left><FONT face=Arial color=#808080 size=1>214723295</FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial color=#808080 size=1><FONT color=#000000
size=2></FONT><A
href="http://www.inst-informatica.pt/cid"></A></FONT> </DIV>
<DIV> </DIV></BODY></HTML>