Small progress in my wiki explorations and a fix to my MediaWiki administrative user email address

I’d looking into maintaining a wiki a while back and have recently been determined to get back to it. As a result, I’ve been looking at TiddlyWiki since that’s what some of Kicks Condor‘s group has been using. (Yep, I’ve still got that tab opened and am tinkering away slowly on the ideas–but mostly the technology.)

I’ve been having some issues in self-hosting a TiddlyWiki the way I’d like to. If anyone has any clear cut documentation on how to host a TiddlyWiki on one’s own domain name, I’d appreciate it. The documentation doesn’t seem as clear as I would expect (or perhaps more likely my server is having issues propagating/connecting?). If anything it’s muddled by the fact that they can seemingly be hosted in dozens of places one might not otherwise expect. My primary reservation is that it looks to me like they’re designed as single user instances, so I’m not exactly sure how Kicks et al. are effectuating their hyperconversations. Part of my issue is my mental model of some of the wikis involved in addition to the busy-ness of the sites’ themes, not to mention some of the non-standard conversational style on some. (I’ll get there eventually.)

I’ve also been using the IndieWeb’s MediaWiki for several years, so I’ve become much better at how it works as well as the ins-and-outs of the markup and how to do some slightly more advanced things using it. I’d set one up nearly a year ago this month and used it sporadically at best.

One of the bigger problems with my MediaWiki install was that somehow I wasn’t able to log into the primary account to do some of the necessary administrative functions. Today I got fed up with being hampered a bit and went spelunking into my install to see where things went wrong, suspecting that it was a one button install issue.

After digging through some documentation, I dug into the mySQL database and found a daunting looking [Blob] in the user_email field. Why couldn’t it be an easy-to-edit field? I not knowing anything better to do, I downloaded it, opened it up in my text editor, and discovered that I’d managed to leave a letter out of my own name in the email address! No wonder it wouldn’t work and the system wouldn’t let me reset my email address or password. A quick text edit later, the email was fixed, I uploaded the (now less intimidating) [Blob], and did a reset of the password in the admin interface, and we’re back in business! I’m always glad not to have borked the entire database and site.

If nothing else, it’ll help me in my explorations. Onward.

My website is closing in on 17,000 posts (this one will make it 16,998), so I was looking at the gargantuan size of my database. When you’ve got this many posts and 17,160 comments, I’m thinking that just my Akismet (anti-spam) meta data is somehow actually larger in size than some people’s  entire blogs. I’ve backed it all up and am going through and cleaning out some unused digital exhaust to give me some room to grow.

Who knew that in owning your own data you could accumulate so much of it?!

📖 Read pages 55 – 86 of 776 of Learning PHP, MySQL & JavaScript with JQUERY, CSS & HTML5 by Robin Nixon

📖 Read pages 55 – 86 of 776 of Learning PHP, MySQL & JavaScript with JQUERY, CSS & HTML5 by Robin Nixon

I’ve been promising myself that I would do some brushing up on programming skills this year and this seems like a fairly reasonable text with some simple examples.