Zabbix\u3068\u3044\u3046\u306e\u306fLinux\u7528\u306e\u30b7\u30b9\u30c6\u30e0\u7ba1\u7406\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u306f\u5909\u306a\u30a8\u30e9\u30fc\u304c\u305f\u304f\u3055\u3093\u51fa\u3066\u30ed\u30b0\u30a4\u30f3\u3059\u3089 \u307e\u307e\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n
—-
\nError in query [select u.* from users u where u.alias=’guest’ and (u.userid div 100000000000000) in (0) ] [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘div 100000000000000) in (0)’ at line 1]
\n—-<\/p>\n
\u3053\u3093\u306a\u611f\u3058\u3002
\n\u3046\u3093\u3056\u308a\u3057\u306a\u304c\u3089\u3082\u30d1\u30c3\u30c1\u3092\u4f5c\u308a\u307e\u3057\u305f\u306e\u3067\u3001\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u304f\u3066\u3046\u3093\u3056\u308a\u3057\u3066\u3044\u308b\u4eba\u306f\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002<\/p>\n
—-
\n$ diff -ubB \/usr\/share\/zabbix\/include\/db.inc.php.20110218 \/usr\/share\/zabbix\/include\/db.inc.php
\n— \/usr\/share\/zabbix\/include\/db.inc.php.20110218 2011-01-04 01:11:03.000000000 +0900
\n+++ \/usr\/share\/zabbix\/include\/db.inc.php 2011-02-18 17:41:16.590757194 +0900
\n@@ -518,7 +518,7 @@
\n switch($DB_TYPE)
\n {
\n case “MYSQL”:
\n– $result = ‘(‘.$id_name.’ div 100000000000000)’;
\n+ $result = ‘round(‘.$id_name.’ \/ 100000000000000)’;
\n break;
\n case “ORACLE”:
\n $result = ‘round(‘.$id_name.’\/100000000000000)’;
\n—-<\/p>\n","protected":false},"excerpt":{"rendered":"
Zabbix\u3068\u3044\u3046\u306e\u306fLinux\u7528\u306e\u30b7\u30b9\u30c6\u30e0\u7ba1\u7406\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001MySQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u3088\u3063\u3066\u306f\u5909\u306a\u30a8\u30e9\u30fc\u304c\u305f\u304f\u3055\u3093\u51fa\u3066\u30ed\u30b0\u30a4\u30f3\u3059\u3089 \u307e\u307e\u306a\u308a\u307e\u305b\u3093\u3002 —- Error in query [select u.* … \u7d9a\u304d\u3092\u8aad\u3080 Zabbix\u3067\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u3044\u3068\u304d<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[77],"tags":[41,40],"class_list":["post-772","post","type-post","status-publish","format-standard","hentry","category-computer","tag-mysql","tag-zabbix"],"_links":{"self":[{"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/posts\/772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/comments?post=772"}],"version-history":[{"count":3,"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/posts\/772\/revisions"}],"predecessor-version":[{"id":775,"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/posts\/772\/revisions\/775"}],"wp:attachment":[{"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/media?parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/categories?post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hello.lumiere-couleur.com\/smilkobuta\/wp-json\/wp\/v2\/tags?post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}