{"id":34498,"date":"2024-03-28T15:26:39","date_gmt":"2024-03-28T15:26:39","guid":{"rendered":"https:\/\/10web.io\/blog\/?p=34498"},"modified":"2024-03-28T15:26:40","modified_gmt":"2024-03-28T15:26:40","slug":"how-to-fix-mysql-error-code-1055","status":"publish","type":"post","link":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/","title":{"rendered":"How to Fix MySQL Error Code 1055"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">MySQL Error Code 1055 is about the SQL mode `ONLY_FULL_GROUP_BY` being enabled, which affects how GROUP BY clauses are interpreted and executed. Let&#8217;s unravel this error together, exploring its variations, underlying causes, and, most importantly, how to fix it.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Understanding the error<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The MySQL Error Code 1055 is triggered under specific circumstances involving the SELECT statement and GROUP BY clause. This requirement aims to prevent ambiguous results from queries that group data together.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In practical terms, when you group data in a query, MySQL needs to know how to handle multiple rows that fall under the same group for columns not included in the GROUP BY clause. The `ONLY_FULL_GROUP_BY` mode is MySQL&#8217;s way of ensuring that any grouped query is clear and unambiguous by enforcing these rules.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">So, when you encounter Error 1055, MySQL is essentially asking for clarification: &#8220;For the columns you&#8217;re selecting, either tell me exactly how to group them (by including them in the GROUP BY clause) or tell me how to aggregate the data (by using functions like COUNT(), SUM(), etc.).&#8221;\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Understanding the role of ONLY_FULL_GROUP_BY<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">This mode plays a critical role in ensuring the accuracy and reliability of data retrieval operations, especially in complex database environments.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">When `ONLY_FULL_GROUP_BY` is enabled, MySQL enforces a clear rule: If a column appears in the SELECT list of a query that includes a GROUP BY clause, that column must satisfy one of the following criteria:<\/span><\/p>\n<p><b>Be an aggregate function<\/b><span style=\"font-weight: 400;\">: The column is used within an aggregate function like COUNT(), SUM(), MAX(), etc. These functions summarize data from multiple rows grouped together, producing a single result per group.<\/span><\/p>\n<p><b>Be functionally dependent on GROUP BY columns<\/b><span style=\"font-weight: 400;\">: The column is functionally dependent on the columns listed in the GROUP BY clause. Functional dependence means that the value of one column (the functionally dependent column) is uniquely determined by the other column or columns (the columns in the GROUP BY clause). In simpler terms, for any given value(s) of the GROUP BY column(s), there is exactly one possible value of the functionally dependent column.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Variations of the error<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Here are some ways this error might present itself:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">MySQL Error Code 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column &#8216;database.table.column&#8217; which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SQL Error (1055): Expression of SELECT list is not in GROUP BY clause<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SQLSTATE[42000]: Syntax error or access violation: 1055<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">Reasons why this error occurs<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">MySQL Error Code 1055 occurs primarily due to the SQL mode `ONLY_FULL_GROUP_BY` being enabled, which demands stricter rules for queries using the GROUP BY clause. Here are the key reasons:<\/span><\/p>\n<p><b>SQL mode `ONLY_FULL_GROUP_BY` enabled<\/b><span style=\"font-weight: 400;\">: This mode requires that all SELECT list expressions appear in the GROUP BY clause unless they are aggregated. It&#8217;s designed to prevent ambiguous query results.<\/span><\/p>\n<p><b>Non-aggregated columns in SELECT list<\/b><span style=\"font-weight: 400;\">: If your SELECT list includes columns not wrapped in aggregate functions (like SUM, AVG, MIN, MAX, COUNT) and these columns are not part of the GROUP BY clause, MySQL flags this as an error under `ONLY_FULL_GROUP_BY`.<\/span><\/p>\n<p><b>Functional dependence<\/b><span style=\"font-weight: 400;\">: MySQL expects columns in the SELECT list that are not aggregated to be functionally dependent on the GROUP BY clause. Functional dependence means that one column uniquely determines another column. If this relationship isn&#8217;t met, MySQL throws Error 1055.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Fixing MySQL Error Code 1055<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Now that we\u2019ve looked at what the error code 1055 means and what causes the error, let\u2019s take a look at a few ways to fix this error. <\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Analyze the query<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">The initial step to resolving MySQL Error Code 1055 involves analyzing the query that triggers this error. This examination is aimed at pinpointing the columns listed in the SELECT clause that are neither encompassed in the GROUP BY clause nor aggregated. This discrepancy is the core of the issue, as MySQL, under the ONLY_FULL_GROUP_BY SQL mode, mandates that any column referenced in the SELECT list, and not an aggregate function, must be declared in the GROUP BY clause to guarantee unambiguous results.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Adjust your query<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">To correct this error, adjustments to the query are required. The modifications focus on aligning with the ONLY_FULL_GROUP_BY stipulations. Below are two principal strategies to achieve compliance:<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Include all non-aggregated columns in GROUP BY<\/span><\/h4>\n<p><b>Comprehensive inclusion<\/b><span style=\"font-weight: 400;\">: The most straightforward method is to ensure every column appearing in the SELECT list, which isn&#8217;t part of an aggregate function (like COUNT, AVG, SUM, etc.), is included in the GROUP BY clause. This approach aligns with the SQL standard for GROUP BY operations, guaranteeing that each row in the result set is uniquely identified by the columns specified in the GROUP BY clause.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Example<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Imagine you have a database table named `sales` with columns `date`, `region`, and `amount`. You want to find the total sales amount per region, but your initial query triggers Error 1055.<\/span><\/p>\n<p><strong>Initial Query (Causing Error 1055)<\/strong><\/p>\n<pre>SELECT date, region, SUM(amount)\r\n\r\nFROM sales\r\n\r\nGROUP BY region;<\/pre>\n<p><span style=\"font-weight: 400;\">This query causes an error because `date` is not included in the GROUP BY clause and is not used within an aggregate function.<\/span><\/p>\n<p><b>Modified query (Resolving Error 1055)<\/b><\/p>\n<pre>SELECT date, region, SUM(amount)\r\n\r\nFROM sales\r\n\r\nGROUP BY date, region;<\/pre>\n<p><span style=\"font-weight: 400;\">By including both `date` and `region` in the GROUP BY clause, the query complies with the `ONLY_FULL_GROUP_BY` SQL mode, thus resolving the error.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Use aggregate functions for non-grouped columns<\/span><\/h4>\n<p><b>Strategic aggregation<\/b><span style=\"font-weight: 400;\">: In scenarios where including all non-aggregated columns in the GROUP BY clause is impractical or diverges from the query&#8217;s intent, employing aggregate functions on the non-grouped columns is an effective alternative. This method consolidates non-unique data into meaningful aggregated results, circumventing the ONLY_FULL_GROUP_BY restrictions.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Example<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Let&#8217;s use the same `sales` table. Suppose you want to select the region and the latest date of sale, but grouping by `region` only. Applying an aggregate function to the `date` column can achieve this without including it in the GROUP BY clause.<\/span><\/p>\n<p><b>Initial query (Causing Error 1055)<\/b><\/p>\n<pre>SELECT region, date\r\n\r\nFROM sales\r\n\r\nGROUP BY region;<\/pre>\n<p><span style=\"font-weight: 400;\">This query will fail because `date` is neither in an aggregate function nor in the GROUP BY clause.<\/span><\/p>\n<p><b>Modified query (Resolving Error 1055)<\/b><\/p>\n<pre>SELECT region, MAX(date) AS latest_sale_date\r\n\r\nFROM sales\r\n\r\nGROUP BY region;<\/pre>\n<p><span style=\"font-weight: 400;\">In this modified query, the `MAX()` function is used to aggregate the `date` column, thus selecting the latest date of sale for each region. This resolves the error by complying with the `ONLY_FULL_GROUP_BY` requirements, as `region` is the only column in the GROUP BY clause, and `date` is used within an aggregate function.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Disable `ONLY_FULL_GROUP_BY` SQL mode<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Disabling the `ONLY_FULL_GROUP_BY` mode in MySQL can be considered a last resort when query logic demands the inclusion of columns that cannot be feasibly added to the GROUP BY clause or aggregated. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Disabling this mode might resolve immediate issues like MySQL Error Code 1055, but it introduces the risk of generating non-deterministic query results. This non-determinism can lead to queries returning different results under different conditions, potentially leading to data inconsistencies and difficult-to-debug issues in production environments.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">How to disable `ONLY_FULL_GROUP_BY`<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">To temporarily disable `ONLY_FULL_GROUP_BY` for the current database session, which means the change only lasts for the duration of the connection, use the following SQL command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">SET sql_mode = (SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));<\/span><\/pre>\n<p><span style=\"font-weight: 400;\">This command selectively removes `ONLY_FULL_GROUP_BY` from the session&#8217;s SQL modes without affecting the global SQL mode configuration or impacting other database sessions.<\/span><\/p>\n<p><b>Globally<\/b><\/p>\n<p><span style=\"font-weight: 400;\">For a more permanent solution that affects all new connections to the MySQL server, you can change the global SQL mode setting with:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));<\/span><\/pre>\n<p><span style=\"font-weight: 400;\">Executing this command alters the server-wide SQL mode setting by removing `ONLY_FULL_GROUP_BY`, thereby applying the change to all new connections post-execution. It&#8217;s crucial to note that this does not affect existing connections, and a server restart or new connections are required to apply the changes globally.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Best practices for managing MySQL queries<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">When dealing with MySQL queries, especially in contexts involving complex grouping and aggregate functions, it&#8217;s crucial to adopt a set of best practices. These practices not only ensure the efficiency and correctness of your queries but also help in maintaining the integrity and reliability of your data, particularly when you&#8217;re navigating around constraints like the `ONLY_FULL_GROUP_BY` SQL mode.<\/span><\/p>\n<p><b>Understand data relationships<\/b><span style=\"font-weight: 400;\">: Have a deep understanding of the relationships and dependencies between the columns in your database. Knowing how data is interconnected helps in constructing more effective queries and avoiding errors or unexpected results.<\/span><\/p>\n<p><b>Schema familiarity<\/b><span style=\"font-weight: 400;\">: Familiarize yourself with the database schema regularly. This familiarity aids in recognizing which columns to group by and which ones can be effectively used in aggregate functions.<\/span><\/p>\n<p><b>Strategic application<\/b><span style=\"font-weight: 400;\">: Apply aggregate functions (such as `SUM()`, `AVG()`, `COUNT()`, etc.) thoughtfully to achieve specific analytical goals. These functions are powerful tools for summarizing and analyzing data, but when used inappropriately, they can lead to misleading results.<\/span><\/p>\n<p><b>Avoid over-aggregation<\/b><span style=\"font-weight: 400;\">: Be cautious of overusing aggregate functions on large datasets without proper grouping, as this can cause performance issues and potentially obscure the insights you&#8217;re trying to glean from the data.<\/span><\/p>\n<p><b>Ensure expected results<\/b><span style=\"font-weight: 400;\">: After making adjustments to your queries\u2014such as disabling `ONLY_FULL_GROUP_BY` or altering the structure of your queries\u2014it&#8217;s imperative to test these changes extensively. This testing ensures that the queries return the expected results and that data integrity is maintained.<\/span><\/p>\n<p><b>Performance evaluation<\/b><span style=\"font-weight: 400;\">: Testing isn&#8217;t just about correctness; it&#8217;s also about performance. Evaluate the impact of your queries on database performance, especially when working with large datasets or complex aggregations.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Closing thoughts<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">We\u2019ve addressed how to fix MySQL Error Code 1055, focusing on adapting queries to comply with `ONLY_FULL_GROUP_BY` or, as a last resort, disabling this mode. We highlighted best practices for ensuring data integrity and query accuracy, emphasizing the importance of understanding and working within SQL standards to prevent issues and ensure reliable database operations.<\/span><\/p>\n<p><span><div class=\"website_creation_outer\">\n\t<div class=\"content_holder\">\n\t\t<h4>Accelerate your WordPress website creation with AI<\/h4>\n\t\t<p>Create a custom WordPress website tailored to your business needs 10X faster with 10Web AI Website Builder.<\/p>\n\t<\/div>\n\t<div class=\"cta_holder\">\n\t\t<div class=\"btn\">\n\t\t\t<a href=\"https:\/\/10web.io\/ai-website-builder\/\">\n\t\t\t\tGenerate Your Website\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div class=\"subtitle\">\n\t\t\t<img decoding=\"async\" width=\"18px\" height=\"18px\" src=\"https:\/\/10web.io\/blog\/wp-content\/themes\/10web-blog\/images\/shortcodes\/icon_check.svg\"\/>\n\t\t\tNo credit card required\n\t\t<\/div>\n\t<\/div>\n<\/div>\n<\/span><br \/>\n \r\n<style>\r\n  #ctablocks_scrollbox-with-icon_89{\r\n            color: #ffffff;\r\n    border-radius: 6px;\r\n  }\r\n\r\n  #ctablocks_scrollbox-with-icon_89 p{\r\n    color: #ffffff;\r\n  }\r\n  #ctablocks_scrollbox-with-icon_89 .button{\r\n          background-color: rgb(51,57,241);\r\n        color: #ffffff;\r\n    border-color: #3339f1 !important;\r\n  }\r\n  #ctablocks_scrollbox-with-icon_89 .button:hover{\r\n    background: rgba(51,57,241,0.8);\r\n    color: #ffffff;\r\n    opacity: 1;\r\n  }\r\n  #ctablocks_scrollbox-with-icon_89.ctablocks_container {\r\n    left: 100%;\r\n  }\r\n  @media screen and (max-width: 1300px) {\r\n      #ctablocks_scrollbox-with-icon_89.ctablocks_container {\r\n          left: 0;\r\n          margin: 0 auto;\r\n      }\r\n  }\r\n  #ctablocks_scrollbox-with-icon_89 .ctablocks_content {\r\n      background-color: #000000;\r\n  }\r\n<\/style>\r\n<div id=\"ctablocks_scrollbox-with-icon_89\" class=\"ctablocks_container scrollbox-with-icon_type\r\n      \">\r\n\r\n  <div class=\"ctablocks_content clear\">\r\n    <div class=\"ctablocks_content_info\">\r\n              <h4>Say goodbye to website errors<\/h4>\r\n        <h4 class=\"mobile-title\">Fix all the website errors in one click<\/h4>\r\n              <p>Migrate your website to the world's best Managed WordPress Hosting.<\/p>\r\n          <\/div>\r\n    <div class=\"ctablocks_content_button\">\r\n              <a href=\"https:\/\/10web.io\/ai-website-builder\/\" class=\"button\" data-gtag=\"sign-up-blog\" data-buttontype=\"sign-up\" data-gtag=\"cta-89\" data-buttontype=\"cta-scrollbox-with-icon\"\r\n\t        >Migrate For Free<\/a>\r\n            \r\n    <\/div>\r\n  <\/div>\r\n    <span class=\"close_ctablocks\">\r\n      <img decoding=\"async\" class=\"close-icon\" src=\"https:\/\/10web.io\/blog\/wp-content\/plugins\/cta-blocks\/assets\/images\/close_w.svg\" class=\"close\">\r\n      <img decoding=\"async\" class=\"floating-icon\" src=\"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/04\/Info-icon_Blog.png\" alt=\"Say goodbye to website errors\" title=\"Say goodbye to website errors\">\r\n<!--      <img decoding=\"async\" class=\"arrow-icon white\" src=\"\/cta-blocks\/assets\/images\/arrow-icon.svg\" class=\"close\">\r\n-->      <img decoding=\"async\" class=\"arrow-icon purple\" src=\"https:\/\/10web.io\/blog\/wp-content\/plugins\/cta-blocks\/assets\/images\/arrow-icon-purple.svg\" class=\"close\">\r\n  <\/span>\r\n<\/div>\r\n<br \/>\n <\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Error Code 1055 is about the SQL mode `ONLY_FULL_GROUP_BY` being enabled, which affects how GROUP BY clauses are interpreted and executed. Let&#8217;s unravel this error together, exploring its variations, underlying causes, and, most importantly, how to fix it. Understanding the error The MySQL Error Code 1055 is triggered under specific circumstances involving the SELECT statement and GROUP BY clause&#8230;.<\/p>\n","protected":false},"author":39,"featured_media":34504,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"two_page_speed":[],"footnotes":"","tenweb_blog_toc":"<ul><li><a href=\"#understanding-the-error\">Understanding the error<\/a><li><a href=\"#understanding-the-role-of-only_full_group_by\">Understanding the role of ONLY_FULL_GROUP_BY<\/a><ul><li><a href=\"#variations-of-the-error\">Variations of the error<\/a><\/li><\/ul><li><a href=\"#reasons-why-this-error-occurs\">Reasons why this error occurs<\/a><li><a href=\"#fixing-mysql-error-code-1055\">Fixing MySQL Error Code 1055<\/a><ul><li><a href=\"#analyze-the-query\">Analyze the query<\/a><li><a href=\"#adjust-your-query\">Adjust your query<\/a><li><a href=\"#disable-only_full_group_by-sql-mode\">Disable `ONLY_FULL_GROUP_BY` SQL mode<\/a><\/li><\/ul><li><a href=\"#best-practices-for-managing-mysql-queries\">Best practices for managing MySQL queries<\/a><li><a href=\"#closing-thoughts\">Closing thoughts<\/a><\/li><\/ul>","tenweb_blog_competitor_type":"","tenweb_blog_competitor_names":"","tenweb_blog_twb_version":0,"tenweb_blog_type":""},"categories":[503],"tags":[],"class_list":["post-34498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-errors"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.0 (Yoast SEO v23.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Fix MySQL Error Code 1055 - 10Web<\/title>\n<meta name=\"description\" content=\"Explore MySQL Error 1055 and the impact of SQL mode `ONLY_FULL_GROUP_BY`. Learn about its variations, causes, and solutions on our website.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix MySQL Error Code 1055\" \/>\n<meta property=\"og:description\" content=\"Explore MySQL Error 1055 and the impact of SQL mode `ONLY_FULL_GROUP_BY`. Learn about its variations, causes, and solutions on our website.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/\" \/>\n<meta property=\"og:site_name\" content=\"10Web - Build &amp; Host Your WordPress Website\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/10Web.io\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T15:26:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T15:26:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/03\/How-to-Fix-MySQL-Error-Code-1055.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1560\" \/>\n\t<meta property=\"og:image:height\" content=\"875\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sergey Markosyan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@10Web_io\" \/>\n<meta name=\"twitter:site\" content=\"@10Web_io\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sergey Markosyan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Fix MySQL Error Code 1055 - 10Web","description":"Explore MySQL Error 1055 and the impact of SQL mode `ONLY_FULL_GROUP_BY`. Learn about its variations, causes, and solutions on our website.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix MySQL Error Code 1055","og_description":"Explore MySQL Error 1055 and the impact of SQL mode `ONLY_FULL_GROUP_BY`. Learn about its variations, causes, and solutions on our website.","og_url":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/","og_site_name":"10Web - Build &amp; Host Your WordPress Website","article_publisher":"https:\/\/www.facebook.com\/10Web.io\/","article_published_time":"2024-03-28T15:26:39+00:00","article_modified_time":"2024-03-28T15:26:40+00:00","og_image":[{"width":1560,"height":875,"url":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/03\/How-to-Fix-MySQL-Error-Code-1055.jpg","type":"image\/jpeg"}],"author":"Sergey Markosyan","twitter_card":"summary_large_image","twitter_creator":"@10Web_io","twitter_site":"@10Web_io","twitter_misc":{"Written by":"Sergey Markosyan","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#article","isPartOf":{"@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/"},"author":{"name":"Sergey Markosyan","@id":"https:\/\/10web.io\/blog\/#\/schema\/person\/c8350d9b5223c607a2b79f6d4b8a52d6"},"headline":"How to Fix MySQL Error Code 1055","datePublished":"2024-03-28T15:26:39+00:00","dateModified":"2024-03-28T15:26:40+00:00","mainEntityOfPage":{"@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/"},"wordCount":1653,"commentCount":0,"publisher":{"@id":"https:\/\/10web.io\/blog\/#organization"},"image":{"@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#primaryimage"},"thumbnailUrl":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/03\/How-to-Fix-MySQL-Error-Code-1055.jpg","articleSection":["SQL Errors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/","url":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/","name":"How to Fix MySQL Error Code 1055 - 10Web","isPartOf":{"@id":"https:\/\/10web.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#primaryimage"},"image":{"@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#primaryimage"},"thumbnailUrl":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/03\/How-to-Fix-MySQL-Error-Code-1055.jpg","datePublished":"2024-03-28T15:26:39+00:00","dateModified":"2024-03-28T15:26:40+00:00","description":"Explore MySQL Error 1055 and the impact of SQL mode `ONLY_FULL_GROUP_BY`. Learn about its variations, causes, and solutions on our website.","breadcrumb":{"@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#primaryimage","url":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/03\/How-to-Fix-MySQL-Error-Code-1055.jpg","contentUrl":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2024\/03\/How-to-Fix-MySQL-Error-Code-1055.jpg","width":1560,"height":875,"caption":"How to Fix MySQL Error Code 1055"},{"@type":"BreadcrumbList","@id":"https:\/\/10web.io\/blog\/how-to-fix-mysql-error-code-1055\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/10web.io\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Fix MySQL Error Code 1055"}]},{"@type":"WebSite","@id":"https:\/\/10web.io\/blog\/#website","url":"https:\/\/10web.io\/blog\/","name":"10Web Blog - Build & Host Your WordPress Website","description":"10Web is an All-in-One Website Building Platform, offering Managed WordPress Hosting on Google Cloud, Beautiful Templates, Premium Plugins and Services.","publisher":{"@id":"https:\/\/10web.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/10web.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/10web.io\/blog\/#organization","name":"10Web","url":"https:\/\/10web.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/10web.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2025\/04\/Logo-768x686-1.png","contentUrl":"https:\/\/10web.io\/blog\/wp-content\/uploads\/sites\/2\/2025\/04\/Logo-768x686-1.png","width":768,"height":686,"caption":"10Web"},"image":{"@id":"https:\/\/10web.io\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/10Web.io\/","https:\/\/x.com\/10Web_io","https:\/\/www.instagram.com\/10web.io\/","https:\/\/www.linkedin.com\/company\/10web\/mycompany\/","https:\/\/www.youtube.com\/c\/10Web"]},{"@type":"Person","@id":"https:\/\/10web.io\/blog\/#\/schema\/person\/c8350d9b5223c607a2b79f6d4b8a52d6","name":"Sergey Markosyan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/10web.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5dee1e06f3b02cc0b043d015850db7ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5dee1e06f3b02cc0b043d015850db7ca?s=96&d=mm&r=g","caption":"Sergey Markosyan"},"description":"Sergey Markosyan is the Co-Founder and CTO at 10Web. He leads the development of the 10Web platform, identifies and solves problems in the development process across the organization a true sensei for the engineering team.","sameAs":["https:\/\/www.linkedin.com\/in\/sergey-markosyan\/"],"url":"https:\/\/10web.io\/blog\/author\/sergey\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/posts\/34498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/comments?post=34498"}],"version-history":[{"count":0,"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/posts\/34498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/media\/34504"}],"wp:attachment":[{"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/media?parent=34498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/categories?post=34498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/10web.io\/blog\/wp-json\/wp\/v2\/tags?post=34498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}