Open jzaers opened 6 years ago
I confirm this issue with docker images:
Just applied this path manually and waiting for results:
alter table properties alter column propertypath type character varying(1024);
I'm able to reproduce during rename:
An exception occurred while executing 'UPDATE "oc_properties" SET "propertypath" = ? WHERE "userid" = ? AND "propertypath" = ?' with params ["***very long test path***", "***test user***", "***long test path***"]:
SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character
We should probably align this with path
. Would you mind to create a pull request? ;)
What is the right place for this change? I assume this is for 18 only?
Yes. I probably forgot that this kind of change requires a bit more work. Just changing the value over there will not work :see_no_evil:
php occ migrations:generate core 18000
use occ to generate a migration
Delete preSchemaChange
and postSchemaChange
/** @var ISchemaWrapper $schema */
$schema = $schemaClosure();
if ($schema->hasTable('properties')) {
$table = $schema->getTable('properties');
$table->changeColumn('propertypath', [
'notnull' => true,
'length' => 4000,
'default' => '',
]);
}
return $schema;
Probably something like above for changeSchema
but have not tested it.
php occ migrations:execute core 18000Date201911xzy
run the migration
Discussed this with @rullzer briefly.
For 19 we can change the original migration so new installations get a more appropriate column width by default
Since 19 has already been released I'll tag it for 20.
Hi, please update to 24.0.8 or better 25.0.2 and report back if it fixes the issue. Thank you!
Hi,
sorry, I’m no longer using nextcloud, so I can’t check it.
Cheers, Jo.
— Grüntenweg 8a 86859 Igling Tel. +49 172 83 800 82
HINWEIS: Dies ist eine vertrauliche Nachricht und nur für den Adressaten bestimmt. Es ist nicht erlaubt, diese Nachricht zu kopieren oder Dritten zugänglich zu machen. Sollten Sie diese Nachricht irrtümlich erhalten haben, bitte ich um Ihre Mitteilung per E-Mail oder unter der oben angegebenen Telefonnummer.
Am 09.01.2023 um 12:40 schrieb Simon L. @.***>:
Hi, please update to 24.0.8 or better 25.0.2 and report back if it fixes the issue. Thank you!
— Reply to this email directly, view it on GitHub https://github.com/nextcloud/server/issues/9907#issuecomment-1375500552, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJGS33I6BKR3SGUV5F2Q4P3WRP2MRANCNFSM4FFT2J5A. You are receiving this because you authored the thread.
This is still an issue.
This is still an issue.
@J0WI are you sure? This should have been fixed with https://github.com/nextcloud/server/pull/19242
Steps to reproduce
Expected behaviour
I would like to
Actual behaviour
Files with too long paths are synced to the server and encounter problems on later move operations. It looks like the move is executed like a copy and the original file stays in the source directory. But this is not happening always. I assume that it depends on the resulting file path in the destination directory.
Server configuration
Operating system: ubuntu 14.04 LTS
Web server: Apache 2.4
Database: postgresql 9.4
PHP version: php 5.6
Nextcloud version: (see Nextcloud admin page) see above, 12.0.6.1, (I updated the server to 13 afterwards, a few server configs below are from the new server, I try to reproduce this under 13.)
Updated from an older Nextcloud/ownCloud or fresh install: Migration from owncloud 9 or 10.
Where did you install Nextcloud from:
Signing status:
Signing status
No errors have been found.List of activated apps: This is from the server after upgrade to v 13.
Enabled:
Nextcloud configuration:
Config report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***", "version": "13.0.4.0", "dbtype": "pgsql", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbname": "***REMOVED SENSITIVE VALUE***", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "logtimezone": "UTC", "installed": true, "ldapIgnoreNamingRules": false, "loglevel": 3, "log_type": "owncloud", "logfile": "\/opt\/oc-data\/nextcloud.log", "maintenance": false, "singleuser": false, "memcache.local": "\\OC\\Memcache\\Redis", "filelocking.enabled": "true", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379, "timeout": 0, "dbindex": 0 }, "trashbin_retention_obligation": "auto, 60", "versions_retention_obligation": "auto", "theme": "", "updater.release.channel": "production", "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "updater.secret": "***REMOVED SENSITIVE VALUE***" } }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/...
YES, LDAP Apple OD, config not pasted, as not relevant.
Client configuration
Browser:
Operating system: MACOS, nextcloud client 2.3.3
Logs
Web server error log
not relevant
Nextcloud log (data/nextcloud.log)
see above
Browser log
not relevant