Internal Server Error after new server setup

Nextcloud version (eg, 18.0.2): 15.0.14.1
Operating system and version (eg, Ubuntu 20.04): TinkerOS 2.0.11 (based on Debian 9)
Apache or nginx version (eg, Apache 2.4.25): 2.4.25
PHP version (eg, 7.1): 7.0.33-0+deb9u7

The issue you are facing:

I had a running nextcloud installation on my Asus Tinker board but after a power breakdown issue causing an ungraceful shutdown I had frequent system crashes of the Tinker OS. So I decided to setup the server from scratch again. The mysql database tabels and the html / php docs I got from a backup.

After I did this I only get

'Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.’

I have switched on error reporting in the php configuration but I do not see any additional information neither on the server output nor in any logs (systemlog, apache log etc.) I have currently no idea how to fix this problem.

Is this the first time you’ve seen this error? (Y/N): Y

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'xxxxxxxxxxx',
  'passwordsalt' => 'xxxxxxxxxxxxxxxxxxxxxxxxxx',
  'secret' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',
  'trusted_domains' => 
  array (
    0 => 'xxxxxx.dyndns.org',
  ),
  'datadirectory' => '/www/nextcloud_data',
  'dbtype' => 'mysql',
  'version' => '15.0.14.1',
  'overwrite.cli.url' => 'http://xxxxxx.dyndns.org/nextcloud',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextclouduser',
  'dbpassword' => 'xxxxxxxxxxxxxxxxxxx',
  'installed' => true,
  'mail_from_address' => 'nextcloud',
  'mail_smtpmode' => 'smtp',
  'mail_domain' => 'xxxxxxxxxxxxxxxx',
  'mail_smtphost' => 'xxxxxxxxxxxxxx',
  'mail_smtpauth' => 1,
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpsecure' => 'ssl',
  'mail_smtpname' => 'xxxxxxxxxxxxxxxxxxxx',
  'mail_smtppassword' => 'xxxxxxxxxxxxx',
  'mail_smtpport' => '465',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
);

Check your Apache logs.

Here are the apache logs after an access try to the nextcloud server:

access.log:

xxxxxxxxxxxxxxxxxxxx - - [18/May/2020:06:57:09 +0200] “GET /index.php/login HTTP/1.1” 500 4468 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:75.0) Gecko/20100101 Firefox/75.0”
xxxxxxxxxxxxxxxxxxxxx - - [18/May/2020:06:57:09 +0200] “GET /favicon.ico HTTP/1.1” 500 1347 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:75.0) Gecko/20100101 Firefox/75.0”

other_vhosts_access.log:

xxxxxxxxxxxxxxxxx:443 p549b90db.dip0.t-ipconnect.de - - [18/May/2020:06:57:09 +0200] “GET /index.php/login HTTP/1.1” 500 4468 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:75.0) Gecko/20100101 Firefox/75.0”
xxxxxxxxxxxxxxxxx:443 p549b90db.dip0.t-ipconnect.de - - [18/May/2020:06:57:09 +0200] “GET /favicon.ico HTTP/1.1” 500 1347 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:75.0) Gecko/20100101 Firefox/75.0”

error.log:

No entries

In the meantime I found that my database is corrupted. It seams that mysqldump interrupted after oc_filecache. Here is the mysql output of show tables;

+--------------------------+
| Tables_in_nextcloud      |
+--------------------------+
| oc_accounts              |
| oc_activity              |
| oc_activity_mq           |
| oc_addressbookchanges    |
| oc_addressbooks          |
| oc_appconfig             |
| oc_authtoken             |
| oc_bruteforce_attempts   |
| oc_calendar_invitations  |
| oc_calendar_resources    |
| oc_calendar_rooms        |
| oc_calendarchanges       |
| oc_calendarobjects       |
| oc_calendarobjects_props |
| oc_calendars             |
| oc_calendarsubscriptions |
| oc_cards                 |
| oc_cards_properties      |
| oc_comments              |
| oc_comments_read_markers |
| oc_credentials           |
| oc_dav_shares            |
| oc_directlink            |
| oc_federated_reshares    |
| oc_file_locks            |
| oc_filecache             |
+--------------------------+

Is there a ‘how to’ for recovering the database in such a case?

regards,

Holger