Dear Rita,
Il Wednesday 15 October 2008 13:54:29 Rita Ricceri ha scritto:
> web361:/opt/local/cds-invenio-0.99.1 admin$ sudo make update-v0.99.0-tables
> /opt/local/cds-invenio/bin/dbexec < ./modules/miscutil/sql/tabcreate.sql
> echo "ALTER TABLE bibdoc ADD COLUMN more_info mediumblob NULL default
> NULL;" | /opt/local/cds-invenio/bin/dbexec
> ERROR 1060 (42S21) at line 1: Duplicate column name 'more_info'
> make: *** [update-v0.99.0-tables] Error 1
> web361:/opt/local/cds-invenio-0.99.1 admin$
that's quite strange given that in your previous email you reported:
| File "/opt/local/lib/python2.4/site-packages/MySQLdb/connections.py", line
35, in defaulterrorhandler
| raise errorclass, errorvalue
| _mysql_exceptions.OperationalError: (1054, "Unknown column 'more_info'
in 'field list'")
so either you've already run "make update-v0.99.0-tables".
Well just to be sure you can run it again adding the "-i" option (standing for
ignore errors):
$> make -i update-v0.99.0-tables
In this way it will complete the update of the tables until the end. Then you
should be able to run the fulltext migration kit.
Best regards,
Samuele
--
.O.
..O
OOO