問題描述

一位開發(fā)人員在他的本地機(jī)器上建立了一個(gè) WordPress 網(wǎng)站.然后他將整個(gè)安裝遷移到服務(wù)器上.自然，sql中的所有鏈接都設(shè)置為localhost:8888.然后我運(yùn)行了一個(gè) SQL 更新來修復(fù)鏈接，使它們指向正確的域(現(xiàn)在是一個(gè) ipaddress/~username 鏈接).我已經(jīng)仔細(xì)檢查了我的工作，一切看起來都是正確的.

A fellow developer built a WordPress website on his local machine. He then migrated the whole installation onto a server. Naturally, all the links in sql were set to localhost:8888. I then ran a SQL update to fix the links so they pointed to the correct domain (which right now is an ipaddress/~username link). I've double checked my work, and it all looks correct.

UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com');
UPDATE wp_options SET option_value = replace(option_value, 'feed://www.olddomain.com', 'feed://newdomain.com');
UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com','http://newdomain.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com', 'http://newdomain.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com');

我使用了該編碼，但其中包含適當(dāng)?shù)挠蛐畔?

I used that coding, but with the appropriate domain information in there.

現(xiàn)在是發(fā)生了什么.

每當(dāng)我進(jìn)入主頁時(shí)，它都可以工作，但圖像不顯示.然后我點(diǎn)擊一個(gè)鏈接，或前往 wp-admin，它在 urlbar 中顯示了兩次 url.所以它會(huì)變成這樣:

Whenever I go to the homepage, it works, but the images don't show up. then i click on a link, or travel to teh wp-admin, and it shows the url twice in the urlbar. so it goes to something like:

http://newdomain.com/~user/http://newdomain.com/~user/post-name-blah-blah-blah

.htaccess 文件都是默認(rèn)的，(如果 WordPress 在一個(gè)子目錄中，它應(yīng)該有重寫規(guī)則而不是/?)

the .htaccess file is all default, (if WordPress is in a subdirectory should it have a rewrite rule for that instead of just /?)

如果沒有像 SQL 中那樣列出，什么會(huì)導(dǎo)致網(wǎng)站上的每個(gè)鏈接兩次訪問同一個(gè) URL?

What could cause every link on the site to go to the same url twice, if none of them are listed like that in SQL?

更新:

好的，所以我刪除了整個(gè)數(shù)據(jù)庫并重新設(shè)置，然后站點(diǎn)就可以正常工作了.當(dāng)然，這意味著我丟失了所有內(nèi)容.我猜我在某處搞砸了 sql 查詢.但是我找不到任何有兩個(gè) url 的地方，或者甚至?xí)?dǎo)致這種情況.隨著我發(fā)現(xiàn)我的問題，將會(huì)有更多更新.

Alright, so I erased the whole database and reset that up, and then the site works fine. of course that means I lose all my content. I'm guessing i screwed up the sql query's somewhere down the line. But I can't find anywhere that has two urls, or would even cause this. More updates coming as I figure out my issue.

推薦答案

我解決了！希望如果其他人來到這里并犯了同樣的錯(cuò)誤，這會(huì)有所幫助.在 wp_options 表中，site_url 和 home 的行需要在它們前面有 http:// .不知何故，我的 sql 查詢破壞了該部分.我當(dāng)然沒有注意到，因?yàn)榈刂房雌饋硎钦_的，因?yàn)檫@通常有效.但在這種情況下，它會(huì)導(dǎo)致一些鏈接永無止境的循環(huán)，而在其他情況下，它只會(huì)將地址翻倍.

I Solved it! Hopefully if anyone else comes here and has the same mistake, this will help. In the wp_options table the rows for site_url and home need to have http:// in front of them. Somehow on my, my sql query busted that portion. Of course I didn't notice because the address looked correct, because that normally works. but in this case it caused a never-ending loop with some links, and in others just doubled the address.

這篇關(guān)于WordPress 鏈接全部重定向到雙 URL的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！