humanmade / humanmade/WordPress-Importer

not working WP 4.9.8

Open
#166 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
PHP
Stars
359
Forks
62
PR merge metrics
No merged PRs in 30d

Description

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 hormonal imbalance can cause tremendous emotional stress in wome...\n', referer: https://healthable.net/wp-admin/admin.php?import=wordpress&step=1&_wpnonce=91af2fbe0b]
`

Contributor guide

Open the contributing guide

Research direction

The issue names the WP_Import->dispatch, import, and process_posts entry points but no repository files or tests. Start by reproducing the failed 170MB WXR import and inspect how the importer determines the WordPress table prefix; done means identifying the cause of the missing posts table and verifying a completed import.

Written by the indexing model from the issue text.

Assessment

Tech stack
php, wordpress
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.