See the Mailing Lists Page for how to subscribe and unsubscribe.
eprints_tech messages
Please note: this page shows emails that have been sent to the eprints_tech mailing list. Some of these may be spam emails we have failed to filter.
Re: [EP-tech] Upgrade problem
From: Tim Brody <tdb01r AT ecs.soton.ac.uk>
Date: Mon, 23 Jun 2008 10:19:00 +0100
| Threading: | ↑ [EP-tech] Upgrade problem from qahwash AT kfupm.edu.sa • This Message |
*** http://www.eprints.org/tech.php/id/%3C485F6A84.5000707%40ecs.soton.ac.uk%3E *** EPrints community wiki - http://wiki.eprints.org/ Hi Maher, We haven't added a check for the existance of PRIMARY KEYS yet in the upgrade script. You can safely ignore these errors. All the best, Tim. Maher Qahwash wrote: > 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
[index] [prev] [next] [options] [help]