eprints_tech messages

From: Maher Qahwash <qahwash AT kfupm.edu.sa>
Date: Sat, 21 Jun 2008 09:23:54 +0300

This is a multi-part message in MIME format.

Hi, 

When doing an upgrade (running epadmin upgrade REPOS after doing ./configure ↵
then ./install.pl) from 3.0.3 to 3.1.0-rc-2 we received many errors (tables ↵
which don't exist and can't drop primary keys), bellow are the errors:

DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE document_permission_group DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Table 'kfupmaid.document_relation_type' doesn't exist ↵
at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE document_relation_type DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.document_relation_type' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.document_relation_type' doesn't exist ↵
at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE document_relation_type ADD PRIMARY KEY(docid,pos)
SQL ERROR (do): Table 'kfupmaid.document_relation_type' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.document_relation_uri' doesn't exist ↵
a t /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE document_relation_uri DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.document_relation_uri' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.document_relation_uri' doesn't exist ↵
a t /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE document_relation_uri ADD PRIMARY KEY(docid,pos)
SQL ERROR (do): Table 'kfupmaid.document_relation_uri' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_relation_type' doesn't exist ↵
at  /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_relation_type DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_relation_type' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_relation_type' doesn't exist ↵
at  /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_relation_type ADD PRIMARY KEY(eprintid,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_relation_type' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_relation_uri' doesn't exist at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_relation_uri DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_relation_uri' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_relation_uri' doesn't exist at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_relation_uri ADD PRIMARY KEY(eprintid,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_relation_uri' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_id' doesn't exist ↵
a t /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_id DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_id' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_id' doesn't exist ↵
a t /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_id ADD PRIMARY KEY(eprintid,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_id' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_type' doesn't ↵
exist  at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_type DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_type' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_type' doesn't ↵
exist  at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_type ADD PRIMARY ↵
KEY(eprintid,pos )
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_type' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_description' ↵
doesn' t exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_description DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_description' doesn't exist ↵
(# 1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_description' ↵
doesn' t exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_description ADD PRIMARY ↵
KEY(eprin tid,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_description' doesn't exist ↵
(# 1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_timestamp' doesn't ↵
exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_timestamp DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_timestamp' doesn't exist ↵
(#11 46)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_timestamp' doesn't ↵
exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_timestamp ADD PRIMARY ↵
KEY(eprinti d,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_timestamp' doesn't exist ↵
(#11 46)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_status' doesn't ↵
exi st at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_status DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_status' doesn't exist ↵
(#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_status' doesn't ↵
exi st at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_status ADD PRIMARY ↵
KEY(eprintid,p os)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_status' doesn't exist ↵
(#1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_reported_by' ↵
doesn' t exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_reported_by DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_reported_by' doesn't exist ↵
(# 1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_reported_by' ↵
doesn' t exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_reported_by ADD PRIMARY ↵
KEY(eprin tid,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_reported_by' doesn't exist ↵
(# 1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_resolved_by' ↵
doesn' t exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_resolved_by DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_resolved_by' doesn't exist ↵
(# 1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_resolved_by' ↵
doesn' t exist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_resolved_by ADD PRIMARY ↵
KEY(eprin tid,pos)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_resolved_by' doesn't exist ↵
(# 1146)
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_comment' doesn't ↵
ex ist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_comment DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_comment' doesn't exist ↵
(#1146 )
DBD::mysql::db do failed: Table 'kfupmaid.eprint_item_issues_comment' doesn't ↵
ex ist at /var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_item_issues_comment ADD PRIMARY ↵
KEY(eprintid, pos)
SQL ERROR (do): Table 'kfupmaid.eprint_item_issues_comment' doesn't exist ↵
(#1146 )
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_creators_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_creators_id DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_corp_creators DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_subjects DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_divisions DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_editors_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_editors_id DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_related_url_url DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_related_url_type DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_funders DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_projects DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_exhibitors_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_exhibitors_id DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_producers_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_producers_id DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_conductors_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_conductors_id DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_lyricists_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_lyricists_id DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_accompaniment DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_skill_areas DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE eprint_copyright_holders DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE subject_name_name DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE subject_name_lang DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE subject_parents DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE subject_ancestors DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE user_editperms DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE user_permission_group DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Table 'kfupmaid.user_roles' doesn't exist at ↵
/var/lib/ eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE user_roles DROP PRIMARY KEY
SQL ERROR (do): Table 'kfupmaid.user_roles' doesn't exist (#1146)
DBD::mysql::db do failed: Table 'kfupmaid.user_roles' doesn't exist at ↵
/var/lib/ eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE user_roles ADD PRIMARY KEY(userid,pos)
SQL ERROR (do): Table 'kfupmaid.user_roles' doesn't exist (#1146)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE user_items_fields DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at ↵
/var/lib/eprints3/perl_lib/EPrints/Database.pm line 2979.
SQL ERROR (do): ALTER TABLE user_review_fields DROP PRIMARY KEY
SQL ERROR (do): Can't DROP 'PRIMARY'; check that column/key exists (#1091)
Added dataset import
Added dataset metafield
Added dataset cachemap
Added dataset message
Added dataset loginticket
Added importid to dataset eprint
Added source to dataset eprint
Added relation to dataset eprint
Added item_issues to dataset eprint
Added item_issues_count to dataset eprint
Added sword_depositor to dataset eprint
Added sword_slug to dataset eprint
Added roles to dataset user
Added content to dataset document
Added relation to dataset document
Added counter cachemapid
Added counter messageid
Added counter importid
Set DB compatibility flag to '3.1.0'.
Set DB compatibility flag to '3.1.1'.
3.1.1

ATTACHMENT: message.html!