Title: Url problem / wp_3_options table change Last modified: August 20, 2016 --- # Url problem / wp_3_options table change * [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/) * Hello, * I have mysite.com and mysite.com/en, but if I login into the admin, the url of the second blog change to mysite.com. * I don’t know what is going on. * Any clue of what can I do or what could be happening???? * Thanks! Viewing 15 replies - 1 through 15 (of 22 total) 1 [2](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/page/2/?output_format=md) [→](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/page/2/?output_format=md) * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227022) * What’s in your .htaccess? * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227025) * Hello, * Thanks for your help, I am completely desperate. * If I am honest I don’t know what I am doing exactly with this .htaccess. * Thanks * ``` # canonical redirect to no www RewriteEngine On RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC] RewriteRule ^(.*)$ http://%1/$1 [R=301,L] # BEGIN WordPress RewriteEngine On RewriteBase / RewriteRule ^index\.php$ - [L] # uploaded files RewriteRule ^([_0-9a-zA-Z-]+/)?files/(.+) wp-includes/ms-files.php?file=$2 [L] # add a trailing slash to /wp-admin RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L] RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^ - [L] RewriteRule ^[_0-9a-zA-Z-]+/(wp-(content|admin|includes).*) $1 [L] RewriteRule ^[_0-9a-zA-Z-]+/(.*\.php)$ $1 [L] RewriteRule . index.php [L] # END WordPress ``` * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227046) * For a quick test, remove the canonical redirect you have for www. * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227049) * Hello, * I have removed the canonical redirect and at the moment it is working good. * I made some test, changed a few post and all seems to work fine. * Do you think this was the problem??? What a canonical www redirect means??? * Thank you so much for your help! * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227052) * The canonical redirect forces your domain to use domain.com instead of [http://www.domain.com](http://www.domain.com) * The problem was that you wrote it wrong. If you want to use that, it should be this: * ``` RewriteCond %{HTTP_HOST} ^www\.domain\.tld$ [NC] RewriteRule ^(.*)$ http://domain.tld/$1 [R=301,L] ``` * The way you wildcarded it breaks on WP due to it’s rules. * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227054) * Hi, * Today it happened again, The url of the second blog have changed and now both have the same url. * It’s to weird no??? I removed the canonical redirection as you told me but it’s happening again. * if I go to mydomain.com or [http://www.mydomain.com](http://www.mydomain.com) I can see the website and I removed the canonical redirection. * What should I do???? * Thanks you very much! * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227055) * Are you being redirected to one URL or the other, or are BOTH working? * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227056) * Both are working, if I point my browser to mydomain.com/en the site its working but if I go to the admin > mysites, both are redirecting to mydomain.com * If I force in the browser mydomain.com/en/wp-admin, I can access to the second blog admin. * The only think that is changing it’s the field siteurl of the table wp_3_options in my data base. * In this row of the db, the url have to be [http://www.mydomain.com/en](http://www.mydomain.com/en), but sometimes, wordpress remove the /en and leave [http://www.mydomain.com](http://www.mydomain.com) * It is a problem because I am using the fuction site_url() in my theme to get content depending on the language, and when wordpress change the url and remove the /en the website throws a few errors. * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227058) * By ‘working’ do you mean [http://www.domain.com/en](http://www.domain.com/en) works AND domain.com/en works, or only one? * See, WordPress needs to be one or the other. Having both is problematic. * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227059) * If you go to [http://mysite.com/en](http://mysite.com/en) or [http://www.mysite.com/en](http://www.mysite.com/en) you get the same page and no errors, you can see the page. * What I can not understand it’s why wordpress change the url in the data base. * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227064) * Okay, so both www and non-www works. Amd that’s a problem. * You should only use ONE. One should redirect to the other. So domain.com/en should magically redirect to [http://www.domain.com/en](http://www.domain.com/en) (or vice versa, it depends which you used when you setup the site). * > What I can not understand it’s why wordpress change the url in the data base. * Sorry what? Did you change something in the DB? * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227065) * Well my main problem is that wordpress, not me, automatically change the url of my second blog in the database. * I have to blogs: myblog.com and myblog.com/en * well, I don’t know why but when I login into the admin wordpress changes the url of the secondo blog to myblog.com, removing the /en string at the end. * Each time it happens I go to the database, find the table wp_options of the secondo blog and I see that the field siteurl was changed to mydomain.com. If I want my blog work again I have to go to my database and change it be my self. * I don’t know what its happening * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227068) * > Well my main problem is that wordpress, not me, automatically change the url > of my second blog in the database. * No. WordPress _will not_ do this. A plugin might, or you may have done it on accident, but WP doesn’t magically flip that over for you. You have something else on your site doing that. * What plugins are you running? * Thread Starter [viebone](https://wordpress.org/support/users/viebone/) * (@viebone) * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227071) * Hello again, thanks you so much for your help. * It happens each time I use the admin to create new post, update content etc. After updating I always have to enter in the database and change the siteurl of the table wp_3_options, which is the second blog options table, and add the“/ en” to mydomain.com * I am using the following plugins: * – Advanced Post Types Order ([http://www.nsp-code.com/](http://www.nsp-code.com/)) * – Lightbox Plus * – Search Everything * – User Role Editor ([http://shinephp.com/user-role-editor-wordpress-plugin/](http://shinephp.com/user-role-editor-wordpress-plugin/)) * I think all of them are common plugins. * This weekend I will deactivating them just for to be sure. * What do you think could be happening. * Thanks! * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 6 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/#post-3227079) * I think there’s something in your theme or your plugins that’s doing this. Viewing 15 replies - 1 through 15 (of 22 total) 1 [2](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/page/2/?output_format=md) [→](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/page/2/?output_format=md) The topic ‘Url problem / wp_3_options table change’ is closed to new replies. * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/) * 22 replies * 3 participants * Last reply from: [viebone](https://wordpress.org/support/users/viebone/) * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/url-problem-wp_3_options-table-change/page/2/#post-3227095) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics