{"id":579,"date":"2011-03-25T22:07:17","date_gmt":"2011-03-25T14:07:17","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=579"},"modified":"2011-03-25T22:07:17","modified_gmt":"2011-03-25T14:07:17","slug":"incorrect-datetime-value-error-dalam-mysql","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/incorrect-datetime-value-error-dalam-mysql\/","title":{"rendered":"&#8220;Incorrect datetime value:&#8221; error dalam mysql"},"content":{"rendered":"<p>Sekiranya error &#8220;<strong>Incorrect datetime value: <\/strong>&#8221; diperolehi semasa proses masukkan data &#8220;<strong>insert into<\/strong>&#8220;, error ini adalah kerana restricted mode ke atas database yang tidak membenarkan nilai NULL dimasukkan. Bagi mengatasi permasalahan ini, cuba ikuti langkah-langkah di bawah.<\/p>\n<p>1. Taip <strong>SELECT @@SESSION.sql_mode;<\/strong> atau <strong>SELECT @@global.sql_mode;<\/strong> pada mysql browser.<br \/>\n<em>Arahan ini bagi mendapatkan konfigurasi pangkalan data mysql.<\/em><\/p>\n<p>2. Sekiranya keputusan yang diperolehi ialah &#8220;<strong>STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER<\/strong> &#8230;.&#8221; maka perkara ini yang menyebabkan terjadinya error tersebut.<\/p>\n<p>3. Taip pada mysql browser &#8220;<strong>set global sql_mode=&#8221;;<\/strong>&#8221;<br \/>\n<em>Arahan ini akan menukarkan nilai sql_mode kepada NULL<\/em><\/p>\n<p>4. Buka fail my.ini (..MySQL\/MySQL Server X.x\/<strong>my.ini<\/strong>).<\/p>\n<p>5. Cari (<strong>sql-mode=&#8221;STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION&#8221;<\/strong>) dan tambah <strong>#<\/strong> pada awal baris bagi menjadikan baris ini tidak aktif.<\/p>\n<p>6. Tambah baris baru dengan &#8220;<strong>sql_mode=&#8221;<\/strong>&#8220;.<\/p>\n<p>7. <strong>Restart <\/strong>MySQL.<\/p>\n<p>Sepatutnya tiada error seperti sebelum ini.<\/p>\n<p>Selamat mencuba.<\/p>\n<p><a href=\"http:\/\/rais.my\">rais.my<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sekiranya error &#8220;Incorrect datetime value: &#8221; diperolehi semasa proses masukkan data &#8220;insert into&#8220;, error ini adalah kerana restricted mode ke atas database yang tidak membenarkan nilai NULL dimasukkan. Bagi mengatasi permasalahan ini, cuba ikuti langkah-langkah di bawah. 1. Taip SELECT @@SESSION.sql_mode; atau SELECT @@global.sql_mode; pada mysql browser. Arahan ini bagi mendapatkan konfigurasi pangkalan data mysql. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cybocfi_hide_featured_image":"","footnotes":""},"categories":[274,74],"tags":[383,385,661,384],"class_list":["post-579","post","type-post","status-publish","format-standard","hentry","category-database","category-mysql","tag-incorrect-datetime-value","tag-my-ini","tag-mysql","tag-sql_mode"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/comments?post=579"}],"version-history":[{"count":1,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/579\/revisions"}],"predecessor-version":[{"id":580,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/579\/revisions\/580"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}