[wp-hackers] WP_SITEURL and db update

[Otto]

On Tue, Jul 29, 2008 at 8:05 AM, Stefano Aglietti <steagl4ml at gmail.com> wrote:
> On Tue, 29 Jul 2008 05:20:08 -0700, Viper007Bond
> <viper at viper007bond.com> wrote:
>
>>What does it matter what the value in the database is? You shouldn't be
>>manually querying, so it won't affect you.
>
> Would be usefull for end users that mess up with paths and url in the
> admin panel, this solve the problem but if it force tha value would be
> an easy alternative that editing DB using phpmyadmin.

I've been telling people to add code to their theme's functions.php
file instead of manually modifying the DB:
update_option('siteurl','http://example.com');
update_option('home','http://example.com');

Stick that in there, load the page a couple times, remove it again.
Database fixed.