在运行DB2的Moodle 2安装中,删除用户失败,返回一个“从数据库读取错误”的错误信息:
什么其他因素可能导致这个错误?
SQL0206N的错误描述很明显,但是调试信息:[IBM] [CLI Driver] [DB2/LINUXX8664] SQL0206N“USERIDFROM”在使用它的上下文中无效。SQLSTATE = 42703 SQLCODE = -206 SELECT * FROM mdl_message WHERE useridfrom =?ORDER BY timecreated
[array( 0 =>'28521', )]
useridfrom
是mdl_message
的一列。$ db2 describe table mdl_message
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------- --------- ------------------- ---------- ----- ------
ID SYSIBM BIGINT 8 0 No
USERIDFROM SYSIBM BIGINT 8 0 No
USERIDTO SYSIBM BIGINT 8 0 No
SUBJECT SYSIBM VARCHAR 200 0 Yes
FULLMESSAGE SYSIBM VARCHAR 200 0 Yes
FULLMESSAGEFORMAT SYSIBM SMALLINT 2 0 Yes
FULLMESSAGEHTML SYSIBM VARCHAR 100 0 Yes
SMALLMESSAGE SYSIBM VARCHAR 200 0 Yes
NOTIFICATION SYSIBM SMALLINT 2 0 Yes
CONTEXTURL SYSIBM VARCHAR 200 0 Yes
CONTEXTURLNAME SYSIBM VARCHAR 200 0 Yes
TIMECREATED SYSIBM BIGINT 8 0 No
12 record(s) selected.
什么其他因素可能导致这个错误?
1
(数字一)或l
(字母 L)之类的东西吗?除此之外,我假设TIMECREATED
是自纪元以来以毫秒(或纳秒)为单位的计数,以UTC为基准——以解决DB2在时间戳中不存储时区信息的问题? - Clockwork-Muse$ db2 "select * from mdl_message where USERIDFROM = 28251"
也会返回SQL0206N "USERIDFROM"在使用它的上下文中无效。SQLSTATE=42703
。 - Marius Butuc