Geek Rant dot org

Fri 2006-04-21

MySql woes

Filed under: — daniel @ 14:41

We’ve got MySql problems here at Geekrant central.

MySQL said: Documentation
#1016 – Can’t open file: ‘wp_comments.MYI’ (errno: 145)

Doesn’t sound good, does it? The ISP is looking into it.

Nothing else seems to be AWOL, but I’ve taken a backup of everything just in case. Wouldn’t you know it, the backup I have of wp_comments isn’t particularly recent. Hopefully the ISP has a newer one, but if not, I’ve grabbed a bunch of comments via Newsgator’s cache. Gawd knows how I’d restore them though.

Update: Fixed. May I just say, the support guys at AussieHQ hosting are deadset legends.

Bookmark and Share

Google Page Creator

Filed under: — daniel @ 14:10

Google goes after the Yahoo Geocities amateur page hosting business, with Google Page Creator. It includes a web-based AJAX-based WSYWIG page designer, themes that look remarkably Blogger-ish (no surprise I suppose) and hosting at googlepages.com.

In beta, natch.

Bookmark and Share

WordPress Most comments

Filed under: — daniel @ 07:05

Here’s the SQL to find which of your WordPress posts have the most comments:

SELECT wp_comments.comment_post_id, count(*) as commentcount, wp_posts.post_title, wp_posts.post_date FROM wp_comments, wp_posts
where wp_comments.comment_post_id = wp_posts.ID
group by wp_comments.comment_post_id, wp_posts.post_title, wp_posts.post_date
order by commentcount desc

Bookmark and Share

26 queries. 0.751 seconds. Powered by WordPress