WordPress-Importer
WordPress-Importer copied to clipboard
not working WP 4.9.8
Hello;
I tried using it to upload my XML backup of 170MB, in the process i stopped it (did not let it complete) then on its own it started adding the images, users and posts.
Then i reinstalled the site and left it to complete the process but it did not and throw the error message Whoops, could not upload file: HTTP error.
in my log i found the following
AH01071: Got error 'doesn't exist for query SELECT post_name FROM W9Uqa8_posts WHERE post_name = '3-everyday-habits-that-help-prevent-hormonal-imbalance-in-women' AND post_type = 'post' AND ID != 0 LIMIT 1 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_unique_post_slug\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE ID = 65811 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query INSERT INTO
W9Uqa8_posts (
post_author,
post_date,
post_date_gmt,
post_content,
post_content_filtered,
post_title,
post_excerpt,
post_status,
post_type,
comment_status,
ping_status,
post_password,
post_name,
to_ping,
pinged,
post_modified,
post_modified_gmt,
post_parent,
menu_order,
post_mime_type,
guid,
ID) VALUES (1, '2018-06-18 12:05:49', '2018-06-18 11:05:49', 'Hormonal imbalance can affect women in a number of ways and actually end up making their lives miserable. The sad part is that hormonal imbalance is one of the leading causes of female infertility and that it can mess with several functions in the body of a woman.\\nThe physical and biological symptoms of <strong>hormonal imbalance</strong> can cause tremendous <a href=\\"https://healthable.org/perfect-diet-for-students-in-a-period-of-exam-stress/\\" target=\\"_blank\\" rel=\\"noopener\\">emotional stress</a> in wome...\n', referer: https://healthable.net/wp-admin/admin.php?import=wordpress&step=1&_wpnonce=91af2fbe0b]
Here is another error..
AH01071: Got error 'e = '3-natural-methods-to-ease-digestion' AND W9Uqa8_posts.ID NOT IN (0) AND W9Uqa8_posts.post_type IN ('post', 'page', 'attachment') AND ((W9Uqa8_posts.post_status = 'trash')) ORDER BY W9Uqa8_posts.post_date DESC made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT post_name FROM W9Uqa8_posts WHERE post_name = '3-natural-methods-to-ease-digestion' AND post_type = 'post' AND ID != 0 LIMIT 1 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_unique_post_slug\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE ID = 58758 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query INSERT INTO
W9Uqa8_posts (
post_author,
post_date,
post_date_gmt,
post_content,
post_content_filtered,
post_title,
post_excerpt,
post_status,
post_type,
comment_status,
ping_status,
post_password,
post_name,
to_ping,
pinged,
post_modified,
post_modified_gmt,
post_parent,
menu_order,
post_mime_type,
guid,
ID) VALUES (90, '2018-04-25 19:10:25', '2018-04-25 18:10:25', '<a href=\\"https://healthable.org/a-complete-guide-to-good-digestive-health/\\" target=\\"_blank\\" rel=\\"noopener\\">Digestive health</a> is incredibly important, especially as discomfort or even pain caused by digestive issues can cause a decrease in productivity at work or in classes, as well as a decline in mood. Individuals with chronic digestive health issues often simply live their lives in acceptance of digestive pain, feeling unable to change or ease the digestive discomfort without having to turn to dail...\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE 1=1 AND post_date = '2018-04-28 09:00:31' AND post_title = 'Dangers of Toxins in the Body' made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, post_exists\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT W9Uqa8_posts.* FROM W9Uqa8_posts WHERE 1=1 AND W9Uqa8_posts.post_name = 'dangers-of-toxins-in-the-body' AND W9Uqa8_posts.ID NOT IN (0) AND W9Uqa8_posts.post_type IN ('post', 'page', 'attachment') AND ((W9Uqa8_posts.post_status = 'trash')) ORDER BY W9Uqa8_posts.post_date DESC made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT post_name FROM W9Uqa8_posts WHERE post_name = 'dangers-of-toxins-in-the-body' AND post_type = 'post' AND ID != 0 LIMIT 1 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_unique_post_slug\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE ID = 58763 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query INSERT INTO
W9Uqa8_posts (
post_author,
post_date,
post_date_gmt,
post_content,
post_content_filtered,
post_title,
post_excerpt,
post_status,
post_type,
comment_status,
ping_status,
post_password,
post_name,
to_ping,
pinged,
post_modified,
post_modified_gmt,
post_parent,
menu_order,
post_mime_type,
guid,
ID) VALUES (165, '2018-04-28 09:00:31', '2018-04-28 08:00:31', 'Toxins can be said to be anything that disrupts the normal metabolism and physiology of the body; they affect the functions of the body in a negative way and cause lots of health problems.\\nThey can enter the body and they can also be created by the body; waste products from the normal activities of the cells and by-products of vaccines and drugs can be toxins.\\nOur bodies are prone to invasion by toxins and just living our lives on a daily basis puts one at risk of coming in contact with toxins and toxins e...\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE 1=1 AND post_date = '2018-04-26 16:51:39' AND post_title = 'Your Role in Lab Test Preparation' made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, post_exists\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT W9Uqa8_posts.* FROM W9Uqa8_posts WHERE 1=1 AND W9Uqa8_posts.post_name = 'your-role-in-lab-test-preparation' AND W9Uqa8_posts.ID NOT IN (0) AND W9Uqa8_posts.post_type IN ('post', 'page', 'attachment') AND ((W9Uqa8_posts.post_status = 'trash')) ORDER BY W9Uqa8_posts.post_date DESC made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT post_name FROM W9Uqa8_posts WHERE post_name = 'your-role-in-lab-test-preparation' AND post_type = 'post' AND ID != 0 LIMIT 1 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_unique_post_slug\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE ID = 58774 made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query INSERT INTO
W9Uqa8_posts (
post_author,
post_date,
post_date_gmt,
post_content,
post_content_filtered,
post_title,
post_excerpt,
post_status,
post_type,
comment_status,
ping_status,
post_password,
post_name,
to_ping,
pinged,
post_modified,
post_modified_gmt,
post_parent,
menu_order,
post_mime_type,
guid,
ID) VALUES (90, '2018-04-26 16:51:39', '2018-04-26 15:51:39', 'Every now and then, you go for lab tests for different diseases such as malaria, <a href=\\"https://www.healthtestingcenters.com/std-testing-example-test-results\\" target=\\"_blank\\" rel=\\"noopener\\">STD testing</a>, and other ailments, but did you know that the reliability and the accuracy of the lab tests depend entirely on you? If anything, you give the sample for which the test is done. As such, it is important to prepare adequately for any lab tests for a more useful interpretation by your physician. This ...\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT ID FROM W9Uqa8_posts WHERE 1=1 AND post_date = '2018-04-26 07:00:08' AND post_title = 'What Do Your Habits Mean?' made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, post_exists\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT W9Uqa8_posts.* FROM W9Uqa8_posts WHERE 1=1 AND W9Uqa8_posts.post_name = 'what-do-your-habits-mean' AND W9Uqa8_posts.ID NOT IN (0) AND W9Uqa8_posts.post_type IN ('post', 'page', 'attachment') AND ((W9Uqa8_posts.post_status = 'trash')) ORDER BY W9Uqa8_posts.post_date DESC made by WP_Import->dispatch, WP_Import->import, WP_Import->process_posts, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts\nPHP message: WordPress database error Table 'wp_ahy1b.W9Uqa8_posts' doesn't exist for query SELECT post_name FROM W9Uqa8_posts WHERE post_name = 'what-do-your-habits-mean' AND post_type = 'post' AND ID != 0 LIMIT 1 made by WP_Import->dispatch, WP_Import->import,
Here is my observation;
- When you browse a file and selects it, takes few seconds to load/show (making it look like you have a freezing system)
- Does not support/recognize GZIP XML file
======================
So i don't know if i should stop the upload when its in progress.