Comment #1 on issue 2427 by [email protected]: Wrong number of
Information Objects itens during rebuild of search index - duplicated
search results on Icaatom 1.3.0
http://code.google.com/p/qubit-toolkit/issues/detail?id=2427
I´ve found an weird thing on my information_object_i18n table...
My default culture is pt_BR.
But some lines had the field "culture" with "en".
And there were 3 lines with id duplicated... One with culture "en" and
other with culture "pt_BR".
But we didn´t mean to do that...
The lines with culture "en" had all fields null, except id and culture.
I´ve fixed it and now the rebuild task worked successfully.
Let me try to show you what I did.
First of all, I did a full backup of the database.
And I ´ve created backup tables of information_object and
information_object_i18n tables.
select id, count(*)
from information_object_i18n
group by id
having count(*) > 1;
id count(*)
496 2
8766 2
8767 2
select * from information_object_i18n
where id in (496, 8766, 8767)
order by id;
The lines with culture "en" had all fields with null value, except id and
culture...
The lines with culture "pt_BR" were ok.
The result of select:
"title","alternate_title","edition","extent_and_medium","archival_history","acquisition","scope_and_content","appraisal","accruals","arrangement","access_conditions","reproduction_conditions","physical_characteristics","finding_aids","location_of_originals","location_of_copies","related_units_of_description","institution_responsible_identifier","rules","sources","revision_history","id","culture"
"","","","","","","","","","","","","","","","","","","","","",496,"en"
"Elaboração do Projeto","","","Textual, 0,10 metros lineares","","","Contém
documentos relativos às atividades realizadas na Comissão Constitucional,
tendo em vista a elaboração, a discussão e a votação do Projeto de
Constituição, tais como: correspondências, abaixo-assinados, sugestões,
propostas, estudos técnicos, relatórios, listagens, emendas, pareceres,
destaques, requerimentos e pronunciamentos","","","","sem restrições","sem
restrições, mediante compromisso de crédito","","","","","","","","","Data
da Descrição: 13/08/2010",496,"pt_BR"
"","","","","","","","","","","","","","","","","","","","","",8766,"en"
"16ª Legislatura","","","","","","Compreende o conjunto de documentos
produzidos pelas Comissões Permanentes durante a 16ª Legislatura
(01/02/2007 - 31/01/2011). Inclui os dossiês das reuniões ordinárias,
extraordinárias, especiais e visitas realizadas pelas Comissões","","","Os
conjuntos documentais são dispostos por Comissão (arranjadas fisicamente
por ordem alfabética). Dentro de cada comissão os dossiês de cada reunião,
audiência pública ou visita estão por ordem cronológica descrescente.","Sem
restrições","Sem restrições, mediante autorização e compromisso de
crédito","","","","","","","","","Descrição: jul./2012",8766,"pt_BR"
"","","","","","","","","","","","","","","","","","","","","",8767,"en"
"6ª Legislatura","","","","","","Compreende o conjunto de documentos
produzidos pelas Comissões Permanentes durante a 6ª Legislatura (01/02/1967
a 31/01/1971). Inclui os dossiês das reuniões ordinárias, extraordinárias,
especiais e visitas realizadas pelas Comissões.","","","Os conjuntos
documentais são dispostos por Comissão (arranjadas fisicamente por ordem
alfabética). Dentro de cada comissão os dossiês de cada reunião, audiência
pública ou visita estão por ordem cronológica descrescente.","Sem
restrições","Sem restrições, mediante autorização e compromisso de
crédito","","","","","","","","","Descrição: jul./2012",8767,"pt_BR"
Then I´ve decided to create 3 new information object itens
(information_object), just temporarily.
I´ve updated the 3 lines above (information_object_i18n) that were
with "en" culture to these new temporary IDs created.
I´ve done that just to be sure that the IDs wouldn´t match to the ones that
were correct with "pt_BR" culture.
Finally I´ve deleted these 3 lines, from information_object_i18n (the
updated ones) and from information_object (the temporary ones created).
Now, the tables "information_object" and "information_object_i18n" don´t
have any lines with culture "en" anymore.
And no more weird lines with many fields with null value...
The "search:populate" task worked successfully.
And no more duplicated results during search.
Em sexta-feira, 14 de setembro de 2012 12h03min05s UTC-3,
[email protected] escreveu:
Hi, David!
I could not add the issue report on the new issue software
(https://projects.artefactual.com/projects/atom/issues).
Then I´ve added it on the old one. It is issue 2427:
http://code.google.com/p/qubit-toolkit/issues/detail?id=2427&thanks=2427&ts=1347634492
Thank you.
Regards,
Cristina.
On Thursday, September 13, 2012 9:09:44 PM UTC-3, David at Artefactual
wrote:
Hi Cristina,
The issue has not been fixed yet. I haven't seen an issue report
for
the problem either, so it would be great if you can file an
issue. We
are in the process of switching over to new issue tracking
software, so
please file the issue report at:
https://projects.artefactual.com/projects/atom/issues
Regards,
David
--
David Juhasz
Director, Technical Services
Artefactual Systems Inc.
www.artefactual.com
--
You received this message because you are subscribed to the Google Groups "Qubit
Toolkit Issues" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/qubit-issues?hl=en.
