Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can 
[/details]
Nextcloud version (eg, 20.0.5): 27.1.6.2
Operating system and version (eg, Ubuntu 20.04): Debian Bookworm
Apache or nginx version (eg, Apache 2.4.25): Apache
PHP version (eg, 7.4): 8.2
The issue you are facing:
Error when upgrading to 28.0.2
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
- Run the updater
The output of your Nextcloud log in Admin > Logging:
Exception: Database error when running migration 28000Date20230906104802 for app core Index name "nid" for table "oc_social_3_cache_actor" collides with the constraint on table "oc_social_3_stream".
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => '',
'passwordsalt' => '',
'secret' => '',
'trusted_domains' =>
array (
0 => 'nextcloud.8bitcaffeinemonkey.ninja',
),
'filelocking.enabled' => true,
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => 'localhost',
'post' => 6379,
'timeout' => 0.0,
'password' => '',
),
'memcache.local' => '\\OC\\Memcache\\Memcached',
'memcache.distributed' => '\\OC\\Memcache\\Memcached',
'memcached_servers' =>
array (
0 =>
array (
0 => 'localhost',
1 => 11212,
),
),
'datadirectory' => '/usr/local/nextcloud/data',
'dbtype' => 'mysql',
'version' => '27.1.6.2',
'overwrite.cli.url' => 'https://nextcloud.8bitcaffeinemonkey.ninja',
'htaccess.RewriteBase' => '/',
'dbname' => 'nextcloud0',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => '',
'dbpassword' => '',
'installed' => true,
'app_install_overwrite' =>
array (
0 => 'social',
1 => 'ocsms',
),
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'tls',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => '',
'mail_domain' => '',
'mail_smtpauthtype' => 'PLAIN',
'mail_smtpauth' => 1,
'mail_smtphost' => '',
'mail_smtpport' => '587',
'mail_smtpname' => '',
'mail_smtppassword' => '',
'maintenance' => false,
'theme' => '',
'loglevel' => 0,
'updater.release.channel' => 'stable',
'default_phone_region' => 'US',
'bulkupload.enabled' => 'false',
);
