Comments (5)
Halo, terkait error nonagregat pada query GROUP BY, belum ada cara terbaik yang saya temukan untuk mengatasinya karena beberapa alasan berikut:
- Query berjalan dengan menambahkan primary (id) pada GROUP BY untuk tabel
app__activity_logs
, akan tetapi result yang ditampilkan tidak sesuai dengan ekspektasi yang mengharuskan grouping hanya berdasaruser_id
dandate
; - Alasan lain yang sedang dalam pengkajian.
Untuk mengatasi permasalahan tersebut, sebagian besar artikel merekomendasikan untuk mengubah konfigurasi MySQL. Yaitu dengan menambahkan baris untuk mengubah sql_mode pada file my.cnf
sesuai parameter berikut:
[mysqld]
sql_mode = "STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
kemudian restart service mysql.
Silakan merujuk pada artikel https://afrijaldzuhri.com/mengatasi-error-group-by-di-mysql/ atau https://tinyurl.com/y9oldmkb
from aksara.
sebagai informasi sy menggunakan ampps dan ketika di tambahkan baris code tersebut mysql nya tidak bisa berjalan
from aksara.
Mungkin bisa dicoba dengan metode lain dengan cara menjalankan perintah ini dari dari pma atau sql manager favoritnya:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
from aksara.
terima kasih. masalah sudah bisa di atasi dengan cara ini SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
from aksara.
Siap. Issue saya close, ya...
from aksara.
Related Issues (20)
- Core Images HOT 1
- upgrade boostrap v5 HOT 3
- count in set_relation function with reference id & where not working HOT 2
- Vulnerability HOT 2
- Suggestion for improvement HOT 1
- seach by column issues HOT 2
- Capability to bulk activate Account HOT 1
- Tipe Data Enum HOT 2
- PDF dengan query pencarian HOT 2
- Gallery image upload does not work HOT 2
- Use aksara as headless backend HOT 1
- Installation HOT 3
- Error Running HOT 1
- ErrorException after installing new HOT 1
- merge_content BUG HOT 2
- [BUG] sub_level_table Doesn't Exists HOT 1
- Error after update HOT 1
- Missing css and auth folders, and possibly more HOT 1
- Missing twig files on the default (front end) theme HOT 1
- How to update from 5.0.6 to 5.1.0 HOT 17
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 aksara.