Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

oC Upgrade fails INSERT INTO oc_appconfig 19 columns appid, configkey are not unique #6371

Closed
PlumbumDN opened this issue Dec 12, 2013 · 22 comments
Closed

oC Upgrade fails INSERT INTO oc_appconfig 19 columns appid, configkey are not unique #6371

PlumbumDN opened this issue Dec 12, 2013 · 22 comments
Labels
Type:Bug

Comments

@PlumbumDN
Copy link

Hello,
Im getting the following error on upgrade from 5.0 to latest 6.0 release.
Is there a way to fix this on a default install?

An exception occurred while executing 'INSERT INTO oc_appconfig ("appid", "configkey", configvalue) SELECT appid, configkey, configvalue FROM tempoc_appconfig': SQLSTATE[23000]: Integrity constraint violation: 19 columns appid, configkey are not unique

The error looks like the one mentioned in #2836 but I'm on Debian and Apache2 and not Win7 + IIS.

Regards,
Plumbum
@karlitschek
Copy link
Contributor

Can you post a full bug report as described here? https://github.com/owncloud/core/blob/master/CONTRIBUTING.md

@PlumbumDN
Copy link
Author

Sorry for the missing informations, here are the details:

Expected behaviour

ownCloud should be upgraded from Version 5.0.13 to Version 6.0.0.13

Actual behaviour

Upgrade fails with the message above and the information to send this bug to the oC community

Steps to reproduce

  1. running install of 5.0.13.X
  2. delete all files/folders except data and config
  3. untar latest version
  4. try to call webside

Server configuration

Operating system: Debian GNU/Linux 7.1

Web server: Apache/2.2.22 (Debian)

Database: sqlite

PHP version: PHP 5.4.4-14+deb7u4 (cli)

ownCloud version: should be 6.0.0.13 now

Updated from an older ownCloud or fresh install: upgrade

List of activated app: unknown

config/config.php

The content of config/config.php: (Without the database password and passwordsalt)

  'datadirectory' => '/var/www/owncloud/data',
  'dbtype' => 'sqlite3',
  'version' => '6.0.0.13',
  'installed' => true,
  'forcessl' => true,
  'maxZipInputSize' => 1288490188.8,
  'allowZipDownload' => true,
  'theme' => '',
  'maintenance' => false,

Client configuration

Browser:Firefox 26.0

Operating system: Windows 7 x64 SP1

Logs

Web server error log

