Fixed Wordpress 2.0 Trackback Issue

By Knight | Wed 28th-Dec-2005

Wah ! this is my first post to ping pps, after i upgrade to wordpress2.0 few day ago ..

I been having problem to trackback after i upgrade to wordpress 2 RC3, even the final version release can’t fix the problem

  • if you upgrade your db from 1.5.2 to 2.0
  • unable to trackback, no matter what you publish the trackback url remain at the trackback field

if your situation match the above point, here are the solution that i want to share with you after i dig table by table, code by code , field by field

this problem is because of to_ping field contain some char ( including space, tab which represent by \n\r ), run this sql command under your phpmyadmin Update ‘wp-posts’ set to_ping=”

after this should be able to trackback already, i believe the wordpress dev team change hows the original trackback work, thats explain why there are no problem during 1.5.2 but cause some problem in 2.0, i think they should include this in the upgrade script

Tags:
Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

14 Comments

  1. Knight
    Posted Thu 29th-Dec-2005 at 8:27 am | Permalink

    Rajan ,

    just to make sure what you type is
    Update `wp-posts’ set to_ping=(single quote twice) ?

  2. boringest
    Posted Thu 29th-Dec-2005 at 9:27 am | Permalink

    you can also leave out the ‘ for the wp_posts so it becomes like this:

    update wp-posts set to_ping=''

  3. Knight
    Posted Thu 29th-Dec-2005 at 9:50 am | Permalink

    if i not wrong backquote need to put to show that is a table

  4. Knight
    Posted Thu 29th-Dec-2005 at 2:18 pm | Permalink

    Rajan by default should be wp-posts, sorry for my mistake
    it this work for you ?

  5. Knight
    Posted Thu 29th-Dec-2005 at 5:01 pm | Permalink

    Rajan glad that help you

  6. Patriarch Anthony I
    Posted Fri 30th-Dec-2005 at 2:44 am | Permalink

    It should be:

    UPDATE wp_posts SET to_ping = ”

    In newer versions of mysql and phpmyadmin it needs to have the table minus the quotes.

  7. John
    Posted Fri 30th-Dec-2005 at 2:51 am | Permalink

    Knight,

    I ran the script and it did clear out the to_ping column but my trackbacks still don’t work. It just stays there after I publish.

    I saw that there is a patch on PiperL’s blog, but I was unable to open it with WinZip. Do you have any suggestions?

  8. Knight
    Posted Fri 30th-Dec-2005 at 1:32 pm | Permalink

    Hi John,

    did you try to setup a fresh wp2.0 to test the trackback ? see can the trackback work on fresh setup.

  9. Sashi
    Posted Fri 30th-Dec-2005 at 1:40 pm | Permalink

    Thanks for the tip, Knight - the SQL code worked and I could send a ping to PPS. But I tried sending a trackback to your post, and it’s not showing. Did the trackback come through?

  10. Knight
    Posted Fri 30th-Dec-2005 at 1:42 pm | Permalink

    Sashi , sorry for that , your trackback been mark as spam by my spamkarma .. hehe recover it now

  11. Edrei
    Posted Sun 22nd-Jan-2006 at 1:58 pm | Permalink

    The fix doesn’t work for me, but we’ve finally found the core root of the problem. Quoting from the Wordpress Dev Trac:

    PHP as CGI (on Site5 at least) has a limited socket stacking capability. fsockopen to a local url works fine until the called script sends output, at which time the script dies.

    I’ve confirmed this with my webhost too. There was a reason why the trackbacks were upgraded. I can’t recall why. I think it has something to do with faster pingback and trackbacks. Oh well, guess we didn’t see that coming.

  12. Knight
    Posted Sun 22nd-Jan-2006 at 10:53 pm | Permalink

    haha ok, hhhhmmmm but i thought i saw some recent review say that site5 is not that good compare to last time ..

  13. Palmdoc
    Posted Wed 18th-Apr-2007 at 1:18 pm | Permalink

    Is this still an issue for WP 2.1.3? My pings don’t seem to work anymore for PPS

  14. Knight
    Posted Fri 20th-Apr-2007 at 7:45 am | Permalink

    i don’t think so , this has been fixed long long time ago

13 Trackbacks

  1. By KOREKK!!! on Thu 29th-Dec-2005 at 12:36 am

    [...] Shameless self-plug to test the wordpress trackback thing after a solution from Ah Knight’s. But in case you’ve missed my post earlier, here it is: [...]

  2. By - priv - » Blog Archive » WordPress 2.0 Trackback bug on Thu 29th-Dec-2005 at 12:18 pm

    [...] 新加å?¡ä¾†çš„knight使用ç ?掉é‡?練的大絕招(清掉所有的to_ping欄ä½?)來解決。雖然覺得好åƒ?有點暴力，ä¸?é?Žç”±æ–¼é‚„沒看到有人研究出真正造æˆ?ä¸?能ping的根本原因，所以也是目å‰?所見唯一的解法。 [...]

  3. By Rajan Rishyakaran » Blog Archive » Do I Ping? on Thu 29th-Dec-2005 at 2:34 pm

    [...] Yes I ping. Fixed the pingging problem on WordPress 2.0, thanks to Ah Knight. [...]

  4. By 終極邊疆BLOG on Thu 29th-Dec-2005 at 3:35 pm

    讓 WP2.0 å?¯ä»¥æ­£å¸¸trackback…

    把站å?°å¾ž wordpress 1.5 å?‡ä¸Š wordpress 2.0 的人們，å?¯èƒ½ç™¼ç?¾ä¸?能 Trackback了。我，也中標了。
    Ah Knight’s Blogæ??供了一個蠻暴力的解法：把資料庫中的 to_ping欄ä½?給清光光，並æ??å?Šå?¯èƒ½çš„原因是：
    this……

  5. By 終極邊疆BLOG on Thu 29th-Dec-2005 at 4:31 pm

    Patch for WordPress 2.0 trackback issue…

    After upgrading to wordpress 2.0, I found the WP2.0 is failed to send trackback.
    This issue is also confirmed by ijliao, priv, and Ah Knight’s Blog.
    There has been a workaround in Ah Knight’s Blog for this issue.But even you clean up the &#…

  6. By Northern-Web-Coders » Wordpress 2.0 on Thu 29th-Dec-2005 at 10:52 pm

    [...] Ein Member im Wordpress-Forum hat eine Lösung gefunden… und die funzt Hier haben schon andere was dazu gesagt! [...]

  7. By sashi-isms on Fri 30th-Dec-2005 at 12:06 pm

    The blog is upgraded - finally….

    Test pinging PPS with WP 2.0.

    ……

  8. By Ah Knight’s Blog » Wordpress 2.0 and Adsense on Fri 30th-Dec-2005 at 1:57 pm

    [...] Other then talking about the wordpress 2.0 trackback issue, another thing which pop in my eyes is Adsense on Wordpress 2.0 [...]

  9. By Comme si tu veux on Fri 30th-Dec-2005 at 11:15 pm

    讓wordpress2.0å?¯ä»¥æ­£å¸¸trackback…

    via： 終極邊疆
    如果你從1.5.2å?‡ä¸Šä¾†ï¼Œä¸”å?‡ç´šå‰?在文章的to_ping欄ä½?還留有未ping完的記錄的話，那麼就應該就é?žå¸¸æœ‰å?¯èƒ½æœƒé?‡åˆ°é€™å€‹å•?題。
    WordPress 1.5以å‰?發表文章è¦?é€?出時，使用者得先等 trackb……

  10. By szehau’s weblog - Life, Internet, Online Revenue, Softwares, Gadgets and Programming Experience » Blog Archive » Wordpress 2.0 Trackback on Sat 31st-Dec-2005 at 12:11 am

    [...] Read his post for more information: Fixed Wordpress 2.0 Trackback Issue [...]

  11. By MENJ’s Critical Thoughts » Can I ping? on Fri 6th-Jan-2006 at 7:39 pm

    [...] Used Ah Knight’s tip to correct trackback pinging in Wordpress 2.0. It should work. At least, I hope so. [...]

  12. By krootoo. 5 » WP 2.0 Trackbackproblem on Wed 25th-Jan-2006 at 6:33 am

    [...] Informationen habe ich auf diesen Seiten gefunden: http://blog.serv.idv.tw/ (Patch wp20-trackback-patch) http://www.paulooi.com/ (Patch wp20_trackback_fixed) http://www.grimmy.de/blog/ http://www.ahknight.net/ http://www.northern-web-coders.de/blog/archiv/2005/12/29/wordpress-20/ [...]

  13. By èµ°å?‘云和山的彼端 » 打整完毕 on Thu 23rd-Feb-2006 at 11:53 am

    [...] Ah Knight’s Blogæ??供了一個蠻暴力的解法變通的方法：把資料庫中的 to_ping欄ä½?給清光光，並æ??å?Šå?¯èƒ½çš„原因是： this problem is because of to_ping field contain some char ( including space, tab which represent by nr ) [...]

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*