Mokka mit Schlag » Blogging

I’m in process of doing my usual New Year’s batch of host changes, DNS reroutes, software upgrades and the like. If you notice anything wonky on any of my sites, please drop me an email. Thanks.

If you can see this, then the migration of the site from pair.com to App Engine Standard worked. This was more complex than the equivalent migration of cafe.elharo.com due to the subdirectory and static files.

I still need to repoint the DNS. So far I notice one bug. http://www.elharo.com/blog/ works but http://www.elharo.com/blog doesn’t. Probably need to fix a handler in app.yaml.
(more…)

Does anyone have detailed instructions for how to convert a site such as this one (WordPress + Apache, custom domain, multiple plug-ins, on a shared host, specifically pair.com) to HTTPS?

This is still way too complicated. Might consider moving to another host since the last time I asked pair for help with this they were actively dismissive of the need.

wordpress.com itself is not an option last I checked because they don’t allow plug-ins.

I made a few adjustments to this site’s custom theme (the first in years) and Google at least now sees it as mobile friendly. To make it truly mobile friendly, I need to figure out what to about the sidebar.

(more…)

Let me know if you see any problems.

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…)