SQL Error when upgrading database schema
keegean last edited by
Running Version: 8197
SVN Revision: 5726
During the install I get the following error when I try to upgrade the database schema:
SQLSTATE: Syntax error or access violation: 1061 Duplicate key name 'gmhostID’
SQL:  ALTER TABLE ‘fog’.‘groupMembers’ ADD UNIQUE KEY ‘gmhostID’ (‘gmHostID’,‘gmGroupID’) Params: 0
I pulled down the lastest from the trunk and performed an install.
This should now be fixed.
Cross linking similar threads:
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.