Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

not working WP 4.9.8 #166

Open
iamkingsleyf opened this issue Aug 29, 2018 · 2 comments
Open

not working WP 4.9.8 #166

iamkingsleyf opened this issue Aug 29, 2018 · 2 comments

Comments

@iamkingsleyf
Copy link

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]

@iamkingsleyf iamkingsleyf changed the title not working not working WP 4.9.8 Aug 29, 2018
@iamkingsleyf
Copy link
Author

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,

@iamkingsleyf
Copy link
Author

iamkingsleyf commented Aug 29, 2018

Here is my observation;

  1. When you browse a file and selects it, takes few seconds to load/show (making it look like you have a freezing system)
  2. Does not support/recognize GZIP XML file

======================

So i don't know if i should stop the upload when its in progress.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant