After importing database, wp-posts won’t call correct url

  • redshoes

    (@redshoes)


    21 years ago

    I really hate to re-post an issue that is already being discussed in another thread (http://wordpress.org/support/topic/23962 to be specific) but I fear that the title of the topic may not reflect the problem… and, well honestly, I’m exhausted and desperate.

    I had to relocate my wordpress installation after my server vanished into thin air. Fortunately, I had a 3 month old database backup, but when I imported it with phpmyadmin, I found that the post links were invalid and reverting to the default index.php file. The wp_posts is omiting the index.php part of the url.

    For example:
    http://enkuechen.clawz.com/recipes/?p=4
    instead of
    http://enkuechen.clawz.com/recipes/index.php?p=4

    The trouble seems to be in the ID line field called “guid”. In the “guid” field, the url listed shows the url without the index.php part just as in the first example above. The same thing exists in the post_title table.

    What do I edit to make that guid field pull the whole url across the board (rather than editing each individual post which I am sure is not the right way to do it)?

    Thanks so much for any help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Lorelle

    (@lorelle)

    21 years ago

    If you want, just do a search and replace in the guid field in your database (back it up first! 😉 ) from your database MyAdmin something like this, with the names changed to reflect your personal tables and usage.

    UPDATE wp_posts SET guid = REPLACE (
    guid,
    'http://enkuechen.clawz.com/recipes/',
    'http://enkuechen.clawz.com/recipes/index.php');

    Don’t just “try” this without thinking it through as it will change everything in your guid field that matches the first line. Be careful.

    Thread Starter redshoes

    (@redshoes)

    21 years ago

    well, I think I’m chicken. I am very hesitant to try that because I think that it would effect too many things that are ok as is. The guid doesn’t just list “http://enkuechen.clawz.com/recipes/'”. It actually lists the entire incorrect url for each indivual post. I guess what I really need to know is, where is that guid getting it’s information from? It must be coming from somewhere, do you think?

    Is there any other information I could provide that would help determine the source of the problem? As it stands, the whole site is non-functional because of it. 🙁

    Thread Starter redshoes

    (@redshoes)

    21 years ago

    oh, I might need to clarify this.

    the guid field I am referring to is the column that comes up under ID and post_title

    the actual guid line has these values when I click on edit:

    field: guid
    type: varchar
    length values: 255
    attributes: (is blank)
    null: not null
    default: (is blank)
    extra: is blank

    Is there something I can adjust here? default maybe?

    just thinking outloud. please, stop me if I am about to make a terrible mistake 🙂

    so sorry to be such a pest.. just terribly maddening

    Thread Starter redshoes

    (@redshoes)

    20 years, 12 months ago

    ok, I’m an idiot. it figures that it was as simple as setting my permalink structure. I had never used the permalink edit option before, so it never dawned on me. Can’t believe I wasted all that time and bandwidth trying to upload my .sql file in a million different incarnations.

    soo, for those of you that this may also work for..

    in your wordpress admin: click on options. then permalinks.
    choose a permalink structure. update and voila!
    magic working post pages again

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘After importing database, wp-posts won’t call correct url’ is closed to new replies.