mysqlのmy.cnf(STRICT_TRANS_TABLES)

Movable Tytp は 6.02、DBD::mysql は4.026、に、してある。
複数のサーバーで稼働させているのだが、1台だけ、記事の更新ができなかった。

Failed to execute
INSERT INTO mt_entry_meta (
entry_meta_entry_id, entry_meta_type, entry_meta_vchar, entry_meta_vchar_idx, entry_meta_vdatetime, entry_meta_vdatetime_idx, entry_meta_vinteger, entry_meta_vinteger_idx, entry_meta_vfloat, entry_meta_vfloat_idx, entry_meta_vblob, entry_meta_vclob
) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
with entry_id, type, vchar, vchar_idx, vdatetime, vdatetime_idx, vinteger, vinteger_idx, vfloat, vfloat_idx, vblob, vclob: DBD::mysql::st execute failed: Incorrect integer value: '' for column 'entry_meta_vinteger'

というメッセージが表示されてしまうのだな。

とりあえず、
Failed to execute INSERT INTO DBD::mysql::st execute failed: Incorrect integer value
をキーワードにしてググると...いくつか記事が表示されましたっ

その中に共通していたのが、my.cnfの修正。

何でも、「STRICT_TRANS_TABLES」を効かないようにする、らしい。

で。

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
sql_mode=NO_ENGINE_SUBSTITUTION

と、mycnf を修正し、MySQLを再起動してみたのですな。

はい、うまくいきましたっ

他のマシンではどうなのだろう?
テストはあまりやりたくない。

トラックバック(0)

このブログ記事を参照しているブログ一覧: mysqlのmy.cnf(STRICT_TRANS_TABLES)

このブログ記事に対するトラックバックURL: http://www.kumecchi.net/mt/mt-tb.cgi/2139

コメントする

QRコード

QRコード対応携帯からアクセスできます
QRコード対応携帯からアクセスできます  
Creative Commons License
このブログのライセンスは クリエイティブ・コモンズライセンス.
Powered by Movable Type 7.0.1

Yahoo!ブログの記事


Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:23: parser error : Opening and ending tag mismatch: meta line 20 and head in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </head> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:34: parser error : xmlParseEntityRef: no name in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): �っと便利に<a href="https://account.edit.yahoo.co.jp/registration?.src=shp& in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:58: parser error : Opening and ending tag mismatch: br line 20 and p in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </p> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:59: parser error : Opening and ending tag mismatch: br line 20 and section in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </section> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:68: parser error : Opening and ending tag mismatch: img line 20 and a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): cialproducts/blog/promo/close/img/img_ameba.png" alt="アメーバブログ"></a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:69: parser error : Opening and ending tag mismatch: a line 20 and dt in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dt> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:72: parser error : Opening and ending tag mismatch: dt line 20 and dl in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dl> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:74: parser error : Opening and ending tag mismatch: img line 20 and a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): oducts/blog/promo/close/img/img_livedoor.png" alt="ライブドアブログ"></a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:75: parser error : Opening and ending tag mismatch: a line 20 and dt in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dt> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:78: parser error : Opening and ending tag mismatch: dt line 20 and dl in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dl> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:80: parser error : Opening and ending tag mismatch: img line 20 and a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): es/socialproducts/blog/promo/close/img/img_seesaa.png" alt="Seesaaブログ"></a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:81: parser error : Opening and ending tag mismatch: a line 20 and dt in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dt> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:84: parser error : Opening and ending tag mismatch: dt line 20 and dl in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dl> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:86: parser error : Opening and ending tag mismatch: img line 20 and a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): socialproducts/blog/promo/close/img/img_hatena.png" alt="はてなブログ"></a in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:87: parser error : Opening and ending tag mismatch: a line 20 and dt in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dt> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:90: parser error : Opening and ending tag mismatch: dt line 20 and dl in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </dl> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:91: parser error : Opening and ending tag mismatch: dl line 20 and div in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </div> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:93: parser error : Opening and ending tag mismatch: dl line 20 and section in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </section> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:102: parser error : Entity 'nbsp' not defined in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): a href="https://privacy.yahoo.co.jp/" target="_top">プライバシー</a>&nbsp; in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:102: parser error : Entity 'nbsp' not defined in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ="https://privacy.yahoo.co.jp/" target="_top">プライバシー</a>&nbsp;-&nbsp in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:103: parser error : Entity 'nbsp' not defined in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): https://about.yahoo.co.jp/docs/info/terms/" target="_top">利用規約</a>&nbsp; in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:103: parser error : Entity 'nbsp' not defined in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): //about.yahoo.co.jp/docs/info/terms/" target="_top">利用規約</a>&nbsp;-&nbsp in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:104: parser error : Entity 'nbsp' not defined in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): /info/mediastatement/" target="_top">メディアステートメント</a>&nbsp; in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:104: parser error : Entity 'nbsp' not defined in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): mediastatement/" target="_top">メディアステートメント</a>&nbsp;-&nbsp in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:109: parser error : Opening and ending tag mismatch: br line 20 and footer in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </footer> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:111: parser error : Opening and ending tag mismatch: footer line 20 and body in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </body> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:113: parser error : Opening and ending tag mismatch: dl line 20 and html in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): </html> in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): http://blogs.yahoo.co.jp/isoriehermuk/rss.xml:115: parser error : EndTag: '</' not found in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Warning: simplexml_load_file(): ^ in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 681

Notice: Trying to get property 'entry' of non-object in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 687

Warning: Invalid argument supplied for foreach() in /Users/kumecchi/weblog/2014/02/mysqlmycnfstrict-trans-tables.php on line 690

アーカイブ