SQL Error when upgrading database schema

[keegean]

Running Version: 8197
SVN Revision: 5726

During the install I get the following error when I try to upgrade the database schema:

SQLSTATE[4200]: Syntax error or access violation: 1061 Duplicate key name ‘gmhostID’
SQL: [83] ALTER TABLE ‘fog’.‘groupMembers’ ADD UNIQUE KEY ‘gmhostID’ (‘gmHostID’,‘gmGroupID’) Params: 0

I pulled down the lastest from the trunk and performed an install.

[Tom Elliott]

Updated the code base so this particular alter statement is no longer available. This should allow your system to work past this point as I recreate the table shortly afterword, twice even.

[Wayne Workman]

Cross linking similar threads:

https://forums.fogproject.org/topic/7855/sql-error-when-upgrading-database-schema

https://forums.fogproject.org/topic/7876/installation-error-fresh-install-with-current-git-trunk-version

https://forums.fogproject.org/topic/7873/sql-error-after-updating-to-trunk-at-login

https://forums.fogproject.org/topic/7870/chromium-os-woes/9

https://forums.fogproject.org/topic/7862/nfs-mount-fails-network-unreachable/16

[Tom Elliott]

This should now be fixed.