Table 'nextcloud.oc.jobs' doesn't exist help please

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

hi, when i try to update nextcloud 17.0.2.1 to 19.0.2 i get this error: Table ‘nextcloud.oc_jobs’ doesn’t exist then in the ncp web-ui I get another error:
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.

please help. thank you.

here is my ncp-report:

NextCloudPi diagnostics 

NextCloudPi version  v1.29.8
NextCloudPi image    NextCloudPi_11-22-18
distribution         Raspbian GNU/Linux 10 \n \l
automount            yes
USB devices          sda 
datadir              /media/USBdrive
data in SD           yes
data filesystem      ext2/ext3
data disk usage      41G/118G
rootfs usage         41G/118G
swapfile             /var/swap
dbdir                /var/lib/mysql
Nextcloud check      ok
Nextcloud version    17.0.2.1
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
Postfix service      up
internet check       ok
port check 80        closed
port check 443       closed
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            wlan0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         yes
uptime               1:30
Nextcloud configuration 

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
            "0": "localhost",
            "11": "73.162.198.13",
            "1": "192.168.0.17",
            "5": "nextcloudpi.local",
            "7": "nextcloudpi",
            "8": "nextcloudpi.lan",
            "2": "depressiva.duckdns.org",
            "4": "depressiva.duckdns.org",
            "12": "depressiva.duckdns.org",
            "13": "depressiva.duckdns.org"
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "17.0.2.1",
        "overwrite.cli.url": "https:\/\/depressiva.duckdns.org\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "tempdirectory": "\/media\/USBdrive\/tmp",
        "mail_smtpmode": "sendmail",
        "mail_smtpauthtype": "LOGIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "jpeg_quality": "60",
        "overwriteprotocol": "https",
        "maintenance": false,
        "data-fingerprint": "9477309c08eaf649e81e16331e2d3d5d",
        "theme": "",
        "loglevel": "2",
        "log_type": "file",
        "app_install_overwrite": [
            "news"
        ],
        "logfile": "\/media\/USBdrive\/nextcloud.log"
    }
}
HTTPd logs 

[Mon Sep 07 04:52:14.237039 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40052] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:34.733013 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:34.942233 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:34.942698 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.118267 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.386851 2020] [authz_host:error] [pid 789:tid 1765659680] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /css/ncp.css failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.386969 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /js/ncp.js failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.387228 2020] [authz_host:error] [pid 789:tid 1933513760] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /img/ncp-logo.svg failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.387711 2020] [authz_host:error] [pid 789:tid 1950299168] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /img/loading-small.gif failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.391591 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /js/minified.js failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.766987 2020] [authz_host:error] [pid 789:tid 1765659680] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /img/defaults.svg failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.766988 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /img/poweroff.svg failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.766987 2020] [authz_host:error] [pid 789:tid 1950299168] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /img/reboot.svg failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.767697 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /img/toggle.svg failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.905954 2020] [authz_host:error] [pid 789:tid 1782445088] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:35.917848 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:41.253214 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:27:43.191850 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:28:20.357104 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Mon Sep 07 05:45:37.028784 2020] [authz_host:error] [pid 789:tid 1941906464] [client 192.168.0.8:40834] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
Database logs 

2020-09-07  4:48:49 0 [Note] InnoDB: Number of pools: 1
2020-09-07  4:48:49 0 [Note] InnoDB: Using generic crc32 instructions
2020-09-07  4:48:49 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2020-09-07  4:48:49 0 [Note] InnoDB: Completed initialization of buffer pool
2020-09-07  4:48:49 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-09-07  4:48:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-09-07  4:48:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-07  4:48:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-07  4:48:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-09-07  4:48:50 0 [Note] InnoDB: Waiting for purge to start
2020-09-07  4:48:50 0 [Note] InnoDB: 10.3.23 started; log sequence number 11017529751; transaction id 40794590
2020-09-07  4:48:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-09-07  4:48:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-07  4:48:50 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-09-07  4:48:50 0 [Note] Reading of all Master_info entries succeeded
2020-09-07  4:48:50 0 [Note] Added new Master_info '' to hash table
2020-09-07  4:48:50 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.23-MariaDB-0+deb10u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Raspbian 10
2020-09-07  4:48:53 0 [Note] InnoDB: Buffer pool(s) load completed at 200907  4:48:53
2020-09-07  5:44:23 108 [Warning] Access denied for user 'root'@'localhost'
2

how have you updated? using the internal webupdater of nextcloud?
or the routine of ncp?

have you tried upgrading directly from 17.0.2 to 19.0.2?

3

thanks for reply. I tried the internal updater. how do I update directly from 17.0.2 to 19.0.2?

4

it’s recommended to use the NCP-updater for updating since it helps you with e.g. missing tables and columns.

you never should skip any major version so far. That’s why I was asking if you did.

for adding missing indices and columns manually try the manual (or search the forum)

5

also, I think I mess up when i tried to move the database to a SSD drive, at this point I don’t know what to do since I don’t have backups, I don’t know why. Any idea with be aprecciated. thanks

6

I’m so sorry to tell you that I think a new setup would be needed… meaning starting from scratch. With the newest available version.

And yeah… keep to ncp… and for heaven’s sake: backup like crazy. ncp helps you. as well as moving your database and such.

but wells that just my opinion. others might have different ones

7

I have a RPi 4 and I started from scratch, I’m using duckdns to be able to access from outside my network, same account just different domain but I’m getting the same problem when I try to access typing my domain, I’m thinking probably it’s going to be a router/modem issue, I’ll try to reset router/modem to default settings and see what happens

8

I ran into this issue as well. See here some details, and probably the root case of the issue:

9

This issue is still there in v1.53.0.

How can I determine in a script if a prefix is used in the Nextcloud tables or not?