Recently after my hosting provider hard-booted one of my machines the MySQL service started to complain “Failed To Read Auto-Increment Value From Storage Engine” when an insert was issued to any table with an auto increment field. I found the solution here, and it basically requires you to reset the auto increment key on the table, like this:
ALTER TABLE `table_name` AUTO_INCREMENT =1
I had to do that on all of my tables that had auto increment keys to resolve the issue.
I found the configuration setting in the documentation that will force phpMyAdmin to automatically track tables during and after creation. It is:
$cfg['Servers'][$i]['tracking_version_auto_create'] boolean
And the default value is ‘false’. I updated:
/var/www/www.progclub.org/pcma/config.inc.php
With the line:
// JE: 2011-09-07: force tracking $cfg['Servers'][$i]['tracking_version_auto_create'] = true;
Linus has moved Linux to GitHub.
Found this article today, How does “this” keyword work within a JavaScript object literal?. It describes various ways of calling a function in javascript, and explains what the ‘this’ context will be in each case.
A pretty nifty feature of MediaWiki tables is the class=”wikitable sortable” specification. Adding the ‘sortable’ class automatically makes the table sortable. Handy!
I’ve updated our Members table as well as a few other tables on the wiki to use the ‘sortable’ feature.
I was doing some research about free software licenses as a part of developing ProgClub’s terms and conditions, and found this list of free software licenses from the FSF, and the same list of FSF approved software licenses on Wikipedia. I noticed the cool table sorting facility they have on the Wikipedia page, and wonder if that’s built in to MediaWiki..? It would be cool if it only required a class specification to have it work like that.
I’m working through Zed Shaw’s Learn Python The Hard Way, and I’m up to exercise 5. Doing the extra credit 3 involved searching online for Python format strings, and I found that there is the old way, which is presumably what Shaw wanted me to find, and also the new way in which a new scheme for string formatting is provided.
Was helping Teejay with his Cock n Bull web-site the other night, and we needed to setup a ‘page’ link in the top main navigation as a ‘link’ to the blog feed. Anyway, we found a WordPress plugin that does that: Page Links To. Pretty handy!
After spending the afternoon investigating MediaWiki templates, I’ve decided that for the most part they are more trouble than they’re worth for any of my applications. I tried to create a ‘done’ template, that took username, user initials, date and ‘done note’ parameters, but really the code to call the template was just as long as not using the template, and the template broke when the ‘done note’ included a link that included an equals sign, which is just too shoddy. I’m giving up on templates until I find I actually have a use for them where the technology solves a problem that I actually have. At the moment that’s nothing.
Today, after a long time, I am finally ready to learn about MediaWiki templates. After having put that off for weeks since I’d first heard of them, I found that it only took about five minutes to learn just about everything there is to know about them from the MediaWiki templates documentation. I think there are a few areas of the ProgClub wiki that could do with the use of templates, might go and see to that now.