Hi Greg,
One more thing, related to the 18 index.. It looks like you defined some
particular indexes for your instance of Invenio in the idxINDEX table.
When you migrate to 1.0, the idxPAIR and idxPHRASE tables will be only
created up to the 16th (only for the default ones in Invenio). So, in
order for your index to work, it will not be enough to run the
tabcreate.sql, but you will have to actually write a small script to
create these missing tables, using the same definition as for the idx*
tables in the tabcreate.sql (idx(PAIR|PHRASE)17*.. up to how many new
indexes you have defined).
We will also prepare a migration kit for this case (when new indexes
have been defined).
You will need this small script just for the migration phase, if you
will add a new index via the admin interface in the future, all the
tables will be automatically created.
Also, you were mentioning that the collections seemed broken - this is
because of the use of idxPHRASE* for queries starting end ending with
double quotes (usually the collection queries are like that). So running
the indexing will solve this problem.
Cheers,
Ludmila
On 03/03/2011 01:25 PM, Tibor Simko wrote:
Hi Greg:
On Thu, 03 Mar 2011, Gregory Favre wrote:
I recently migrated from my old 0.9xxx version to the brand new 1.0rc0
on a test server.
Cool! :)
OperationalError: (1017, "Can't find file:
'./infoscience/idxPAIR18R.frm' (errno: 2)")
Error 2 means `No such file or directory'. Does this table well exist
in your MySQL server table space directory? You can drop all idx*18*
table files in whatever state they are and manually re-run corresponding
CREATE TABLE snippets for all six idx*18 tables from tabcreate.sql.
Best regards
--
Ludmila Marian ** CERN Document Server **<http://cds.cern.ch/>
