Two days ago, out of nowhere, a particular table in the WordPress in hongkiat.com went corrupted. The ‘wp_comments‘ table of the WordPress database just crashed without signs, warnings nor error messages. So how did I came to know? Here are the symptoms: If you try to back up your database, you’ll be thrown with this [...]
Two days ago, out of nowhere, a particular table in the WordPress in hongkiat.com went corrupted. The ‘wp_comments‘ table of the WordPress database just crashed without signs, warnings nor error messages. So how did I came to know? Here are the symptoms:
- If you try to back up your database, you’ll be thrown with this error message – wp_comments is marked as crashed and should be repaired when using LOCK TABLES
- Recent comments widget appears blank.
- Top commenter widget appears blank.
- Comment posted will not be written into DB, therefore will not be shown.
- Comments section in WP Admin appears to have zero records.
After searching the Internet high and low in hoping to find similar cases to help me identify and fix the problem, I end up with nothing. So I tried it my way and luckily enough, I managed to solved it. I thought writing the entry out will not only help those who suffered the same, also keep myself reminded just in case I hit on this error again in the future.
The fix / Solution
To fix this, you must have access to the wordpress database, either via PhpMyAdmin or Secure Shell (SSH). Most shared hosting account comes with phpMyAdmin, but either option you should be extremely careful because you dealing with the database. Any wrong move will cause more data lost.
PhpMyAdmin

In PhpMyadmin, select the WordPress database and look for the error table. In my case, the ‘wp_comments‘ table. Check it, and scroll all the way down and look for ‘With selected‘ drop-down box. Select Repair table and things should be alright.
Secure Shell

- Login to your shell
- Enter ‘mysql -u username -p database_name‘ to access databases
- Enter ’show databases;’ to view all databases
- Enter ‘use database_name;‘ to engage the database
- Enter ‘show tables;‘ to show all tables within the database
- Enter ‘check table wordpress_table_name‘ to verify this is the corrupted table
- Fix it with ‘repair table wordpress_table_name‘
- Enter ‘check table wordpress_table_name‘ again to make sure it’s fixed
Step 3 and 5 are not necessary if you are familiar with your databases and tables. Hope this helps.
here’s the WordPress theme that gets very close to a Mac OS X Leopard – Leopress. Leopress tries to look like the Mac’s Finder, and I think it’s pretty close. One good reason why you will want to use WordPress themes that mimic other interface is – it kinda camouflage your blogging activity, hiding them [...]

here’s the WordPress theme that gets very close to a Mac OS X Leopard – Leopress. Leopress tries to look like the Mac’s Finder, and I think it’s pretty close. One good reason why you will want to use WordPress themes that mimic other interface is – it kinda camouflage your blogging activity, hiding them from bosses or superiors who passes by.
If you are still struggling on how to insert PHP Codes inside particular blog post, page or a widget sidebar for execution; the following tutorial is for you. Executing PHP codes in WordPress Page/Post Installation Download phpexec.txt Rename phpexec.txt to phpexec.php Upload to /wp-content/plugins/ directory Activate the plug-in from WordPress administration menu Usage Anywhere in [...]

