Hello,
If I upload files over the web the modified column shows me always the last change from windows and not the upload time.
Is there a setting for that? I’m using 10.2.1.4 Community version.
Hello,
could you share a screenshot of what you mean ?
Nothing wrong here. Uploading doesn’t change the file, right?
1 Like
Alright, it’s clearer now, but I don’t know if you can change that in the UI.
Looking at the database structure and at that link it could be storage_mtime.
storage_mtime int The last modified date of the file as a UNIX timestamp as stored on the storage.
mysql> describe oc_filecache;
+------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------+------+-----+---------+----------------+
| fileid | bigint(20) | NO | PRI | NULL | auto_increment |
| storage | int(11) | NO | MUL | 0 | |
| path | varchar(4000) | YES | | NULL | |
| path_hash | varchar(32) | NO | | | |
| parent | bigint(20) | NO | MUL | 0 | |
| name | varchar(250) | YES | | NULL | |
| mimetype | int(11) | NO | | 0 | |
| mimepart | int(11) | NO | | 0 | |
| size | bigint(20) | NO | | 0 | |
| mtime | bigint(20) | NO | | 0 | |
| storage_mtime | bigint(20) | NO | | 0 | |
| encrypted | int(11) | NO | | 0 | |
| unencrypted_size | bigint(20) | NO | | 0 | |
| etag | varchar(40) | YES | | NULL | |
| permissions | int(11) | YES | | 0 | |
| checksum | varchar(255) | YES | | NULL | |
+------------------+---------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)
Nevertheless fyi if you have the activity app and click on a file, you’ll have the history of modifications, and also the creation time.
1 Like
I just found a post. It’s not possible:
Starting with 9.2, uploading with a recent web browser will use the mtime of the actual file instead of upload date. Unless the browser doesn't expose that.
2 Likes
Hello,
well it’s too bad but at least you have your answer ^^
1 Like