WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE ID IN (11,10) GROUP BY ID

Open AJAX » 2005 » June

Archive for June, 2005

Watch out! Mistakes!

Monday, June 6th, 2005

More mistakes from from the infamous Alex. While obvious, it is important to articulate these truths so that even the most basic code writer or copy-n-paster will follow this wisdom.
I’d like to note that there are several issues with AJAX, but also IMMENSE FLEXIBILTY!
For a lot of people, unless you’re building a GMail or […]

WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 11 AND comment_approved = '1';

WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '11' AND comment_approved = '1'

No Comments »

Simple Event Hooks

Wednesday, June 1st, 2005

OpenAJAX Sample 3 works through some Event Handling. Mouse clicks - Right & Left; and Key Presses. Trying right-clicking on the body of the page, then try another right-click over the <input > element. Also if you press some keys, you’ll see the code and the character value displayed.

WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 10 AND comment_approved = '1';

WordPress database error: [Table './openajax/wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '10' AND comment_approved = '1'

No Comments »