java.sql.SQLSyntaxErrorException: Error preparing query: Unknown column 'TMP.alerte_code' in 'field list'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Régis Augui, 1 year ago
Error preparing query: Unknown column 'TMP.alerte_code' in 'field list'
via GitHub by StuAtGit
, 1 year ago
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '5 on duplicate key update counter = counter +' at line 1 Query is : insert into test_jdbi_bug (id, data, counters) values (1,'test',1)5 on duplicate key update counter = counter +
via GitHub by cailibiao
, 2 months ago
Error preparing query: Unknown column 'dollar_balance' in 'field list' If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')
via GitHub by crombiecrunch
, 6 months ago
Error preparing query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1 > [21:13:25] [Server thread/INFO] [STDERR]: [br.net.fabiozumbi12.redprotect.WorldMySQLRegionMa
via GitHub by crombiecrunch
, 7 months ago
Error preparing query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1 WHERE world = ?' at line 1 > [19:22:12] [Server thread/INFO] [STDERR]: [br.net.fabiozumbi12.redprotect.WorldMySQLRegionMa
via GitHub by ajacques
, 1 year ago
Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Zipkin.a.endpoint_service_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 11/3
java.sql.SQLSyntaxErrorException: Error preparing query: Unknown column 'TMP.alerte_code' in 'field list'
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.prepare(AbstractQueryProtocol.java:152)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.prepare(MariaDbServerPreparedStatement.java:99)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.(MariaDbServerPreparedStatement.java:87)
at org.mariadb.jdbc.MariaDbConnection.internalPrepareStatement(MariaDbConnection.java:375)
at org.rfa.test.FirstExample.main(FirstExample.java:30)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.