Hi, Samuele
Thank you very much for help,
It worked.
And found something else ... on indexing
This exception occurred during indexing.
Exception caught: (1267, "Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
'='")
I went through removing old idx* tables and importing new one from
"tabcreate.sql" but also same error persists,
Since i removed all the index names i created new ones from bibindexadmin so
i found that these errors are only occurring on those index whose
*Stemming Language are* set to english. there is no error on index whose
language is set to None.
I think that may be due to table collation "latin1_swedish_ci" which was
automatically created by the tabcreate.sql which i used to create
those idx* tables. My database is set to "utf8_general_ci" and all the older
tables from v0.99.3 are also on "utf8_general_ci"
I am going to try converting latin1_swedish_ci to utf8_general_ci manually,
Thought i should inform you if that was some kind of bug or something.
Thank you again,
Diwaker Ghimire
Kathmandu, Nepal
On Wed, Jun 8, 2011 at 6:27 PM, Samuele Kaplun <samuele.kap...@cern.ch>wrote:
> Dear Diwaker,
>
> Il giorno mer, 08/06/2011 alle 10.21 +0545, Diwaker Ghimire ha scritto:
> > 1. Donot yet create tables, import old db, and run make
> > update-v0.99.3-tables
> > during this step an error occurred on renaming table to
> > oaiREPOSITORY citing it already existed so i renamed it to
> > same table it was trying to rename from and rerun this step,
> > there was an error on INSERT operation on nonexistence table
> > [i just skipped this step from this position, there was no
> > such table on db with previous version and this script didn't
> > bother to create one so i thought that was not necesary.]
>
> Upon every upgrade of Invenio, completely new tables are created by the
> command:
> [...]
> ${prefix}/bin/dbexec < $(top_srcdir)/modules/miscutil/sql/tabcreate.sql
> [...]
>
> In the case of the script "update-v0.99.3-tables", this is triggered
> only after a successful renaming of oaiARCHIVE to oaiREPOSITORY. Since
> in your case this failed because oaiREPOSITORY was already existing
> (since it existed since v0.99.2 and you probably tried also that minor
> release of Invenio), the whole execution of "update-v0.99.3-tables"
> failed. Indeed we should fix this so that oaiARCHIVE is renamed only
> once.
>
> Note that the INSERT statement that was probably failing is the
> "INSERT INTO knwKB...", which is referring to a table that would be
> created by the above mentioned execution of tabcreate.sql.
>
> To actually recover I would suggest you to just run:
>
> $ make -i update-v0.99.3-tables
>
> This would actually skip any failing update statement (but would
> correctly run the missing one).
> Given your description it should simply give an error again for the
> renaming of oaiARCHIVE to oaiREPOSITORY, but succeed in everything else.
>
>
> > I Patched from: webinterface_handler_wsgi_utils.py line :
> > 368
> >
> http://invenio-software.org/attachment/ticket/451/0001-WebStyle-fix-StringField-definition.patch
>
> Great!
>
> > After patching above error was solved, yet there is another
> > one,
> >
> > [Tue Jun 07 09:40:34 2011] [error] Exception KeyError:
> > KeyError(-1216509296,) in <module 'threading' from
> > '/usr/lib/python2.6/threading.pyc'> ignored
>
> Is there more traceback available (in particular
> in /opt/invenio/var/log/invenio.err)?
>
> > 1. Found these error on invenio.err while trying to browse site
> > Browser shows server encounter an error,
> >
> > The server encountered an error while dealing with your
> > request. ...
> >
> > The following problem occurred on <http://invenio.local>
> > (Invenio 1.0.0-rc0)
> > >> 2011-06-07 13:39:01 -> InvenioWebAccessFireroleError: too
> > many values to unpack
> > >>> User details
>
> Yes, this is due to the very first problem you encountered, i.e. the
> fact that the update failed. If you see, the last statement of the
> "update-v0.99.3-tables" script is:
>
> [...]
> echo -e 'from invenio.access_control_firerole import
> repair_role_definitions;\
> repair_role_definitions()' | $(PYTHON)
> [...]
>
> which would precisely upgrade the Firerole structures in the DB. This
> issue will go away if you run the above mentioned "make -i
> update-v0.99.3-tables" command.
>
> > Did I missed something, or i did something wrong please help
>
> Hope this solves all your issues.
>
> Cheers,
> Samuele
>
> --
> Samuele Kaplun
> Invenio Developer ** <http://invenio-software.org/>
>
>
