the clueless american

Not that I expect too many people read this blog, but I finally fixed the error that has been keeping me from posting to my blog for over 2 months. In case this winds up on someone's Google query and can be of help, I was getting the dreaded 'Statement has no result columns to bind' error that was preventing me from using my site. After much trial and error I came across a site recommending that I clean up the MySQL tables. I went to http://paulstamatiou.com/2006/05/31/how-to-quickie-repair-mysql-tables-in-phpmyadmin/ for tips on how to fix my tables using phpmyadmin. In my case repairing the tables with overhead didn't help but I noticed my mt.log and tbping tables reported "in use" and the associated MYI files were dated Oct 18th where everything else was Dec 19th. I repaired those two tables and so far everything seems to be working again. Yee-haw!