Mokka mit Schlag » Web Development

Sometime over the last couple of weeks while I was in Cuba, MySQL corrupted the wp_posts table in my WordPress database. At first I thought I was hacked, but it looks like the database was just corrupted:

mysql> check table wp_posts;
+---------------------------+-------+----------+----------------------------------------------------------------------------------+
| Table                     | Op    | Msg_type | Msg_text                                                                         |
+---------------------------+-------+----------+----------------------------------------------------------------------------------+
| elharo_wordpress.wp_posts | check | warning  | Table is marked as crashed                                                       | 
| elharo_wordpress.wp_posts | check | warning  | Size of indexfile is: 1148225      Should be: 467968                             | 
| elharo_wordpress.wp_posts | check | error    | Can't read indexpage from filepos: 56320                                         | 
| elharo_wordpress.wp_posts | check | Error    | Incorrect key file for table './elharo_wordpress/wp_posts.MYI'; try to repair it | 
| elharo_wordpress.wp_posts | check | error    | Corrupt                                                                          | 
+---------------------------+-------+----------+----------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

mysql> repair table wp_posts;
+---------------------------+--------+----------+----------+
| Table                     | Op     | Msg_type | Msg_text |
+---------------------------+--------+----------+----------+
| elharo_wordpress.wp_posts | repair | status   | OK       | 
+---------------------------+--------+----------+----------+
1 row in set (0.34 sec)

mysql> check table wp_posts;
+---------------------------+-------+----------+----------+
| Table                     | Op    | Msg_type | Msg_text |
+---------------------------+-------+----------+----------+
| elharo_wordpress.wp_posts | check | status   | OK       | 
+---------------------------+-------+----------+----------+
1 row in set (0.08 sec)

I think I’ve fixed this now, but do let me know if you see any lingering problems. Hmm, it does look like the categories may be borked too. I’ll look at that next.
(more…)

I discovered that there is an android app for working with a WordPress blog,’s and it seems to work pretty well. However, as with all tablet apps for real limitation is an import. Stste I’m attempting to use Nuance voice recognition here, and in some sense is working surprisingly well; although just report me to keep tapping the screen to add a new sentence after every time I Parks. I have to figure out if there some way to correct the voice recognition and to learn from my voice as areas with the desktop version of Dragon. However, the voice recognition is surprisingly good; and I would rated about on par for the desktop version I’ll bean someone easier to use. It definitely seems superior to the version of Dragon for the Mac, and maybe on par with the version for windows. PS Ethan and I am deliberately leaving a lot of mistakes in place so you can see just how gorgeous this is or is not. BottomLine: Hses is actually just suffer writing a first draft of the text heavy, formatting for post ; but it’s not your replacement for real keyboard.

And for comparison sake, here’s the edited version of the post:
(more…)

I’ve updated this site and The Cafes to version 3.0.4 of WordPress to close a reported security hole. Everything seems functional, though the admin page does take forever to load. Anyone know how to fix that? Otherwise let me know if you notice anything strange.

Every few months someone asks to buy a license to some old course notes I wrote. Usually it takes a few days for me to get around to invoicing them, packing up the zip files, and e-mailing them. I’d like to make this more automatic.

What services do folks recommend for selling basic files? i.e. zip files? I don’t need DRM or anything fancy. However I do want it to be hands off after I upload the files. Also, my sales volume is low so no monthly fees is a must. I am willing to pay a reasonable percentage of the transaction or per-megabyte sold charge.

I’m not looking to make a great deal of money, or become an online store, just automate the delivery and download process a little more so it’s a bit easier to buy from me. Any ideas?

If this blog goes dark, you’ll know why. This always scares me. I wish WordPress had reliable XML export and import, not SQL.

I upgraded The Cafes yesterday. The automatic upgrade failed, but manual upgrade seems to have succeeded.

OK. Seems like the upgrade completed successfully. Holler if you notice any problems. I think I’ll spend the rest of the morning straightening out the old computer mess as part of my general effort to simplify, clean up, and declutter my apartment.
(more…)

I’m finally getting serious about moving away from pair.com. I’m not sure who to host with though. Minimum requirements are:

• WordPress support (i.e. I can install it; they don’t have to provide it though it’s cool if they do).
• Full root access to WordPress: I can install my own themes and plugins and do my own database dumps.
• No fixed bandwidth, storage, transfer, or CPU time quotas (I’m willing to pay for more as I go up in usage, but I need to be able to handle spikes without the ISP turning off my site.)
• Hosted under my own domain name.
• Regular, reliable backups

The more I think about it, the more I suspect I don’t even want a shell account. I really want a managed WordPress account, preferably hosted in at least three data centers on different continents with hot switching. (Is that even possible? ) Who offers this?
(more…)