If you are still struggling on how to insert PHP Codes inside particular blog post, page or a widget sidebar for execution; the following tutorial is for you.
Executing PHP codes in WordPress Page/Post
Installation
- Download phpexec.txt
- Rename phpexec.txt to phpexec.php
- Upload to /wp-content/plugins/ directory
- Activate the plug-in from WordPress administration menu
Usage
Anywhere in your post/pages where you want to execute a PHP Codes, insert <phpcode> before your php codes and </phpcode> your php codes.
<phpcode>
<?php
echo "Current date and time: ";
echo date("l dS of F Y h:i:s A");
?>
</phpcode>
Security
If you are running a blog with multiple users, you need to determine who can run this plug-in. Alter the settings in your Administration Menu. Options -> PHPExec
Executing PHP codes in WordPress widget sidebar
Installation
- Download execphp.txt
- Rename execphp.txt to execphp.php
- Upload to /wp-content/plugins/ directory
- Activate the plug-in from WordPress administration menu
Usage
This plug-in work like a normal text widget except that it allows execution of PHP Codes. You can create up to 9 instances of this widget. 
people wanting to know how to create a WordPress theme. Here’s some resources I’ve found useful for putting one together: Graphic design: Useful to have: Photoshop/Fireworks or the like to create your graphics For inspiration: sites like Netdiver, Design Melt Down, CSS Beauty, Unmatched Style etc can help sometimes. Color scheme ideas: Colorschemer, Daily Color [...]
people wanting to know how to create a WordPress theme. Here’s some resources I’ve found useful for putting one together:
- Graphic design:
- Useful to have: Photoshop/Fireworks or the like to create your graphics
- For inspiration: sites like Netdiver, Design Melt Down, CSS Beauty, Unmatched Style etc can help sometimes.
- Color scheme ideas: Colorschemer, Daily Color Scheme and Flickr (photos are a brilliant source for color combinations). Flip through your favourite magazines (I love looking through my How Magazines and books for ideas. Look at how you’ve designed your house/bedroom/office – what color combinations do you like?
- Fonts: DaFont for free fonts and Linotype for purchasing professional fonts.
- Images: SXC for free photos and iStockPhoto for inexpensive illustrations and photos.
- XHTML/CSS templating:
- W3Schools for learning or for quick reference.
- Firefox web developer toolbar – essential for checking and testing your code. Great for live changing of your CSS.
- A text editor like Notepad++ to write your code.
- Browser Shots – for testing your design in different browsers
- For reference: Listamatic, Layoutomatic, Practical CSS and A List Apart in general, CSS Zen Garden for insight into how to achieve different layouts and effects using CSS and Layout Gala
- Understanding how WordPress themes are put together. I can’t emphasise enough how important the WordPress manual is. Don’t miss the Stepping into templates information.
- Understanding “the loop” and various WordPress tags.
- Knowing when and how to install plugins. WP-Plugins.net has many plugins, but doing a Google or delicious search for “Wordpress plugin” and then the type of plugin you’re wanting will help you find many others.
- Knowing at least a little bit of PHP if you don’t want to feel so scared by WordPress tags, the loop, plugins and your templates. There’s some tutorials on W3Schools which can help.
Have you found any others which you find essential?
code 1 javascript:document.body.contentEditable=’true’; document.designMode=’on’; void 0 input this in your url bar, then you can edit the website you are viewing. code 2 javascript:document.body.contentEditable=’false’; void 0 exit
code 1
javascript:document.body.contentEditable='true'; document.designMode='on'; void 0
input this in your url bar, then you can edit the website you are viewing.
code 2
javascript:document.body.contentEditable='false'; void 0
exit
(Internet Security 2008) activation code: D6CD43667B2E56BD7D10 F5FB27987FF6A926D3A4 BC79FEAF086844F21913 0C29107D9ED1B985EF1B (AntiVirus Security 2008) activation code:5B389228049A156899AF E7BD554B5A7156792F36 66EE85E3672BC0F0776D B06C49D4C3060ED08040 Total Security 2008 activation code: 57E683ECF07BAA56B7F0 68CE6485F3C946D1FEFC 664D2A35D28FA0F7DDA1 74D3F71A3754881D3241 Bitdefender 9 Family (Internet Security 9) activation code:9B501-5F6A1-E804A-DBFB2 7E015-0D871-E6773-902A7 (Professional 9) C883F-918AF-1B2F9-31B86 8AB75-B93C7-D7C2B-87C1A Bitdefender 10 Family(Internet Security 10) activation code:1CF8405B3C66078A437C 8107CA7590D58FB2B0FB (Antivirus Plus 10) AEAC327DD6632EA1A89B D29D3ADB10A14E2A5840
(Internet Security 2008) activation code: D6CD43667B2E56BD7D10 F5FB27987FF6A926D3A4 BC79FEAF086844F21913 0C29107D9ED1B985EF1B
(AntiVirus Security 2008) activation code:5B389228049A156899AF E7BD554B5A7156792F36 66EE85E3672BC0F0776D B06C49D4C3060ED08040
Total Security 2008 activation code: 57E683ECF07BAA56B7F0 68CE6485F3C946D1FEFC 664D2A35D28FA0F7DDA1 74D3F71A3754881D3241
Bitdefender 9 Family (Internet Security 9) activation code:9B501-5F6A1-E804A-DBFB2 7E015-0D871-E6773-902A7 (Professional 9) C883F-918AF-1B2F9-31B86 8AB75-B93C7-D7C2B-87C1A
Bitdefender 10 Family(Internet Security 10) activation code:1CF8405B3C66078A437C 8107CA7590D58FB2B0FB (Antivirus Plus 10) AEAC327DD6632EA1A89B D29D3ADB10A14E2A5840
NetBeans Refer-a-Friend Promotion Introduce Friends to the NetBeans IDE, Get a 2GB USB Drive! The NetBeans IDE has always enjoyed word-of-mouth success—developers tell their friends about how the tool has radically improved their development experience, and then recommend that their friends give the IDE a try. We want you as a new user to be [...]
NetBeans Refer-a-Friend Promotion
Introduce Friends to the NetBeans IDE, Get a 2GB USB Drive!
The NetBeans IDE has always enjoyed word-of-mouth success—developers tell their friends about how the tool has radically improved their development experience, and then recommend that their friends give the IDE a try. We want you as a new user to be a part of this movement. The good news is: we will reward you for it!
Tell your friends about the NetBeans IDE, and if they download the IDE as a result we send you a 2GB USB drive preloaded with selected NetBeans Documentation, as well as OpenOffice, Sun’s free and popular productivity suite!
Spread the word today about the NetBeans IDE and claim your gift!
http://www.netbeans.org/competition/refer-a-friend/index.html
This is a translation of a chinese song, i really love this song, it’s so blue. But i think i am not good translator…
This is a translation of a chinese song, i really love this song, it’s so blue.
But i think i am not good translator…






Recent Comments