Download & Extend

Duplicate columns and keys during update.php

Project:Project
Version:6.x-1.0-alpha3
Component:Projects
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Issue tags:duplicate key, module installation

Issue Summary

An error occurred. http://www2.automatingbusiness.net/update.php?id=12&op=do
Fatal error: Call to undefined function _project_release_get_api_vid() in /home1/automat7/public_html/support6/sites/all/modules/project/release/project_release.install on line 520

user warning: Duplicate column name 'version_api_tid' query: ALTER TABLE project_release_nodes ADD `version_api_tid` INT unsigned DEFAULT NULL in /home1/automat7/public_html/support6/includes/database.mysql-common.inc on line 306.

user warning: Multiple primary key defined query: ALTER TABLE project_issue_comments ADD PRIMARY KEY (cid) in /home1/automat7/public_html/support6/includes/database.mysql-common.inc on line 382.

Mysql db.

Note: I might have had a project module loaded long ago - maybe 2 or 3 years.

Comments

#1

Resolved by dropping all old project_* tables in database and selection version 6.00 during update.php for force initial table creation.