Linked Questions
2
votes
3
answers
6k
views
A Database Error Occurred Error Number: 1055 [duplicate]
Changed the database from MySQL to MySQLI and getting the error - A Database Error Occurred
Error Number: 1055
Expression #23 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
- 381
0
votes
1
answer
3k
views
which is not functionally dependent on columns in group by clause this is incompatible with sql_modeonly_full_group [duplicate]
select countrycode,name, max(population)
from city
group by CountryCode LIMIT 0, 1000
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '...
0
votes
2
answers
379
views
Getting an error when I try to run this query in sequel pro [duplicate]
I am trying to build a query that returns the most recent message from two joined tables. But I am getting an error on group by. Maybe I am approaching it the wrong completely.
I know that in my ...
- 497
0
votes
1
answer
240
views
my query is showing heidisql error a dont know how to fix [duplicate]
SQL Error (1055): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a.room id' which is not functionally dependent on columns in GROUP BY clause; this is ...
- 15
1
vote
0
answers
232
views
SQL query with groupBy doesn't work in Symfony 4 QueryBuilder [duplicate]
I am working on the Messaging system. Using query builder, I wanna get a message list link to the specific user. There are From and To in the database, and To will be the specific user, and From will ...
- 214
0
votes
0
answers
138
views
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated [duplicate]
I got this error when I used GROUP BY in the query below
Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and ...
- 141
-1
votes
2
answers
99
views
MySQL Using SUM in a JOIN giving? [duplicate]
I am trying to get the SUM of a column in my MySQL query
SELECT pi.*
, pr.EK2
, pr.EK3
, SUM(P_OrderTotal) as SUM_P_OrderTotal
FROM pixi pi
LEFT
JOIN konditionen pr
ON pi....
- 3,035
-1
votes
3
answers
128
views
I have two errors in a query PHP MySQL group by [duplicate]
I have this basic query`
SELECT * FROM contratti GROUP BY mail
In MySQL I have this error:
#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '...
- 3
0
votes
1
answer
55
views
Trouble COUNT function in INSERT statement [duplicate]
I'm trying to insert data into a table and running into a problem with using the COUNT function. The count_rentals and count_returns columns are supposed to represent the number of times a given movie ...
0
votes
0
answers
53
views
Syntax error or access violation In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'dbnam.users.id'; [duplicate]
Hie, am facing problems when i try to login into my php website online ,but when i login am getting this error
There is some problem in connection: SQLSTATE[42000]: Syntax error or access violation: ...
0
votes
0
answers
35
views
PDOException:SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated [duplicate]
My Yii framework website was working fine until I decided to upgrade the PHP. It was 5+ version.
My current environment:
1. ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))
2. mysql Ver 8.0.33-0
3. PHP ...
- 11
134
votes
15
answers
472k
views
Setting global sql_mode in MySQL
I am trying to set sql_mode in MySQL but it throws an error.
Command:
set global sql_mode='NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLE','NO_AUTO_CREATE_USER','NO_ENGINE_SUBSTITUTION'
Is this not the ...
- 6,450
51
votes
5
answers
98k
views
Counting associated entries with Sequelize
I have two tables, locations and sensors. Each entry in sensors has a foreign key pointing to locations. Using Sequelize, how do I get all entries from locations and total count of entries in sensors ...
- 5,082
29
votes
8
answers
52k
views
How to set sql_mode in my.cnf in MySQL 8?
I'm running MySQL 8.0.11 community version. I need to set sql_mode to exclude ONLY_FULL_GROUP_BY in my.cnf so that it's restart safe. I tried the following variants:
sql_mode= STRICT_TRANS_TABLES,...
- 621