WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_str8_posts LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (5431,5430) GROUP BY ID

STR8BLOGGIN » 2010 » October

Archive for October, 2010

Beautified, unminified version of the FBJS source

Wednesday, October 20th, 2010

Useful for Facebook app hackers: the FBJS code, unminified.

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_str8_comments WHERE comment_post_ID = 5431 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(*) FROM wp_str8_comments WHERE comment_post_ID = '5431' AND comment_approved = '1'

No Comments »

How to request additional permissions during an FBJS Ajax call

Wednesday, October 20th, 2010

Here’s something we learned with FANBLDR, our Facebook Page Maker. If you do an Ajax call in FBML+FBJS, you can use the requireLogin=1 attribute to request permissions. These will then be sent to the
receiving script via POST. However, what if you need extra permissions? Try this:

Facebook.showPermissionDialog(’publish_stream’, function() {
var ajax = new Ajax();
ajax.requireLogin = 1;
ajax.responseType = Ajax.RAW;
ajax.onerror = function(data) {
permissionDialog = new Dialog().showMessage(’Error posting’, ‘Unknown error. Try again later.’, ‘OK’);
}
ajax.ondone = function(data) {

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_str8_comments WHERE comment_post_ID = 5430 AND comment_approved = '1';

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT COUNT(*) FROM wp_str8_comments WHERE comment_post_ID = '5430' AND comment_approved = '1'

No Comments »