{"action":"created","issue":{"url":"https://api.github.com/repos/Bionus/imgbrd-grabber/issues/594","repository_url":"https://api.github.com/repos/Bionus/imgbrd-grabber","labels_url":"https://api.github.com/repos/Bionus/imgbrd-grabber/issues/594/labels{/name}","comments_url":"https://api.github.com/repos/Bionus/imgbrd-grabber/issues/594/comments","events_url":"https://api.github.com/repos/Bionus/imgbrd-grabber/issues/594/events","html_url":"https://github.com/Bionus/imgbrd-grabber/issues/594","id":173486915,"number":594,"title":"Grabber isn't adding image data to local MySQL database(WampServer 2.2e, Gelbooru 0.1.11, Grabber 4.6.0)","user":{"login":"Shir01","id":20873590,"avatar_url":"https://avatars.githubusercontent.com/u/20873590?v=3","gravatar_id":"","url":"https://api.github.com/users/Shir01","html_url":"https://github.com/Shir01","followers_url":"https://api.github.com/users/Shir01/followers","following_url":"https://api.github.com/users/Shir01/following{/other_user}","gists_url":"https://api.github.com/users/Shir01/gists{/gist_id}","starred_url":"https://api.github.com/users/Shir01/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Shir01/subscriptions","organizations_url":"https://api.github.com/users/Shir01/orgs","repos_url":"https://api.github.com/users/Shir01/repos","events_url":"https://api.github.com/users/Shir01/events{/privacy}","received_events_url":"https://api.github.com/users/Shir01/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Bionus/imgbrd-grabber/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/Bionus/imgbrd-grabber/labels/documentation","name":"documentation","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-08-26T16:00:29Z","updated_at":"2016-08-30T01:09:35Z","closed_at":null,"body":"Hi Bionus.\r\n\r\nThough, it seems that the previously mentioned issue(#577) is solved with the update to 4.6.0 version, Grabber is still unable to add images to the local version of gelbooru. To be exact, Grabber is not adding appropriate data(tags, etc) to the database for some reason.\r\nGrabber log shows that there was an error(**[18:09:57.367] line**) while initializing commands and that's all. Here is full log:\r\n\r\n```\r\n[18:09:15.183] New session started.\r\n[18:09:15.183] Software version: 4.6.0.\r\n[18:09:15.183] Path: C:/Program Files (x86)/Grabber\r\n[18:09:15.183] Loading preferences from C:\\Users\\user\\AppData\\Local\\Bionus\\Grabber\\settings.ini\r\n[18:09:15.185] Loading sources\r\n[18:09:15.203] %n source(s) found: behoimi.org (Danbooru), chan.sankakucomplex.com (Sankaku), danbooru.donmai.us (Danbooru (2.0)), derpibooru.org (Booru-on-rails), e621.net (Danbooru), gelbooru.com (Gelbooru (0.2)), hijiribe.donmai.us (Danbooru (2.0)), ichijou.org (Danbooru), idol.sankakucomplex.com (Sankaku), konachan.com (Moebooru), rule34.paheal.net (Shimmie), rule34.xxx (Gelbooru (0.2)), safebooru.org (Gelbooru (0.2)), sonohara.donmai.us (Danbooru (2.0)), tentaclerape.net (Shimmie), www.zerochan.net (Zerochan), yande.re (Moebooru)\r\n[18:09:15.203] It seems that Imgbrd-Grabber hasn't shut down properly last time.\r\n[18:09:16.557] Logging into Gelbooru (gelbooru.com)...\r\n[18:09:17.110] Updating \"New tab\" tab options.\r\n[18:09:17.110] Updating checkboxes.\r\n[18:09:17.155] Fin de l'initialisation.\r\n[18:09:17.350] Logging into Gelbooru (gelbooru.com) finished (success).\r\n[18:09:17.363] Updating \"New tab\" tab options.\r\n[18:09:17.363] Updating checkboxes.\r\n[18:09:49.230] Loading results...\r\n[18:09:49.230] Loading page http://gelbooru.com/index.php?page=dapi&amp;s=post&amp;q=index&amp;limit=20&amp;pid=0&amp;tags=guweiz horns\r\n[18:09:49.329] Parse\r\n[18:09:49.329] Receiving page http://gelbooru.com/index.php?page=dapi&amp;s=post&amp;q=index&amp;limit=20&amp;pid=0&amp;tags=guweiz horns\r\n[18:09:57.348] Batch download started.\r\n[18:09:57.367] Error while initializing commands\r\n[18:09:57.367] SQL execution of \"\"\"\"\r\n[18:09:57.374] Loading images 'http://gelbooru.com/index.php?page=dapi&s=post&q=index&limit=3&pid=0&tags=guweiz horns'\r\n[18:09:57.434] Parse\r\n[18:09:57.439] Received image page 'http://gelbooru.com/index.php?page=dapi&s=post&q=index&limit=3&pid=0&tags=guweiz horns' (3)\r\n[18:09:57.440] All images' urls have been received (3 images).\r\n[18:09:57.446] Downloading images directly.\r\n[18:09:57.450] Loading image from http://gelbooru.com/images/fe/c1/fec14954b4bae044ecb354d3c4f56db1.jpg 1\r\n[18:09:57.651] Image received from http://gelbooru.com/images/fe/c1/fec14954b4bae044ecb354d3c4f56db1.jpg 1\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"1girl\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"animal\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"armor\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"artist_name\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"black_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"blue_ribbon\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.654] Execution of \"\"\"\"\r\n[18:09:57.654] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"blurry\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"breasts\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"broken_cup\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"butterfly\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"chains\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"cleavage\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"clenched_hand\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"closed_mouth\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"cup\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"demon_girl\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"demon_horns\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.655] Execution of \"\"\"\"\r\n[18:09:57.655] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"depth_of_field\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"dragon\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"earrings\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"expressionless\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"floating_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"glasses\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"glowing\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"guweiz\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"highres\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"holding\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"holding_cup\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"horn_ornament\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"horn_ribbon\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"horns\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"insect\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"jewelry\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"long_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"looking_at_viewer\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"medium_breasts\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"monster\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.656] Execution of \"\"\"\"\r\n[18:09:57.656] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"necklace\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"orange_eyes\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"original\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"pendant\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"pink_lips\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"rain\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"ribbon\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"round_glasses\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"sharp_teeth\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"shoulder_pads\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"solo\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"teacup\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"teeth\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"very_long_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"water\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"wind\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.658] Execution of \"\"\"\"\r\n[18:09:57.658] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"yellow-framed_eyewear\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.660] Execution of \"C:\\Windows\\System32\\cmd.exe /C copy \"C:\\00\\fec14954b4bae044ecb354d3c4f56db1.jpg\" \"C:\\w64\\www\\gelbooru\\images\\1\\fec14954b4bae044ecb354d3c4f56db1.jpg\"\"\r\n[18:09:57.680] SQL execution of \"INSERT INTO posts(creation_date, hash, image, height, width, ext, rating, tags, directory, active_date) VALUES(NOW(), \"fec14954b4bae044ecb354d3c4f56db1\", \"fec14954b4bae044ecb354d3c4f56db1.jpg\", 918, 1600, \".jpg\", \"safe\", \" 1girl animal armor artist_name black_hair blue_ribbon blurry breasts broken_cup butterfly chains cleavage clenched_hand closed_mouth cup demon_girl demon_horns depth_of_field dragon earrings expressionless floating_hair glasses glowing guweiz highres holding holding_cup horn_ornament horn_ribbon horns insect jewelry long_hair looking_at_viewer medium_breasts monster necklace orange_eyes original pendant pink_lips rain ribbon round_glasses sharp_teeth shoulder_pads solo teacup teeth very_long_hair water wind yellow-framed_eyewear \", \"1\", \"20110619\");\"\r\n[18:09:57.686] Loading image from http://gelbooru.com/images/72/22/72223d32cdf598856b3b2cb7b39a77b3.jpg 1\r\n[18:09:57.689] Image received from http://gelbooru.com/images/72/22/72223d32cdf598856b3b2cb7b39a77b3.jpg 1\r\n[18:09:57.691] Execution of \"\"\"\"\r\n[18:09:57.691] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"1girl\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.691] Execution of \"\"\"\"\r\n[18:09:57.691] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"artist_name\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.691] Execution of \"\"\"\"\r\n[18:09:57.691] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"black_dress\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.691] Execution of \"\"\"\"\r\n[18:09:57.691] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"blue_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"breasts\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"cleavage\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"cleavage_cutout\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"demon\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"dress\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"earrings\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"female\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"glowing\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"guweiz\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"horns\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"injury\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"jewelry\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.692] Execution of \"\"\"\"\r\n[18:09:57.692] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"looking_afar\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"looking_up\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"medium_breasts\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"motion_blur\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"necklace\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"orange_eyes\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"parted_lips\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"pendant\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"pointy_ears\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"portrait\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"rain\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"red_lips\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"short_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"solo\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.693] Execution of \"\"\"\"\r\n[18:09:57.693] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"upper_body\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.694] Execution of \"\"\"\"\r\n[18:09:57.694] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"water\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.694] Execution of \"\"\"\"\r\n[18:09:57.694] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"water_drop\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.695] Execution of \"C:\\Windows\\System32\\cmd.exe /C copy \"C:\\00\\72223d32cdf598856b3b2cb7b39a77b3.jpg\" \"C:\\w64\\www\\gelbooru\\images\\1\\72223d32cdf598856b3b2cb7b39a77b3.jpg\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO posts(creation_date, hash, image, height, width, ext, rating, tags, directory, active_date) VALUES(NOW(), \"72223d32cdf598856b3b2cb7b39a77b3\", \"72223d32cdf598856b3b2cb7b39a77b3.jpg\", 1101, 900, \".jpg\", \"safe\", \" 1girl artist_name black_dress blue_hair breasts cleavage cleavage_cutout demon dress earrings female glowing guweiz horns injury jewelry looking_afar looking_up medium_breasts motion_blur necklace orange_eyes parted_lips pendant pointy_ears portrait rain red_lips short_hair solo upper_body water water_drop \", \"1\", \"20110619\");\"\r\n[18:09:57.711] Loading image from http://gelbooru.com/images/b7/f7/b7f7c3952d8b375ef9d35f1e945ba148.png 1\r\n[18:09:57.711] Image received from http://gelbooru.com/images/b7/f7/b7f7c3952d8b375ef9d35f1e945ba148.png 1\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"1girl\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"arm_up\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"ass\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"black_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"boots\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"breasts\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"cleavage\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"destruction\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"gradient\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"gradient_background\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"guweiz\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"horns\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"kill_la_kill\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"lens_flare\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"matoi_ryuuko\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"midriff\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"miniskirt\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.711] Execution of \"\"\"\"\r\n[18:09:57.711] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"motion_blur\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"multicolored_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"navel\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"revealing_clothes\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"scissor_blade\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"senketsu\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"short_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"skirt\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"solo\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"stomach\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"sunlight\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"suspenders\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"sword\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"thigh_boots\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"thighhighs\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"two-tone_hair\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"underboob\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"upper_body\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"\"\"\"\r\n[18:09:57.727] SQL execution of \"INSERT INTO tag_index(tag, index_count) VALUES(\"weapon\", 1) ON DUPLICATE KEY UPDATE index_count = index_count+1;\"\r\n[18:09:57.727] Execution of \"C:\\Windows\\System32\\cmd.exe /C copy \"C:\\00\\b7f7c3952d8b375ef9d35f1e945ba148.png\" \"C:\\w64\\www\\gelbooru\\images\\1\\b7f7c3952d8b375ef9d35f1e945ba148.png\"\"\r\n[18:09:57.750] SQL execution of \"INSERT INTO posts(creation_date, hash, image, height, width, ext, rating, tags, directory, active_date) VALUES(NOW(), \"b7f7c3952d8b375ef9d35f1e945ba148\", \"b7f7c3952d8b375ef9d35f1e945ba148.png\", 900, 900, \".png\", \"safe\", \" 1girl arm_up ass black_hair boots breasts cleavage destruction gradient gradient_background guweiz horns kill_la_kill lens_flare matoi_ryuuko midriff miniskirt motion_blur multicolored_hair navel revealing_clothes scissor_blade senketsu short_hair skirt solo stomach sunlight suspenders sword thigh_boots thighhighs two-tone_hair underboob upper_body weapon \", \"1\", \"20110619\");\"\r\n[18:09:57.753] Images download finished.\r\n[18:10:04.508] SQL execution of \"UPDATE post_count SET pcount = (SELECT COUNT(*) FROM posts), last_update = (CURDATE() + 0) WHERE access_key = \"posts\";\"\r\n[18:10:04.508] Batch download finished\r\n```\r\n\r\n\r\nCould you please investigate this?\r\n\r\n### What steps will reproduce the problem?\r\n1. Configure Grabber, WampServer and Gelbooru the same way as described in the WIKI( https://github.com/Bionus/imgbrd-grabber/wiki/Gelbooru ) with the exception of this line in config.php:\r\n`$mysql_user = \"root\";`\r\nIt is not mentioned in the original manual, though without this change Gelbooru can't create new database or access an existing one.\r\n2. Download a batch of images.\r\n\r\n### What is the expected behavior? What do you get instead?\r\nAccording to the WIKI every time I download a pack of images, they will be added to local version of Gelbooru running on the WampServer, but Grabber only copies images to the image directory in Gelbooru folder without adding any records to the database.\r\n\r\n### What version of the program are you using? On what operating system?\r\n_Guest OS running on VMware_\r\nWindows 8.1(9600) x64\r\nGrabber 4.6.0\r\nWampServer 2.2e x64 (https://sourceforge.net/projects/wampserver/files/WampServer%202/WampServer%202.2/wampserver2.2e/wampserver2.2e-php5.4.3-httpd-2.4.2_PATCH001-x64.exe/download)\r\nGelbooru 0.1.11\r\n\r\n_Host OS_\r\nWindows 7 SP1(7601) x64\r\nGrabber 4.6.0\r\nWampServer 3.0.4 x64 apache2.4.18 mysql5.7.11 php5.6.19 (https://sourceforge.net/projects/wampserver/files/WampServer%203/WampServer%203.0.0/wampserver3.0.4_x64_apache2.4.18_mysql5.7.11_php5.6.19-7.0.4.exe/download)\r\nGelbooru 0.1.11\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Bionus/imgbrd-grabber/issues/comments/243304283","html_url":"https://github.com/Bionus/imgbrd-grabber/issues/594#issuecomment-243304283","issue_url":"https://api.github.com/repos/Bionus/imgbrd-grabber/issues/594","id":243304283,"user":{"login":"Bionus","id":882719,"avatar_url":"https://avatars.githubusercontent.com/u/882719?v=3","gravatar_id":"","url":"https://api.github.com/users/Bionus","html_url":"https://github.com/Bionus","followers_url":"https://api.github.com/users/Bionus/followers","following_url":"https://api.github.com/users/Bionus/following{/other_user}","gists_url":"https://api.github.com/users/Bionus/gists{/gist_id}","starred_url":"https://api.github.com/users/Bionus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bionus/subscriptions","organizations_url":"https://api.github.com/users/Bionus/orgs","repos_url":"https://api.github.com/users/Bionus/repos","events_url":"https://api.github.com/users/Bionus/events{/privacy}","received_events_url":"https://api.github.com/users/Bionus/received_events","type":"User","site_admin":false},"created_at":"2016-08-30T01:09:35Z","updated_at":"2016-08-30T01:09:35Z","body":"> I verified credentials, and it seems that they are correct just as MySQL is accessible.(screenshots below) Could you check the setup from wiki on your PC on Windows?\r\n\r\nAs I can see in your screenshots, it seems you added superflous quotes in your settings. Instead of `\"localhost\"`, use only `localhost`, same goes for other fields. Double quotes are not supposed to be put in the settings (same goes for your empty `\"\"` start command that should be totally empty).\r\n\r\nRemove these quotes and it should work.\r\n\r\n> There are more lines that I corrected in order to make gelbooru work as it should, but I forgot to write all of them here. Sorry.\r\n\r\nNo problem, I'll update the wiki and try to set a Gelbooru up on my computer from scratch soon.\r\n\r\n> Actually, it's the opposite, it is much easier to deploy Gelbooru than Moebooru, at least for me. The main reason is Ruby and the way it works on Windows.\r\n\r\nIndeed, if it's Ruby it's much harder on Windows than Linux.\r\n\r\n> Eventually, I got fed up with Ruby and installed Moebooru port to PHP called Myimouto, and it works like a charm. Appropriate cURL command that is needed to upload images to Myimouto can be found in #601 .\r\n\r\nIn that case I'll add a MyImouto tutorial instead, if Gelbooru is being too old. As for #601, it'll be fixed in the next 4.7.0 update I'm working on now. It should be released soon (supposedly by the end of the week)."}}
{"actor":{"display_login":"Bionus"}}