verdigado-public/nextcloud_groupfolder_filesystem_snapshots
1
0
Fork 0
Code Issues Pull requests Projects Releases 3 Packages Wiki Activity

Data too long for column before_path #1

New issue
Closed
opened 2025-02-19 09:53:26 +01:00 by sven.seeberg · 4 comments
sven.seeberg commented 2025-02-19 09:53:26 +01:00
Copy link

A user reports that a backup cannot be restored and sees the following error message:

An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column `before_path` at row 1

image

A user reports that a backup cannot be restored and sees the following error message: ``` An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column `before_path` at row 1 ``` ![image](/attachments/f46075e0-8ce3-4d97-91a2-e1d4e9ad51fa)
image.png
150 KiB
JunWi commented 2025-02-19 10:00:07 +01:00
Owner
Copy link

https://helpdesk.verdigado.com/#ticket/zoom/208292

https://helpdesk.verdigado.com/#ticket/zoom/208292
TreJo commented 2025-02-19 15:07:04 +01:00
Owner
Copy link

Line 73 in 1936223
$table->addColumn('before_path', 'string', [ 

			$table->addColumn('before_path', 'string', [
				'notnull' => false,
				'default' => '',
				'length' => 200,
			]);

Ich hatte die maximal Länge des Pfads einer gescannten Datei (relativ zur Gruppe) auf 200 beschränkt und nicht gedacht, dass wir da je drüber kommen. Aber OK, dann müssen wir das wohl anheben.

TODO:

  • Migration schreiben
  • Release erstellen
  • Release in app store hochladen
  • App in Wolke aktualisieren
https://git.verdigado.com/verdigado-public/nextcloud_groupfolder_filesystem_snapshots/src/commit/19362233f5482f0eea5ac3db0bdf89d6ccc634a7/lib/Migration/Version100Date20230822153000.php#L73 ``` $table->addColumn('before_path', 'string', [ 'notnull' => false, 'default' => '', 'length' => 200, ]); ``` Ich hatte die maximal Länge des Pfads einer gescannten Datei (relativ zur Gruppe) auf 200 beschränkt und nicht gedacht, dass wir da je drüber kommen. Aber OK, dann müssen wir das wohl anheben. TODO: - [x] Migration schreiben - [x] Release erstellen - [x] Release in app store hochladen - [ ] App in Wolke aktualisieren
JunWi commented 2025-02-19 16:29:39 +01:00
Owner
Copy link

Waeren dass 200 pro verzeichnis oder 200 fuer alle verzeichnisse?

Waeren dass 200 pro verzeichnis oder 200 fuer alle verzeichnisse?
TreJo closed this issue 2025-02-19 16:40:36 +01:00
TreJo commented 2025-02-19 17:13:00 +01:00
Owner
Copy link

@JunWi wrote in #1 (comment):

Waeren dass 200 pro verzeichnis oder 200 fuer alle verzeichnisse?

Pro Datei der relativer Pfad, also die Namen aller überliegenden Verzeichnisse mit "/" dazwischen.

@JunWi wrote in https://git.verdigado.com/verdigado-public/nextcloud_groupfolder_filesystem_snapshots/issues/1#issuecomment-39656: > Waeren dass 200 pro verzeichnis oder 200 fuer alle verzeichnisse? Pro Datei der relativer Pfad, also die Namen aller überliegenden Verzeichnisse mit "/" dazwischen.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
v1.3.1
v1.3.0
v1.2.0
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
3 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: verdigado-public/nextcloud_groupfolder_filesystem_snapshots#1
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?