« John Roberts to replace Supreme Court Justice Sandra Day O'Connor | Main | The 7/21 Muslim London Bombings »

July 20, 2005

Debugging Trackback problems with MovableType and MySQL

I'm having a problem with MovableType where a trackback does not appear. It passed through the MT-Blacklist and SpamLookup filters, and was approved, but has no text, and dose not appear in the html under the "trackback" anchor. So, I'd like to add some text to the trackback, but Movable Type doesn't allow me to do this. So, I'm going to look into MySQL database to see if I can find where the trackback entries are stored and update the text there.

I found this web page with Handy MySQL Commands:

Here's the commands I entered for the session:

mysql -uroot -ppassword
show databases;
use pw;
show tables;
describe mt_tbping;
select * from mt_tbping where tbping_id = '145';
update mt_tbping set tbping_excerpt = 'test' where tbping_id = '145';

Then, I rebuilt the site and this fixed the problem. For some reason, the excerpt from the ping was stored as null. Not sure why this happened. But, it fixed the trackback for now.

Posted by Peenie Wallie on July 20, 2005 at 10:53 AM