Steps to reproduce
- Try to upgrade from 5.0.9 to 6.0.9
Expected behaviour
Successful upgrade
Actual behaviour
Error message:
“An exception occurred while executing ‘SELECT id
FROM oc_jobs
WHERE class
= ? AND argument
= ?’: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db1024487-wikidb.oc_jobs’ doesn’t exist”
Server configuration
Operating system:
N/A
Web server:
N/A
Database:
MySQL
PHP version:
3.7
ownCloud version: (see ownCloud admin page)
5.0.9 and 6.0.9
Updated from an older ownCloud or fresh install:
Update
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:
N/A
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/…
no
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
no
Client configuration
Browser:
any
Operating system:
any
Logs
Web server error log
Insert your webserver log here
ownCloud log (data/owncloud.log)
Insert your ownCloud log here
Browser log
Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...
N/A
Additional comment:
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.
Kind regards,
Martin