Steps to reproduce
- Try to upgrade from 5.0.9 to 6.0.9
“An exception occurred while executing ‘SELECT
class = ? AND
argument = ?’: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db1024487-wikidb.oc_jobs’ doesn’t exist”
ownCloud version: (see ownCloud admin page)
5.0.9 and 6.0.9
Updated from an older ownCloud or fresh install:
Where did you install ownCloud from:
Login as admin user into your ownCloud and access http://example.com/index.php/settings/integrity/failed paste the results into https://gist.github.com/ and puth the link here.
error msg as above
The content of config/config.php:
Log in to the web-UI with an administrator account and click on 'admin' -> 'Generate Config Report' -> 'Download ownCloud config report' This report includes the config.php settings, the list of activated apps and other details in a well sanitized form. or If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your ownCloud installation folder *ATTENTION:* Do not post your config.php file in public as is. Please use one of the above methods whenever possible. Both, the generated reports from the web-ui and from occ config:list consistently remove sensitive data. You still may want to review the report before sending. If done manually then it is critical for your own privacy to dilligently remove *all* host names, passwords, usernames, salts and other credentials before posting. You should assume that attackers find such information and will use them against your systems.
List of activated apps:
If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your ownCloud installation folder.
Are you using external storage, if yes which one: local/smb/sftp/…
Are you using encryption: yes/no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
Web server error log
Insert your webserver log here
ownCloud log (data/owncloud.log)
Insert your ownCloud log here
I am trying to update an old and badly maintained Owncloud instance from 5.0.9 to the current stable version (10.0.9). Because of the limitations of the update process, I have to go through all intermediate major versions. However, the oldest available version is 6.0.9. Apparently, somewhere in between 5.0.9 and 6.0.9 the table “oc_jobs” got created and is now not available in my installation for the required update.
Thanks a lot for any help.