[Thu Dec 12 18:32:53 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:53+00:00"}
[Thu Dec 12 18:32:53 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:32:54 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:54+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:32:54 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:32:55 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:55+00:00"}
[Thu Dec 12 18:32:55 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:32:55 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:55+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:32:55 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:32:57 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:57+00:00"}
[Thu Dec 12 18:32:57 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:32:58 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:58+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:32:58 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:32:59 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:32:59+00:00"}
[Thu Dec 12 18:32:59 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:33:00 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:33:00+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:33:00 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:33:43 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:33:43+00:00"}
[Thu Dec 12 18:33:43 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:33:44 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:33:44+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:33:44 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:33:45 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:33:45+00:00"}
[Thu Dec 12 18:33:45 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:33:46 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:33:46+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:33:46 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:34:41 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:34:41+00:00"}
[Thu Dec 12 18:34:41 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:34:41 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:34:41+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:34:41 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:35:03 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:35:03+00:00"}
[Thu Dec 12 18:35:03 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:35:03 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:35:03+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:35:03 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:35:20 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:35:20+00:00"}
[Thu Dec 12 18:35:20 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:35:21 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:35:21+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:35:21 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:35:22 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:35:22+00:00"}
[Thu Dec 12 18:35:22 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:35:22 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:35:22+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:35:22 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:36:57 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:36:57+00:00"}
[Thu Dec 12 18:36:57 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:36:58 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:36:58+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:36:58 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:36:58 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:36:58+00:00"}
[Thu Dec 12 18:36:58 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:36:59 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:36:59+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:36:59 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:37:45 2013] [error] [client 192.168.1.240] {"app":"PHP","message":"opendir(\\/var\\/www\\/owncloud\\/data\\/public-keys): failed to open dir: Permission denied at \\/var\\/www\\/owncloud\\/lib\\/private\\/helper.php#322","level":2,"time":"2013-12-12T17:37:45+00:00"}
[Thu Dec 12 18:37:45 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:37:45+00:00"}
[Thu Dec 12 18:37:45 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:37:45 2013] [error] [client 192.168.1.240] {"app":"PHP","message":"opendir(\\/var\\/www\\/owncloud\\/data\\/public-keys): failed to open dir: Permission denied at \\/var\\/www\\/owncloud\\/lib\\/private\\/helper.php#322","level":2,"time":"2013-12-12T17:37:45+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:37:45 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:37:45+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:37:45 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:37:49 2013] [error] [client 192.168.1.240] {"app":"PHP","message":"opendir(\\/var\\/www\\/owncloud\\/data\\/public-keys): failed to open dir: Permission denied at \\/var\\/www\\/owncloud\\/lib\\/private\\/helper.php#322","level":2,"time":"2013-12-12T17:37:49+00:00"}
[Thu Dec 12 18:37:49 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:37:49+00:00"}
[Thu Dec 12 18:37:49 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:37:49 2013] [error] [client 192.168.1.240] {"app":"PHP","message":"opendir(\\/var\\/www\\/owncloud\\/data\\/public-keys): failed to open dir: Permission denied at \\/var\\/www\\/owncloud\\/lib\\/private\\/helper.php#322","level":2,"time":"2013-12-12T17:37:49+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:37:49 2013] [error] [client 192.168.1.240] {"app":"index","message":"Exception: SQLSTATE[HY000] [14] unable to open database file [14]","level":4,"time":"2013-12-12T17:37:49+00:00"}, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:37:49 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:49:17 2013] [error] [client 192.168.1.240] File does not exist: /var/www/core
[Thu Dec 12 18:58:42 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:58:42 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:58:45 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:58:45 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:59:25 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:59:26 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:59:28 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:59:28 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 18:59:50 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154
[Thu Dec 12 18:59:50 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154, referer: https://ks3316476.kimsufi.com/owncloud/
[Thu Dec 12 19:03:11 2013] [error] [client 192.168.1.240] PHP Fatal error:  Call to a member function getL10N() on a non-object in /var/www/owncloud/lib/private/l10n.php on line 82
[Thu Dec 12 19:03:13 2013] [error] [client 192.168.1.240] PHP Fatal error:  Call to a member function getL10N() on a non-object in /var/www/owncloud/lib/private/l10n.php on line 82
[Thu Dec 12 19:03:48 2013] [error] [client 192.168.1.240] PHP Fatal error:  Class 'Patchwork\\Utf8\\Bootup' not found in /var/www/owncloud/lib/private/util.php on line 862
[Thu Dec 12 19:05:34 2013] [error] [client 192.168.1.240] PHP Fatal error:  Class 'Patchwork\\Utf8\\Bootup' not found in /var/www/owncloud/lib/private/util.php on line 862
[Thu Dec 12 19:05:35 2013] [error] [client 192.168.1.240] PHP Fatal error:  Class 'Patchwork\\Utf8\\Bootup' not found in /var/www/owncloud/lib/private/util.php on line 862
[Thu Dec 12 19:05:37 2013] [error] [client 192.168.1.240] PHP Fatal error:  Class 'Patchwork\\Utf8\\Bootup' not found in /var/www/owncloud/lib/private/util.php on line 862

ownCloud log (data/owncloud.log)

{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:51:01+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:52:01+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:53:01+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:02+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:22+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:22+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:24+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:24+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:26+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:26+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:29+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:30+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:33+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:33+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:54:33+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:55:01+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:56:01+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:57:02+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T17:58:01+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:58:42+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:58:42+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:58:45+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:58:45+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:01+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:25+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:26+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:28+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:28+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:50+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T17:59:50+00:00"}
{"app":"cron","message":"An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T18:00:01+00:00"}
{"app":"remote","message":"An exception occurred while executing 'SELECT \"appid\" FROM \"oc_appconfig\" WHERE \"configkey\" = 'enabled' AND \"configvalue\"='yes'':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_appconfig","level":4,"time":"2013-12-12T18:00:10+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[HY000]: General error: 1 no such table: oc_jobs","level":4,"time":"2013-12-12T18:01:09+00:00"}
{"app":"core","message":"Failed to update database structure (exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 19 columns appid, configkey are not unique' in \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:742\nStack trace:\n#0 [internal function]: PDO->query('INSERT INTO oc_...')\n#1 \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(742): call_user_func_array(Array, Array)\n#2 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(152): Doctrine\\DBAL\\Connection->query('INSERT INTO oc_...')\n#3 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(91): OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#4 \/var\/www\/owncloud\/lib\/private\/db.php(373): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/ownclo...')\n#5 \/var\/www\/owncloud\/lib\/private\/updater.php(106): OC_DB::updateDbFromStructure('\/var\/www\/ownclo...')\n#6 \/var\/www\/owncloud\/core\/ajax\/update.php(34): OC\\Updater->upgrade()\n#7 {main}\n\nNext exception 'Doctrine\\DBAL\\DBALException' with message 'An exception occurred while executing 'INSERT INTO oc_appconfig (\"appid\", \"configkey\", configvalue) SELECT appid, configkey, configvalue FROM __temp__oc_appconfig':\n\nSQLSTATE[23000]: Integrity constraint violation: 19 columns appid, configkey are not unique' in \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php:47\nStack trace:\n#0 \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(744): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(PDOException), 'INSERT INTO oc_...')\n#1 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(152): Doctrine\\DBAL\\Connection->query('INSERT INTO oc_...')\n#2 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(91): OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#3 \/var\/www\/owncloud\/lib\/private\/db.php(373): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/ownclo...')\n#4 \/var\/www\/owncloud\/lib\/private\/updater.php(106): OC_DB::updateDbFromStructure('\/var\/www\/ownclo...')\n#5 \/var\/www\/owncloud\/core\/ajax\/update.php(34): OC\\Updater->upgrade()\n#6 {main})","level":4,"time":"2013-12-12T18:01:10+00:00"}

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

@PVince81
Copy link
Contributor

Seems to be a duplicate of #6294

Please check the workaround there and post there whether it worked for you.

@PVince81
Copy link
Contributor

Let's hope the app_config stuff could be a side effect of #6294
But the log look like #6294

@PVince81
Copy link
Contributor

The app_config stuff is very likely to NOT be related to #6294

@schiessle
Copy link
Contributor

I tried migration with the exact same setup and the same steps a few days ago without any problems... Which apps do you have enabled?

@PVince81
Copy link
Contributor

@PlumbumDN did you enable any extra apps ?

@PlumbumDN
Copy link
Author

Ok, now i added the oc_jobs like in #6294 but the error with oc_appconfig is still the same.
I think i disabled all apps, but could be the thing that I missed one...
Is it possible to fix this in the db directly?

@PVince81
Copy link
Contributor

Can you use the sqlite3 data/owncloud.db then select * from oc_appconfig and .tables to check whether that table exists before the migration ?

I'm not sure what's wrong in your db, so not sure how to fix it. oc_appconfig is an important table and it is unclear why that one would just disappear.

Also, some of the log entries look strange:

[Thu Dec 12 18:58:42 2013] [error] [client 192.168.1.240] PHP Fatal error:  Method OC_L10N_String::__toString() must not throw an exception in /var/www/owncloud/lib/private/defaults.php on line 154

Why would $this->getSlogan() in the footer throw an exception when trying to get an internationalized string ?

@PVince81
Copy link
Contributor

And .quit to quit sqlite3 (as it's not intuitive...)

@PlumbumDN
Copy link
Author

Table exists, here is the content

appid;configkey;configvalue;
core;installedat;1378141388.4;
core;lastupdatedat;1386866756.1951;
core;remote_core.css;/core/minimizer.php;
core;remote_core.js;/core/minimizer.php;
files_pdfviewer;installed_version;0.2;
files_pdfviewer;types;;
files_pdfviewer;enabled;no;
files_imageviewer;installed_version;1.0;
files_imageviewer;types;;
files_imageviewer;enabled;no;
user_migrate;installed_version;0.1;
user_migrate;types;;
user_migrate;enabled;no;
media;installed_version;0.4.3;
core;remote_ampache;media/remote.php;
media;types;;
media;enabled;no;
search_lucene;installed_version;0.5.0;
search_lucene;types;filesystem;
search_lucene;enabled;no;
gallery;installed_version;0.5.2;
core;public_gallery;gallery/sharing.php;
gallery;types;filesystem;
gallery;disabled;no;
files_odfviewer;installed_version;0.1;
files_odfviewer;types;;
files_odfviewer;enabled;no;
calendar;installed_version;0.6.3;
core;remote_calendar;calendar/appinfo/remote.php;
core;remote_caldav;calendar/appinfo/remote.php;
core;public_calendar;calendar/share.php;
core;public_caldav;calendar/share.php;
calendar;types;;
calendar;enabled;no;
firstrunwizard;installed_version;1.0;
firstrunwizard;types;;
firstrunwizard;enabled;no;
files_versions;installed_version;1.0.3;
files_versions;types;filesystem;
files_versions;enabled;no;
files_trashbin;installed_version;0.4;
files_trashbin;types;filesystem;
files_trashbin;enabled;no;
files;installed_version;1.1.7;
core;remote_files;files/appinfo/remote.php;
core;remote_webdav;files/appinfo/remote.php;
core;remote_filesync;files/appinfo/filesync.php;
files;types;filesystem;
files;enabled;no;
admin_migrate;installed_version;0.1;
admin_migrate;types;;
admin_migrate;enabled;no;
contacts;installed_version;0.2.5;
core;remote_contacts;contacts/appinfo/remote.php;
core;remote_carddav;contacts/appinfo/remote.php;
core;remote_contactthumbnail;contacts/thumbnail.php;
contacts;types;;
contacts;enabled;no;
updater;installed_version;0.3;
updater;types;;
updater;enabled;no;
files_texteditor;installed_version;0.3;
files_texteditor;types;;
files_texteditor;enabled;no;
files_sharing;installed_version;0.3.3;
core;public_files;files_sharing/public.php;
core;public_webdav;files_sharing/public.php;
files_sharing;types;filesystem;
files_sharing;enabled;no;
files_videoviewer;installed_version;0.1.1;
files_videoviewer;types;;
files_videoviewer;enabled;no;
bookmarks;enabled;no;
files_antivirus;types;filesystem;
files_antivirus;enabled;no;
files_antivirus;installed_version;0.4;
bookmarks;types;;
bookmarks;installed_version;0.3;
core;backgroundjobs_mode;cron;
core;backgroundjobs_task;OC_Files_Antivirus_BackgroundScanner-check;
core;global_cache_gc_lastrun;1381938842;
core;backgroundjobs_step;regular_tasks;
core;backgroundjobs_mode;cron;
files_encryption;installed_version;0.4;
files_encryption;types;filesystem;
files_encryption;enabled;no;

@PVince81
Copy link
Contributor

Still having trouble understanding what's going on here.

Can you try installing Xdebug for PHP ? It will show more details in logs.
Also please add define('DEBUG', 1) in the config.php and re-run the migration from scratch, with a fresh OC 5.0.13 (you mentionned above that it doesn't work either) without any data (in case you were trying with existing files in data)
Then repost the logs.

Also, when migrating make sure to open "index.php" not "index.php/apps/files" because of that other bug.

Thanks.

@PVince81
Copy link
Contributor

The L10N exception is covered here: #6438
It's basically "there was an error while trying to show the error" ...

For the appconfig part, still need further research.

@AxiomDeSigns-zz
Copy link

I too have this error - it went away when I disabled the OC6 "documents 0.7.2" app

@VicDeo
Copy link
Member

VicDeo commented Dec 17, 2013

@AxiomDeSigns which one exactly?
exception

'INSERT INTO oc_appconfig ("appid", "configkey", configvalue) SELECT appid, configkey, configvalue FROM tempoc_appconfig': SQLSTATE[23000]: Integrity constraint violation: 19 columns appid, configkey are not unique

on migration 5.0 to latest 6.0?

@AxiomDeSigns-zz
Copy link

@VicDeo

Whilst messing about on my server after posting here, I upgraded from 6.0.0 to 6.0.0a

In seeing your reply, I went to replicate it for you to give you more details, and now it's functioning.
So, um, it's all good now.. :)

@PlumbumDN
Copy link
Author

Ok a fresh install works, but if there are old entries in oc_appconfig upgrade fails.
After i dropped this table, the upgraded worked, but all apps are malfunctioning and even core features don't work.

@PlumbumDN
Copy link
Author

Ok, 2nd STEP.
After upgrade I reimported the values except the ones added after upgrade back into oc_appconfig and everything works again.

@PVince81
Copy link
Contributor

PVince81 commented Feb 7, 2014

I suppose this is another case for the future "repair DB" script @karlitschek ?

@karlitschek
Copy link
Contributor

Absolutely. Do you want to add it to /core/command/maintenance/repair.php yourself?

@sixer82
Copy link

sixer82 commented Feb 17, 2014

Hi there I just had the same error and found this issue googeling it.

I managed to fix it by reordering the extensions within php.ini

old order:
extension=/usr/lib/php5/20090626+lfs/mysql.so
extension=/usr/lib/php5/20090626+lfs/mysqli.so
extension=/usr/lib/php5/20090626+lfs/mcrypt.so
extension=/usr/lib/php5/20090626+lfs/pdo_mysql.so
extension=/usr/lib/php5/20090626+lfs/gd.so
extension=/usr/lib/php5/20090626+lfs/pdo.so

new order:
extension=/usr/lib/php5/20090626+lfs/mysql.so
extension=/usr/lib/php5/20090626+lfs/mysqli.so
extension=/usr/lib/php5/20090626+lfs/mcrypt.so
extension=/usr/lib/php5/20090626+lfs/pdo.so
extension=/usr/lib/php5/20090626+lfs/pdo_mysql.so
extension=/usr/lib/php5/20090626+lfs/gd.so

I suppose pdo_mysql.so depends on pdo.so and needs it to be loaded first.

@PVince81
Copy link
Contributor

PVince81 commented May 6, 2014

Closing in favor of #8469

@sixer82 are you sure you posted in the correct thread ? It doesn't seem related to PDO orders.

@PVince81 PVince81 closed this as completed May 6, 2014
@lock lock bot locked as resolved and limited conversation to collaborators Aug 18, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
Type:Bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
7 participants
@PVince81 @karlitschek @VicDeo @schiessle @PlumbumDN @AxiomDeSigns-zz @sixer82