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.