{"id":9217,"date":"2024-09-26T06:31:03","date_gmt":"2024-09-26T06:31:03","guid":{"rendered":"https:\/\/www.infinitivehost.com\/knowledge-base\/?p=9217"},"modified":"2024-09-26T07:50:40","modified_gmt":"2024-09-26T07:50:40","slug":"fix-vtiger-installation-error-with-mysql-server-settings","status":"publish","type":"post","link":"https:\/\/www.infinitivehost.com\/knowledge-base\/fix-vtiger-installation-error-with-mysql-server-settings\/","title":{"rendered":"Fix VTiger Installation Error with MySQL Server Settings"},"content":{"rendered":"<div class='epvc-post-count'><span class='epvc-eye'><\/span>  <span class=\"epvc-count\"> 1,825<\/span><span class='epvc-label'> Views<\/span><\/div>\n<p>The error message you&#8217;re seeing indicates that VTiger requires MySQL to be configured with specific SQL modes during Vtiger installation or operation. To fix this issue, you need to update the MySQL configuration to set the appropriate SQL modes.<\/p>\n\n\n\n<p>Here\u2019s how you can resolve the error:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Steps to Configure MySQL SQL Mode:<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Locate MySQL Configuration File<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On Linux: The file is usually located at <code><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">\/etc\/mysql\/my.cnf<\/mark><\/code> or <code><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">\/etc\/my.cnf<\/mark><\/code>.<\/li>\n\n\n\n<li>On Windows: You can find it in the MySQL installation directory, often under <code><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">C:\\ProgramData\\MySQL\\MySQL Server X.Y\\my.ini<\/mark><\/code>.<\/li>\n<\/ul>\n\n\n\n<p>     2. <strong>Edit the Configuration File<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the configuration file in a text editor.<\/li>\n\n\n\n<li>Look for the line starting with <code><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">sql_mode<\/mark><\/code>. If it doesn\u2019t exist, you can add it under the <code><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">[mysqld]<\/mark><\/code> section.<\/li>\n<\/ul>\n\n\n\n<p>    3. <strong>Set the SQL Mode<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Modify or add the line as follows:<br><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">bash sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION<\/mark><\/code><\/li>\n\n\n\n<li>Save and close the file.<\/li>\n<\/ul>\n\n\n\n<p>    4. <strong>Restart MySQL Service<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On Linux, restart MySQL with:<br><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">bash sudo systemctl restart mysql<\/mark><\/code><\/li>\n\n\n\n<li>On Windows, you can restart MySQL via the MySQL Notifier or the Services app.<\/li>\n<\/ul>\n\n\n\n<p>    5. <strong>Verify the SQL Mode<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After restarting, you can verify the SQL mode by logging into MySQL and running the following command:<br><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">sql SELECT @@sql_mode;<\/mark><\/code><\/li>\n<\/ul>\n\n\n\n<p>This should configure your MySQL server as required by VTiger and resolve the installation issue.<\/p>\n\n\n\n<p><strong>Conclusion<\/strong><\/p>\n\n\n\n<p>The error message that constantly appears on the screen specifies that VTiger needs MySQL to be organized with particular SQL modes at the time of Vtiger operation or installation. To resolve this problem, you just need to update the MySQL configuration to easily set the correct SQL modes along with the <a href=\"https:\/\/www.infinitivehost.com\/managed-vtiger-solutions\"><mark style=\"background-color:#8ed1fc\" class=\"has-inline-color\"><strong>best Vtiger hosting solutions<\/strong><\/mark><\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1,825 Views The error message you&#8217;re seeing indicates that VTiger requires MySQL to be configured with specific SQL modes during Vtiger installation or operation. To fix this issue, you need to update the MySQL configuration to set the appropriate SQL modes. Here\u2019s how you can resolve the error: Steps to Configure MySQL SQL Mode: 2. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[204],"tags":[],"class_list":["post-9217","post","type-post","status-publish","format-standard","hentry","category-vtiger-solutions"],"_links":{"self":[{"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/posts\/9217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/comments?post=9217"}],"version-history":[{"count":2,"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/posts\/9217\/revisions"}],"predecessor-version":[{"id":9222,"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/posts\/9217\/revisions\/9222"}],"wp:attachment":[{"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=9217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/categories?post=9217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.infinitivehost.com\/knowledge-base\/wp-json\/wp\/v2\/tags?post=9217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}