gorm update 报错 ERROR: -217: IX000 : Cannot open file 'csql.iem'
dsn= gbase8s://gbasedbt:GBase_123@10.100.100.146:9088/test?GBASEDBTSERVER=gbase01&PROTOCOL=onsoctcp&delimident=1&sqlmode=oracle
表结构:
CREATE TABLE IF NOT EXISTS login_users (
id SERIAL NOT NULL,
username VARCHAR(64) DEFAULT '',
password_hash VARCHAR(128) DEFAULT '',
role_name VARCHAR(64) DEFAULT '',
email VARCHAR(64) DEFAULT '',
related_name VARCHAR(64) DEFAULT '',
last_login_time VARCHAR(64) DEFAULT '',
last_login_ip VARCHAR(64) DEFAULT '',
err_count INT DEFAULT 0,
err_time DATETIME YEAR TO SECOND,
totp_secret VARCHAR(128) DEFAULT '',
updated_at DATETIME YEAR TO SECOND NOT NULL DEFAULT CURRENT YEAR TO SECOND,
created_at DATETIME YEAR TO SECOND NOT NULL DEFAULT CURRENT YEAR TO SECOND,
temporary SMALLINT DEFAULT 0,
targetType SMALLINT DEFAULT 0,
targets VARCHAR(512) DEFAULT '',
deadline VARCHAR(32) DEFAULT '',
type SMALLINT DEFAULT 0,
lastChangePwdTime DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND,
maxIps INT DEFAULT 0,
maxDomains INT DEFAULT 0,
remote_login_ip VARCHAR(512) DEFAULT '',
remote_login_ip_black VARCHAR(512) DEFAULT '',
orgUuid VARCHAR(512) DEFAULT '',
needChangePassword SMALLINT DEFAULT 0,
defaultPassword VARCHAR(128) DEFAULT '',
hide SMALLINT DEFAULT 0,
PRIMARY KEY (id)
)
更新数据报错:
UPDATE "login_users" SET "orgUuid"='b85d1e66-f76d-497e-99c6-9114dbb1d612',"updated_at"='2025-07-20 22:52:36.51' WHERE orgUuid='',err=ERROR: -217: IX000 : Cannot open file 'csql.iem'
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25052
- 42023-09-25浏览数:18521
- 52020-05-11浏览数:17526