找回密码
 立即注册

QQ登录

只需一步,快速开始

jacke_he 活字格认证

金牌服务用户

71

主题

264

帖子

1043

积分

金牌服务用户

积分
1043

时代开发者征文活动活字格高级认证活字格认证

QQ

[已处理] V8.0.4

jacke_he 活字格认证
金牌服务用户   /  发表于:2022-9-20 11:36  /   查看:5150  /  回复:20
我的日志中一直出现一堆这个, 日志文件占比达95%, 查个日志相当困难, 是什么错误引起 ? 若是错误有什么办法可以解决, 若是没错如何让他不显示在日志中?

SQLite warning (28): double-quoted string literal: "备注"
SQLite warning (28): double-quoted string literal: "手机"
SQLite warning (28): double-quoted string literal: "头像"
SQLite warning (28): double-quoted string literal: "省份"
SQLite warning (28): double-quoted string literal: "国家"
SQLite warning (28): double-quoted string literal: "城市"
SQLite warning (28): double-quoted string literal: "UnionID"
SQLite warning (28): double-quoted string literal: "职位"
SQLite warning (28): double-quoted string literal: "手机号"
SQLite warning (28): double-quoted string literal: "Office365Id"
SQLite warning (28): double-quoted string literal: "DingTalkId"
SQLite warning (28): double-quoted string literal: "上司"
SQLite warning (28): double-quoted string literal: "显示语言"
SQLite warning (28): double-quoted string literal: "姓"
SQLite warning (28): double-quoted string literal: "名"
SQLite warning (28): double-quoted string literal: "标题"
SQLite warning (28): double-quoted string literal: "其他电话"
SQLite warning (28): double-quoted string literal: "主要电子邮件"
SQLite warning (28): double-quoted string literal: "住宅电话"
SQLite warning (28): double-quoted string literal: "电子邮件2"
SQLite warning (28): double-quoted string literal: "移动电话"
SQLite warning (28): double-quoted string literal: "手机通知电子邮件"
SQLite warning (28): double-quoted string literal: "首选电话"
SQLite warning (28): double-quoted string literal: "主要电话"
SQLite warning (28): double-quoted string literal: "寻呼机"
SQLite warning (28): double-quoted string literal: "传真"
SQLite warning (28): double-quoted string literal: "业务部门"
SQLite warning (28): double-quoted string literal: "区域"
SQLite warning (28): double-quoted string literal: "经理"
SQLite warning (28): double-quoted string literal: "场所"
SQLite warning (28): double-quoted string literal: "邮政编码"
SQLite warning (28): double-quoted string literal: "国家_地区"
SQLite warning (28): double-quoted string literal: "省_市_自治区"
SQLite warning (28): double-quoted string literal: "市_县"
SQLite warning (28): double-quoted string literal: "街道1"
SQLite warning (28): double-quoted string literal: "备注"
SQLite warning (28): double-quoted string literal: "手机"
SQLite warning (28): double-quoted string literal: "头像"
SQLite warning (28): double-quoted string literal: "省份"
SQLite warning (28): double-quoted string literal: "国家"
SQLite warning (28): double-quoted string literal: "城市"
SQLite warning (28): double-quoted string literal: "UnionID"
SQLite warning (28): double-quoted string literal: "职位"
SQLite warning (28): double-quoted string literal: "手机号"
SQLite warning (28): double-quoted string literal: "Office365Id"
SQLite warning (28): double-quoted string literal: "DingTalkId"
SQLite warning (28): double-quoted string literal: "上司"
SQLite warning (28): double-quoted string literal: "显示语言"
SQLite warning (28): double-quoted string literal: "姓"
SQLite warning (28): double-quoted string literal: "名"
SQLite warning (28): double-quoted string literal: "标题"
SQLite warning (28): double-quoted string literal: "其他电话"
SQLite warning (28): double-quoted string literal: "主要电子邮件"
SQLite warning (28): double-quoted string literal: "住宅电话"
SQLite warning (28): double-quoted string literal: "电子邮件2"
SQLite warning (28): double-quoted string literal: "移动电话"
SQLite warning (28): double-quoted string literal: "手机通知电子邮件"
SQLite warning (28): double-quoted string literal: "首选电话"
SQLite warning (28): double-quoted string literal: "主要电话"
SQLite warning (28): double-quoted string literal: "寻呼机"
SQLite warning (28): double-quoted string literal: "传真"
SQLite warning (28): double-quoted string literal: "业务部门"
SQLite warning (28): double-quoted string literal: "区域"
SQLite warning (28): double-quoted string literal: "经理"
SQLite warning (28): double-quoted string literal: "场所"
SQLite warning (28): double-quoted string literal: "邮政编码"
SQLite warning (28): double-quoted string literal: "国家_地区"
SQLite warning (28): double-quoted string literal: "省_市_自治区"
SQLite warning (28): double-quoted string literal: "市_县"
SQLite warning (28): double-quoted string literal: "街道1"
SQLite warning (284): automatic index on 用户信息视图(用户名)
SQLite warning (284): automatic index on 标准资料档案(中文名称)
SQLite warning (28): double-quoted string literal: "备注"
SQLite warning (28): double-quoted string literal: "手机"
SQLite warning (28): double-quoted string literal: "头像"
SQLite warning (28): double-quoted string literal: "省份"
SQLite warning (28): double-quoted string literal: "国家"
SQLite warning (28): double-quoted string literal: "城市"
SQLite warning (28): double-quoted string literal: "UnionID"
SQLite warning (28): double-quoted string literal: "职位"
SQLite warning (28): double-quoted string literal: "手机号"
SQLite warning (28): double-quoted string literal: "Office365Id"
SQLite warning (28): double-quoted string literal: "DingTalkId"
SQLite warning (28): double-quoted string literal: "上司"
SQLite warning (28): double-quoted string literal: "显示语言"
SQLite warning (28): double-quoted string literal: "姓"
SQLite warning (28): double-quoted string literal: "名"
SQLite warning (28): double-quoted string literal: "标题"
SQLite warning (28): double-quoted string literal: "其他电话"
SQLite warning (28): double-quoted string literal: "主要电子邮件"
SQLite warning (28): double-quoted string literal: "住宅电话"
SQLite warning (28): double-quoted string literal: "电子邮件2"
SQLite warning (28): double-quoted string literal: "移动电话"
SQLite warning (28): double-quoted string literal: "手机通知电子邮件"
SQLite warning (28): double-quoted string literal: "首选电话"
SQLite warning (28): double-quoted string literal: "主要电话"
SQLite warning (28): double-quoted string literal: "寻呼机"
SQLite warning (28): double-quoted string literal: "传真"
SQLite warning (28): double-quoted string literal: "业务部门"
SQLite warning (28): double-quoted string literal: "区域"
SQLite warning (28): double-quoted string literal: "经理"
SQLite warning (28): double-quoted string literal: "场所"
SQLite warning (28): double-quoted string literal: "邮政编码"
SQLite warning (28): double-quoted string literal: "国家_地区"
SQLite warning (28): double-quoted string literal: "省_市_自治区"
SQLite warning (28): double-quoted string literal: "市_县"
SQLite warning (28): double-quoted string literal: "街道1"
SQLite warning (28): double-quoted string literal: "备注"
SQLite warning (28): double-quoted string literal: "手机"
SQLite warning (28): double-quoted string literal: "头像"
SQLite warning (28): double-quoted string literal: "省份"
SQLite warning (28): double-quoted string literal: "国家"
SQLite warning (28): double-quoted string literal: "城市"
SQLite warning (28): double-quoted string literal: "UnionID"
SQLite warning (28): double-quoted string literal: "职位"
SQLite warning (28): double-quoted string literal: "手机号"
SQLite warning (28): double-quoted string literal: "Office365Id"
SQLite warning (28): double-quoted string literal: "DingTalkId"
SQLite warning (28): double-quoted string literal: "上司"
SQLite warning (28): double-quoted string literal: "显示语言"
SQLite warning (28): double-quoted string literal: "姓"
SQLite warning (28): double-quoted string literal: "名"
SQLite warning (28): double-quoted string literal: "标题"
SQLite warning (28): double-quoted string literal: "其他电话"
SQLite warning (28): double-quoted string literal: "主要电子邮件"
SQLite warning (28): double-quoted string literal: "住宅电话"
SQLite warning (28): double-quoted string literal: "电子邮件2"
SQLite warning (28): double-quoted string literal: "移动电话"
SQLite warning (28): double-quoted string literal: "手机通知电子邮件"
SQLite warning (28): double-quoted string literal: "首选电话"
SQLite warning (28): double-quoted string literal: "主要电话"
SQLite warning (28): double-quoted string literal: "寻呼机"
SQLite warning (28): double-quoted string literal: "传真"
SQLite warning (28): double-quoted string literal: "业务部门"
SQLite warning (28): double-quoted string literal: "区域"
SQLite warning (28): double-quoted string literal: "经理"
SQLite warning (28): double-quoted string literal: "场所"
SQLite warning (28): double-quoted string literal: "邮政编码"
SQLite warning (28): double-quoted string literal: "国家_地区"
SQLite warning (28): double-quoted string literal: "省_市_自治区"
SQLite warning (28): double-quoted string literal: "市_县"
SQLite warning (28): double-quoted string literal: "街道1"

