I am ruuning owncloud 8.0.4.2 on linux Ubuntu 14.04 LTS
I get the following error after running this command in the directory
var/www/owncloud
var/www/owncloud# sudo -u www-data php occ db:convert-type --port=5432
--password=xxxxxxx --clear-schema --all-apps pgsql owncloud localhost xxxxdb
Clearing schema in new database
Creating schema in new database
oc_appconfig
86/86 [============================] 100%
oc_storages
12/12 [============================] 100%
oc_file_map
0/0 [============================] 0%
oc_mimetypes
27/27 [============================] 100%
oc_filecache
45/1408 [>---------------------------] 3%
[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing 'INSERT INTO oc_filecache
("fileid", "storage", "path", "path_hash", "
parent", "name", "mimetype", "mimepart", "size", "mtime",
"storage_mtime", "encrypted", "unencrypted_size",
"etag", "permissions") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?)' with params ["47", "4", "\x49\x
6d\x70\x6c\x65\x6d\x65\x6e\x74\x20\x61\x20\x53\x46\x54\x50\x20\x53\x65\x72\x76\x69\x63\x65\x20\x66\x6f\x72\x
20\x55\x62\x75\x6e\x74\x75\x5f\x44\x65\x62\x69\x61\x6e\x20\x57\x69\x74\x68\x20\x61\x20\x43\x68\x72\x6f\x6f\x
74\x92\x65\x64\x2c\x20\x49\x73\x6f\x6c\x61\x74\x65\x64\x20\x46\x69\x6c\x65\x20\x44\x69\x72\x65\x63\x74\x6f\x
72\x79\x2e\x70\x64\x66", "5b20c7ac743465ba1d935fc53c80281d", "15",
"\x49\x6d\x70\x6c\x65\x6d\x65\x6e\x74\x20
\x61\x20\x53\x46\x54\x50\x20\x53\x65\x72\x76\x69\x63\x65\x20\x66\x6f\x72\x20\x55\x62\x75\x6e\x74\x75\x5f\x44
\x65\x62\x69\x61\x6e\x20\x57\x69\x74\x68\x20\x61\x20\x43\x68\x72\x6f\x6f\x74\x92\x65\x64\x2c\x20\x49\x73\x6f
\x6c\x61\x74\x65\x64\x20\x46\x69\x6c\x65\x20\x44\x69\x72\x65\x63\x74\x6f\x72\x79\x2e\x70\x64\x66",
"7", "5",
"663314", "1362072086", "1362072086", "0", "0", "559319671aa4e", "27"]:
SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte
sequence for encoding "UTF8": 0x92
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte
sequence for encoding "UTF8": 0x92
[PDOException]
SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte
sequence for encoding "UTF8": 0x92
What should I do?
*From:* [email protected] [mailto:[email protected]] *On
Behalf Of *Vincent Petry
*Sent:* 16 July 2015 10:49 AM
*To:* For users of ownCloud
*Subject:* Re: [owncloud-user] Db Migration
Did you run the command in the correct directory ?
That command only exists since OC 7 I believe.
Maybe try "php console.php db:convert-type ..." instead.
Or "./occ db:convert-type ..."
On 16.07.2015 10:27, Brendon Lines wrote:
Thank you for response,
but when running this command I get the following error:
*Could not open input file: occ*
Is there perhaps another way?
*From:* [email protected] [mailto:[email protected]
<[email protected]>] *On
Behalf Of *Vincent Petry
*Sent:* 16 July 2015 10:08 AM
*To:* For users of ownCloud
*Subject:* Re: [owncloud-user] Db Migration
Hi,
You mean SQLite.
Here is how to convert to MySQL:
https://doc.owncloud.org/server/8.1/admin_manual/configuration_database/db_conversion.html
Cheers,
Vincent
On 16.07.2015 09:19, Brendon Lines wrote:
Hi there guys
The owncloud I have setup is not performing as I was expected, I realised
that in the upgrade process I mistakenly installed it with MySQL Light.
This seem to be the reason why it is falling over when I upload lots of
files.
Is it be possible to convert the MySQL Light DB on this owncloud instance
to MySQL, if so how do you go about doing this?
_______________________________________________
User mailing list
[email protected]
http://mailman.owncloud.org/mailman/listinfo/user
_______________________________________________
User mailing list
[email protected]
http://mailman.owncloud.org/mailman/listinfo/user
_______________________________________________
User mailing list
[email protected]
http://mailman.owncloud.org/mailman/listinfo/user
