Error 500, database conversion step


#1

Hello :slight_smile:

I have a owncloud server hosted on debian, you can find the information below.
Since a few days I could not synchronize some data, the windows client is displaying 500 errors.

After a few search it seems the default SQLite database is the source of the issue.
I’ve read the documentation about the database conversion : https://doc.owncloud.org/server/8.1/admin_manual/configuration_database/db_conversion.html

But it seems a little too easy.
I’m not a great sysadmin and not a dbadmin so I have a few questions about the conversion process:

  • Do I need to create a database on MySQL before the conversion ? if yes where can I find the corresponding command ?
  • I know my Owncloud version is old, is it better to do the update before or after converting to MySQL database ?
  • Is there any step by step tutorial or blog or something about the database conversion ?

Thanks for your help

Server configuration

Operating system: Debian 7.11

Web server: Apache

Database: SQLite

PHP version: PHP 5.4.45-0+deb7u5

ownCloud version: (see ownCloud admin page) 8.1.9

Updated from an older ownCloud or fresh install: Fresh

Where did you install ownCloud from: Owncloud official source


#2

You could use the search function, you’ll find


#3

Hi Alfred,

Thanks for your help.
I used the search function but didnt find this particular topic.

Seems I could use the convert command line directly. I’ll try this and let you know the result.


#4

Good luck! I’m so happy using mysql from the beginning. :wink:


#5

It seems I have another problem, I cant use any commande with occ.

For example

root@owncloud:/# sudo -u www-data php occ maintenance:mode --on
Could not open input file: occ


#6

You have to be in the ownCloud base directory, eg /var/www/owncloud.


#7

thanks … I feel stupid now ! :zipper_mouth_face:


#8

Hey, from what i have read in the past this “conversion” doesn’t work starting with ownCloud 10 so i think its a good idea that you have chosen to first convert the database before upgrading the installation.


#9

I didnt have this information, thanks for it :slight_smile:

For now I have an issue with securing the VM before trying the upgrade…


#10

Hey,

i also only have found it some time ago in the Release Notes of ownCloud 10.