[Koha] changed the database fron mySQL server but not reflecting in the search result of OPAC

[Manos PETRIDIS]

When you write that you've updated the db by hand do you refer to just the text columns populated by the import procedure, or did you also update the XML blob containing the "original" bibliographing information? It would be quite an undertaking if you performed the latter, and the code may prove useful enough for all. I understand though that searches are performed on indexes created by zebra, based on the information contained on the XML column, rather than the few discrete title/author/ISBN/etc. columns. Therefore, if you only updated those the data would appear OK in the interface but not when performing searches. 


Sent from my iPhone

On 25 Φεβ 2014, at 3:35 μ.μ., Babu_koha <trinadh.gi at gmail.com> wrote:

> Hi,
> 
> Our data has a "," in the data due to that, 
> 
> double quotes has come at the time of data conversion.
> 
> if we search any string/data result is fine, 
> 
> after that if we click author name with double quotes,
> 
> *No results found!* is coming.
> 
> if we click author name *with out double quotes result is fine*.
> 
> *Actually i deleted the double quotes from the databese by 
> 
> connecting to mysql server from terminal.*
> 
> then also the old data is reflecting, if i search.
> 
> my zebra server is in running state.
> 
> on one of my friend's suggestions i used the following commands:
> 
> cd /usr/share/koha/bin/migration_tools
> ./rebuild_zebra.pl -a -v -b -x -z -run-as-root
> 
> then i got
> 
> root at dorlib:/usr/share/koha/bin/migration_tools# ./rebuild_zebra.pl -a -v -b
> -x -z -run-as-rootclear
> Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl
> /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5
> /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14
> /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6.
> BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6.
> 
> i am attaching the screen shots..
> 
> ANY HELP......
> 
> <http://koha.1045719.n5.nabble.com/file/n5788657/1.jpg> 
> <http://koha.1045719.n5.nabble.com/file/n5788657/2.jpg> 
> 
> 
> 
> --
> View this message in context: http://koha.1045719.n5.nabble.com/changed-the-database-fron-mySQL-server-but-not-reflecting-in-the-search-result-of-OPAC-tp5788657.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha