Hi,

we try to upgrade 7.5.40 to 7.6.20 and run into trouble with the upgrade script 7.5.40 to 7.6.11:

        Adding URL column to assetHistoryDone.
        Removing 'Do Nothing On Delete workflow if not customized... Done.
        Fixing 'is public' on templatesDone.
        Adding Sort Order to Folder... Done.
        Adding login time statistics... Done.
        Adding Post Received Template ID field for CS...Done.
        Giving a user choice about which type of redirect they'd like to perform... DONE!
        Allowing badges to have multiple prices set by date.Done.
        Adding warning when editing default templates... DONE!
        Adding AdHocMailGroups to Groups.. DONE!
        Making admin console pluggable... DONE!
        Restructuring asset configuration... DONE!
        Deleting AdminBar templates... DONE!
        Repairing broken Products that were imported... DONE!
        Deleting old unused templates... Done.
        Adding binary export extensions to config file... Done.
        Adding exportMetaData and maxEntriesPerUser columns to Thingy_things table... Done.
        Adding comments asset aspect...Done.
        Adding comments aspect to wiki...Done.
        Adding asset discovery service...Done.
        Correcting the Manage Workflow link in configuration file... DONE!
        Adding a pre-text property to Thingy fields... DONE!
        Adding organization and email to address book... DONE!
        Allow content managers to change the default pagination in the search asset... DONE!
        Upgrading to YUI 2.6... DONE!
        Making the UsersOnline macro available... DONE!
        Adding the Extras field for profile fields... DONE!
        Adding Workflow to DataForm... DONE!
        Installing the DataTable asset... DONE!
        Installing the AjaxI18N content handler... DONE!
        Installing the SiteIndex content handler... DONE!
        Adding last updated field to all assets... DONE!
        Creating an additional profile field 'showOnline' for the UsersOnline macro... DONE!
        Upgrading syndicated content assets... DONE!
        Removing caseInsensitiveOS flag from config... Done.
        Adding support for versionTagMode...Finished
        Migrating surveys to new survey system...DBD::mysql::st execute failed: Duplicate entry '4XSn0vYJq-i1OZ2R7nv9MQ' for key 1 at ../lib/WebGUI/SQL/ResultSet.pm line 137.

And in the webgui.log

2009/04/28 13:43:16 - FATAL - our.server.com.conf - WebGUI::SQL::ResultSet::execute[137] - Couldn't execute prepared statement: insert into Survey_response values(?,?,?,?,?,?,?,?,?,?) : With place holders: l36N8E_rCy6hYXqSaprFhA, 4XSn0vYJq-i1OZ2R7nv9MQ, 3, , xxx.xx.xxx.xx, 1139324963, 0, 0, , {}.  Root cause: Duplicate entry '4XSn0vYJq-i1OZ2R7nv9MQ' for key 1

A quickfix for us might be to remove the survey (since it is just for test purpose) but maybe this is  interesting for you to know about.

/Erik