Comments (2)
group by d.Title
是为了避免出现相同标题的文档在列表中显示,如果变为group by d.Title,d.Id
,效果等同于不要group by
的查询了,因为d.Id
表示的是文档的主键Id,无论如何这个都不会出现重复的情况。
关于这个报错的问题,stackoverflow的解决方案:
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
from dochub.
嗯,按照您的需求,我通过禁用 only_full_group_by 设置比较好~~
mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
from dochub.
Related Issues (20)
- DocHub2.4版本会出现无法上传云存储的情况。 HOT 2
- 资料导入、资料批量上传
- 默认模板主页获取不到分类下的文档信息 HOT 1
- win 环境问题 HOT 1
- 作者您好,V2.4前端分类只显示20个,希望能显示完整。
- 求助:文档无法正确上传到minio、oss对象存储中,谢谢 HOT 15
- 目前遇到dochub的问题总结 HOT 5
- 关于“Error 1406: Data too long for column 'Description' at row 1” 的错误提示 HOT 2
- 文件转换耗时
- 有内网的部署需求,建议增加本地存储功能
- 预览只能显示一部分页面,而且页面重复显示
- 预览的水印中那里修改?
- 有人编译过源码么?请问怎么操作?粗略看了下 beego 的文档还是没整明白怎么编译。。 HOT 2
- Poppler的pdftocairo 替换 pdf2svg软件包
- 横幅图片显示不了
- 如何实现文档的批量上传 HOT 3
- xss in dochub
- 请问下,现在的beego包路径已经变了,想要做二次开发有没有什么简单的方法解决 HOT 2
- 关于TODO HOT 1
- gomod HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dochub.