changing the Site URL

  • pinockkio

    (@pinockkio)


    16 years, 1 month ago

    Clayton James helped me on my way to get my site back and I came as
    far as step 13. I added :update_option(‘siteurl’,’http://perfectformulaonline.com/blog’);
    in the field, but after clicking “go”, I got a message:
    #1064- You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near ‘option_value’SELECT*from’wp_options’WHERE’option_name’LIKE
    ‘siteurl’ upd’ at line 1

    Also I could not find the ‘home’ field in the table.

    If anyone can help me with this I will be most grateful.

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

    (@kim09)

    16 years, 1 month ago

    Hey pinockkio,

    There is “home” field, if you click the right arrow (see the pic)
    Good luck!

    Thread Starter pinockkio

    (@pinockkio)

    16 years, 1 month ago

    Hi Kim09

    Thanks for your help, I appreciate it,but I still haven’t my site back. In the steps to be taken to change the site URL,it says in step4: A list of your databases will appear. Choose the one that is your WordPress database. Which one? I got one: perfectf_wpress, which is empty, than there is wrdp1,which I took and wrdp2.
    I updated the ‘siteurl’ and ‘home’ according to the instructions,
    but still have no site. Can anybody help me PLEASE!
    Thanks!
    Pinockkio

    kim09

    (@kim09)

    16 years, 1 month ago

    http://codex.wordpress.org/Changing_The_Site_URL
    hope this help.

    Thread Starter pinockkio

    (@pinockkio)

    16 years, 1 month ago

    Hi Kim
    Thank you for your help.
    I have the instructions on how to change the Site URL,
    but it doesn’t work because I didn’t save the database for perfect_wpress,it was empty.

    I have to start all ove again,building up my blog, but it was not
    much, a few blogs and pages.

    Thanks again!
    Pinockkio.

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

The topic ‘changing the Site URL’ is closed to new replies.