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 (5428,5426,5425,5424) GROUP BY ID

STR8BLOGGIN » 2010 » August

Archive for August, 2010

How a Facebook app can change its own tab name

Saturday, August 28th, 2010

The mysterious admin.setAppProperties holds all the secrets.

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 = 5428 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 = '5428' AND comment_approved = '1'

No Comments »

How to determine who installed your Facebook app in a tab

Friday, August 27th, 2010

As any Facebook developer knows, Facebook has some restrictive ideas about permissions and what apps should be allowed to do on your behalf or even know about you. One consequence of this is that Facebook avoids giving you any information about the user who is interacting with your app in a tab. The session data you are given will contain the page’s id (known as profile_id in the decoded signed_request value) but not the user’s id. The user’s id is available when people interact with your app outside of a page tab, but that doesn’t help when it’s in a tab.
Aside: New developers, always remember that Facebook gives you more or less access to the platform depending on how the …

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 = 5426 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 = '5426' AND comment_approved = '1'

No Comments »

The evils of fb:tabs

Wednesday, August 25th, 2010

The <fb:tabs> and <fb:tab-item> FBML tags are very handy to use in your Facebook apps if you want to maintain the Facebook appearance. Unfortunately, they also have weird target behavior that causes the user to leave your application’s frame - if it’s an FBML canvas tab app, and you want to keep your app inside the tab for layout reasons, this is bad news.
To fix it, consider emulating the appearance of Facebook’s <fb:tabs> using CSS.. read on for our solution.

.fb-tabs { border-bottom: 1px solid #898989; padding: 3px 0; }
.fb-tabs .left_tabs { float: left; padding-left: 10px; }
.fb-tabs .right_tabs { float: right; padding-right: 10px; }
.fb-tabitems {
display: inline;
list-style: none;
margin: 0;
padding: 0;
text-align: center;
}
.fb-tabitems li {
display:inline;
padding: 2px 0px 3px;
background: #f1f1f1 url(http://www.facebook.com/images/components/toggle_
tab_gloss.gif) top left repeat-x;
}
.fb-tabitems li …

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 = 5425 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 = '5425' AND comment_approved = '1'

No Comments »

Incoming: Facebook App Developer tips

Wednesday, August 25th, 2010

I’m doing a lot of Facebook App development lately, and I’m finding the internet to be sorely lacking in good resources for a lot of this stuff. So on this blog in the coming weeks I’m going to feature a few tips for the greater good of the web.

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 = 5424 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 = '5424' AND comment_approved = '1'

No Comments »