Dateimanager EGroupware 21.1

[Lothar]

Hallo zusammen,
ich kann im Dateimanager leider keine neuen Verzeichnisse anlegen.
Fehlermeldung: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘fs_mode’ at row 1

Opensuse tumbleweed
mariadb-10.5.9-1.1.x86_64

Lothar

[Lothar]

Oh es war nur eine Rechteproblem.
Entschulding

Lothar

[StefanU]

Rechteproblem In EGw oder auf dem System?
In EGw fände ich so eine Meldung komisich/doof…

Screenshot?

Stefan

[Lothar]

Hallo Stefan,

Der Fehler ist immer noch reproduzierbar. Wobei ich mich hier in einem verlinkten Verzeichnis​ /home/lothar/Wohnung/Aquarium befinde.

Der Link geht aber auf das Verzeichnis /home/lothar/Dies_und_Das/Aquarium, das aber keinen Besitzer hat und nur der Gruppe “Vorrath” zugeordnet ist.

Wieso hat es keinen Besitzer ?

Lothar

[RalfBecker]

Kannst Du auf Deiner Datenbank mal folgendes ausführen:

mysql egroupware
show create table egw_sqlfs;

Sollte folgende Ausgabe generieren:

CREATE TABLE `egw_sqlfs` (
  `fs_id` int(11) NOT NULL AUTO_INCREMENT,
  `fs_dir` int(11) NOT NULL,
  `fs_name` varchar(200) NOT NULL,
  `fs_mode` smallint(6) NOT NULL,
  `fs_uid` int(11) NOT NULL DEFAULT 0,
  `fs_gid` int(11) NOT NULL DEFAULT 0,
  `fs_created` datetime NOT NULL,
  `fs_modified` datetime NOT NULL,
  `fs_mime` varchar(96) CHARACTER SET ascii NOT NULL,
  `fs_size` bigint(20) NOT NULL,
  `fs_creator` int(11) NOT NULL,
  `fs_modifier` int(11) DEFAULT NULL,
  `fs_active` tinyint(4) NOT NULL DEFAULT 1,
  `fs_content` longblob DEFAULT NULL,
  `fs_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fs_id`),
  KEY `egw_sqlfs_fs_dir_fs_active_fs_name` (`fs_dir`,`fs_active`,`fs_name`(16))
) ENGINE=InnoDB AUTO_INCREMENT=XXXX DEFAULT CHARSET=utf8

Ralf

[Lothar]

​MariaDB [(none)]> use egroupware
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [egroupware]> show create table egw_sqlfs;

[Lothar]

Hier die Datenbankausgabe von : show create table egw_sqlfs;

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±----------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| egw_sqlfs | CREATE TABLE egw_sqlfs (
fs_id int(11) NOT NULL AUTO_INCREMENT,
fs_dir int(11) NOT NULL,
fs_name varchar(200) NOT NULL,
fs_mode smallint(6) NOT NULL,
fs_uid int(11) NOT NULL DEFAULT 0,
fs_gid int(11) NOT NULL DEFAULT 0,
fs_created datetime NOT NULL,
fs_modified datetime NOT NULL,
fs_mime varchar(96) CHARACTER SET ascii NOT NULL,
fs_size bigint(20) NOT NULL,
fs_creator int(11) NOT NULL,
fs_modifier int(11) DEFAULT NULL,
fs_active tinyint(4) NOT NULL DEFAULT 1,
fs_content longblob DEFAULT NULL,
fs_link varchar(255) DEFAULT NULL,
PRIMARY KEY (fs_id),
KEY egw_sqlfs_fs_dir_fs_active_fs_name (fs_dir,fs_active,fs_name(16))
) ENGINE=InnoDB AUTO_INCREMENT=19055 DEFAULT CHARSET=utf8 |
±----------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

Siehr doch gut aus oder ???

Lothar