• Hi,

    I’ve got 148 pages that I would like to add into wordpress. I’ve used VIM to sort out the data and have come up with this:

    INSERT INTO <code>wp_posts</code> VALUES (114, 1, '2007-02-24 19:19:05', '2007-02-24 19:19:05', 'data', 'Barking and Dagenham', 0, '', 'publish', 'open', 'open', '', 'Barking and Dagenham', '', '', '2007-05-21 08:37:40', '2007-05-21 08:37:40', '', 0, 'http://testteachtuition.com/?page=100', 0, 'page', '', 0, 0);
    INSERT INTO <code>wp_posts</code> VALUES (114-<strong>this increases by one for each new page.</strong>, 1, '2007-02-24 19:19:05', '2007-02-24 19:19:05', 'data', 'Barking and Dagenham<strong>-this changes</strong>', 0, '', 'publish', 'open', 'open', '', 'barking-and-dagenham<strong>-this also changes for each page.</strong>', '', '', '2007-05-21 08:37:40', '2007-05-21 08:37:40', '', 0, 'http://testteachtuition.com/?page=100<strong>-this increases by one for a unique GUID</strong>', 0, 'page', '', 0, 0);

    for each page. The SQL query executes fine and a new row appears in my database. The problem is WordPress can’t see the page. Why is this?

    Do I need to modify another table for wordpress to see the page?

    Any help would be appreciated.

    Steven

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Manual insertion of post into wp_posts’ is closed to new replies.