Can't upgrade to 9.0.3 nor convert SQlite to MySQL

Ask all your questions regarding OC 8.2 Please read the Support Forum Rules
Forum rules
The forums were migrated over to https://central.owncloud.org which is based on the forum software Discourse. The forums here is put into read-only mode starting from today.

More background information about this move and the reasoning behind it is available in this blogpost:

https://daniel.molkentin.net/2016/07/20 ... d-central/
Steve60
Newbie
Posts: 3
Joined: Tue Jul 12, 2016 2:17 pm
ownCloud version: 8.2.5
Webserver: Apache
Database: SQLite
OS: Linux
PHP version: 5.4

Can't upgrade to 9.0.3 nor convert SQlite to MySQL

Postby Steve60 » Tue Jul 12, 2016 2:27 pm

Hi,

I'm currently trying to upgrade from 8.2.6 to 9.0.3, I'm runing OwnCloud with SQLite driver. I tried to update to the 9.0.3 following the manual procedure, but the first error came up "SQLSTATE[HY000]: General error: 5 database is locked".

I thought it was SQLite which was causing the error because of it's limitations so I tried to convert to MySQL but this error cames up:

Code: Select all

"An exception occurred while executing 'INSERT INTO oc_filecache (`fileid`, `storage`, `parent`, `name`, `mimetype`, `mimepart`, `mtime`, `encrypted`, `path_hash`, `etag`, `storage_mtime`, `path`, `permissions`, `size`, `unencrypted_
  size`, `checksum`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["1", "1", "-1", "", "2", "1", "1468314435", "0", "d41d8cd98f00b204e9800998ecf8427e", "5784b343e7837", "1468314128", "", "0", "13093746", "0", n
  ull]:
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'checksum' in 'field list'
"

Of course, when the first migration failed, I reverted to a working configuration (8.2.6) so a broken DB structure should not be the problem.

Any idea please?

Thanks! :D
------------------
Server configuration
Operating system: Ubuntu 12.04
Web server: Apache 2
Database: SQLite / MySQL
PHP version: 5.4
ownCloud version (see ownCloud admin page): 8.2.6
Updated from an older ownCloud or fresh install: Updated from an older

Steve60
Newbie
Posts: 3
Joined: Tue Jul 12, 2016 2:17 pm
ownCloud version: 8.2.5
Webserver: Apache
Database: SQLite
OS: Linux
PHP version: 5.4

Re: Can't upgrade to 9.0.3 nor convert SQlite to MySQL

Postby Steve60 » Tue Jul 12, 2016 4:06 pm

Ok so after some reading, it really seems like I've made a good choice to switch on MySQL instead of SQLite.
The main purpose of our installation was testing but it slowly moved to a production server.. so it certainly needs a "real" SQL Server.

I've checked the created tables and clearly, the migration agent missed a part, don't know why, but it didn't created the "checksum" column, I could create this myself but I'm worried about eventual other missing columns. Should I create a bug report or it seems to you that I AM the bug? :lol:

RealRancor
ownCloud master
Posts: 17381
Joined: Sat May 26, 2012 3:00 pm
ownCloud version: 9.0.2
Webserver: nginx
Database: MySQL
OS: Linux
PHP version: 7.0.x

Re: Can't upgrade to 9.0.3 nor convert SQlite to MySQL

Postby RealRancor » Tue Jul 12, 2016 5:23 pm

*gone*

Steve60
Newbie
Posts: 3
Joined: Tue Jul 12, 2016 2:17 pm
ownCloud version: 8.2.5
Webserver: Apache
Database: SQLite
OS: Linux
PHP version: 5.4

Re: Can't upgrade to 9.0.3 nor convert SQlite to MySQL

Postby Steve60 » Tue Jul 12, 2016 6:18 pm

Yep thanks, I created the "topic" on GitHub as I think it's more a dev bug than a missconfiguration problem.


  • Similar Topics
    Replies
    Views
    Last post

Return to “ownCloud Server 8.2”

Who is online

Users browsing this forum: No registered users and 1 guest