When I run update 0.92.1 I get various errors , like: zet10:/usr/local/src/cds-invenio-0.99.1# make update-v0.92.1-tables echo "DROP TABLE rnkCITATIONDATA;" | /opt/cds-invenio/bin/dbexec /opt/cds-invenio/bin/dbexec < ./modules/miscutil/sql/tabcreate.sql echo "UPDATE bibdoc SET status='DELETED' WHERE status='1';" | /opt/cds-invenio/b in/dbexec echo "UPDATE bibdoc SET status='' WHERE status='0';" | /opt/cds-invenio/bin/dbex ec echo "ALTER TABLE bibrec ADD KEY creation_date (creation_date);" | /opt/cds-inve nio/bin/dbexec ERROR 1061 (42000) at line 1: Duplicate key name 'creation_date' make: *** [update-v0.92.1-tables] Error 1
and when I try to update 0.99.0 I get: /opt/cds-invenio/bin/dbexec < ./modules/miscutil/sql/tabcreate.sql echo "ALTER TABLE bibdoc ADD COLUMN more_info mediumblob NULL default NULL;" | / opt/cds-invenio/bin/dbexec echo "ALTER TABLE schTASK ADD COLUMN priority tinyint(4) NOT NULL default 0;" | /opt/cds-invenio/bin/dbexec echo "ALTER TABLE schTASK ADD KEY priority (priority);" | /opt/cds-invenio/bin/d bexec echo "ALTER TABLE rnkCITATIONDATA DROP PRIMARY KEY;" | /opt/cds-invenio/bin/dbex ec ERROR 1075 (42000) at line 1: Incorrect table definition; there can be only one auto column and it must be defined as a key make: *** [update-v0.99.0-tables] Error 1 Best regards, Zbigniew 2008/9/25 Samuele Kaplun <[email protected]> > Dear Zbigniew, > > Il Thursday 25 September 2008 19:09:21 Zbigniew Leonowicz ha scritto: > > After many difficulties with reloading of the database and changing to > utf8 > > I encountered a problem I cannot solve: > > > > probably the make update-v0.92.1-tables > > > > does not work well and the next steps with the upgrade mostly fail with > > such result: > > > > File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35, in > > defaulte > > rrorhandler > > _mysql_exceptions.OperationalError: (1054, "Unknown column 'priority' in > > 'field > > list'") > > > > > > Or maybe there is another way to upgrade without the need of manual > reload > > of all data ? > > you're just missing a table update instruction. > > Since you are migrating from 0.92.1 to 0.99.1 you have to run all the > intermediate make update steps: > $> make update-v0.92.1-tables > $> make update-v0.99.0-tables > > You can also take a look to the Invenio wiki: > <https://twiki.cern.ch/twiki/bin/view/CDS/InvenioUpgrade> > > Best regards, > Samuele > > -- > .O. > ..O > OOO > >
