Communities lost (deleted) after upgrade 5.1.1 to 6.0.6.

• Type: Bug
• Status: Closed
• Resolution: Duplicate
• Affects Version/s: 6.0.6 GA
• Fix Version/s: None
• Component/s: Core Infrastructure, ~ [Archived] Sites Management
• Labels:
  • 6.0.6
• Environment: Linux/Unix. Oracle 10.x. Java 1.5; Upgrade Liferay Portal Community Edition 5.1.1 to Liferay Portal Community Edition 6.0.6

http://www.liferay.com/community/forums/-/message_boards/message/10435787

Update LF 5.1.1 to 6.0.6.
In LF 5.1.1, communities have the fields "CLASSNAMEID = 0" and "CLASSPK = 0" in table "GROUP_"

Automatic upgrade check duplicate records (UpgradeDuplicates.java) comparing the values ​​of CLASSNAMEID and CLASSPK and not check the primary key (GROUPID).
All communities have these two fields the same value (0), so delete all communities.

duplicate = true;
....
if (! columnValue.equals (previousColumnValue)) {
duplicate = false;
}

...
if (duplicate) {
RunSQL (
"delete from" + tableName + "where" +
primaryKeyName + "=" + primaryKeyValue);