20 个回复

倒序浏览
Grayson.Shang活字格认证 Wyn认证
超级版主   /  发表于:2022-9-20 12:04:25
沙发
大佬您好,这个是SQLite报的错误,我大概查了一下,主要的原因是SQL现在已经弃用双引号了,改成使用单引号了,你找找你程序是不是哪里使用SQL的时候,用的是双引号,改成单引号试试。
查找链接
https://forums.plex.tv/t/sqlite3 ... fering-hangs/718830
回复 使用道具 举报
jacke_he活字格认证
金牌服务用户   /  发表于:2022-9-20 13:52:32
板凳
一看这个是用户信息表, 而用户信息表的查询或关联不会使用双引号,除非你的关键字使用到了
回复 使用道具 举报
jacke_he活字格认证
金牌服务用户   /  发表于:2022-9-20 13:58:44
地板
或者我该如何定位到模块
回复 使用道具 举报
Grayson.Shang活字格认证 Wyn认证
超级版主   /  发表于:2022-9-20 15:32:15
5#
大佬您好,这个问题已经在调查了,后面有结果了,会在帖子中回复跟进
回复 使用道具 举报
Grayson.Shang活字格认证 Wyn认证
超级版主   /  发表于:2022-9-23 11:34:55
6#
大佬您好,这个问题,我们这边也没有找到原因,好像是SQLite本身报的错误,我们没有环境,这个影响要是大的话,我们约一个时间,在您的环境上跟踪调查一下问题,若是影响小的话,可以直接忽略这个问题。
回复 使用道具 举报
jacke_he活字格认证
金牌服务用户   /  发表于:2022-9-23 11:42:20
7#
依你们的时间,我单独发服务器的远程资料给你们帮跟踪下就行, 因为这个影响日志
回复 使用道具 举报
jacke_he活字格认证
金牌服务用户   /  发表于:2022-9-23 11:48:32
8#
附档提供远程资料

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 使用道具 举报
Grayson.Shang活字格认证 Wyn认证
超级版主   /  发表于:2022-9-23 12:29:29
9#
老板,我这里使用fxjmtest测试的时候,不知道Administrator的账户密码
回复 使用道具 举报
jacke_he活字格认证
金牌服务用户   /  发表于:2022-9-23 13:45:02
10#
Grayson.Shang 发表于 2022-9-23 12:29
老板,我这里使用fxjmtest测试的时候,不知道Administrator的账户密码

wisedata 或者 jack_fx  123456  
回复 使用道具 举报
123下一页
您需要登录后才可以回帖 登录 | 立即注册
返回顶部