Semantic Mediawiki Problems

This morning I installed Semantic Mediawiki on a server for the first time and encountered a few problems with permissions. This is a very brief rundown on how I got it installed and how I fixed the problems I encountered...

First off, on installation, I had problems when clicking Initialise or upgrade tables button. To get around these problems, I used the database's root user to install Semantic mediawiki by changing the $wgDBuser and $wgDBpassword parameters in teh LocalSettings.php file.

After this, nothing worked. Whenever I tried to execute a semantic query, I got the following error:

...from within function "SMW::getCategoryTable". MySQL returned error "1142: DROP command denied to user ... for table 'smw_newcats' (localhost)".

The solution to this problem is to cd to $WIKIMEDIAROOT/extensions/SemanticMediaWiki/includes/storage and edit SMW_SQLStore.php to make the following modifications...

In function getCategoryTable (~line 1644 in my version):

• #$db->query('DROP TABLE smw_newcats', 'SMW::getCategoryTable');
• #$db->query('DROP TABLE smw_rescats', 'SMW::getCategoryTable');
• $db->query('DROP TEMPORARY TABLE smw_newcats', 'SMW::getCategoryTable');
• $db->query('DROP TEMPORARY TABLE smw_rescats', 'SMW::getCategoryTable');

In function getPropertyTable (~line 1706 in my version):

• #$db->query('DROP TABLE smw_new','SMW::getPropertyTable');
• #$db->query('DROP TABLE smw_res','SMW::getPropertyTable');
• $db->query('DROP TEMPORARY TABLE smw_new', 'SMW::getPropertyTable');
• $db->query('DROP TEMPORARY TABLE smw_res', 'SMW::getPropertyTable');

Save the changes, re-execute the query, and everything should be hunky dory.

Fun-filled Fourth and More

This has been an eventful weekend. First, the fourth of July. It began, as many of my days recently have, at around 4:45 AM. Somehow, I felt ridiculously functional, and decided to make my computer more useful. So, I installed Apache, MySQL, MediaWiki, and LXR. There's more to come on that.

When the rest of the world woke up, people came over and we kayaked. 'We' being the girl, Amanda, Ken, and I. It were fun. Check out our route. Afterward, we cooked enough food to choke a small family of elephants, and somehow did not meet our demise. 'We,' in this case, additionally included Tim and Samantha. We ended up watching the Wedding Singer, and lapsing into restful (I hope) comas following.

Sometime during the day or night, we decided to start rating beers, and needed a place to store the ratings. Fortunately, I installed a wiki on my computer earlier. Some DNS magic later, my friends have access, and we now have a wiki with beer, wine, recipes, and other random junk.

Breakfast came and went the next morning at a nearby diner in Pasadena. I had some tasty french toast. Amanda and Ken left, and Jessie and I then learned that our basement had a stomach ache. Our sump pump was making some seriously sickening gurgling noises. Several trips to Lowes ensued, and we now have a new sump pump. Later, we went to Sandrew's house to begin an enjoyable eve.

At Sandrew's place, we began by taking a tour of the neighborhood on Drew's refurbished electric scooter. Good stuff. I never thought the thing could have been so fun. A bunch more food, enough to choke the former elephant family's giant mutant offspring's family, and then Katie and Jon came over. The girl also jumped in the pool, fully clothed, to rescue a drowning Corona bottle. Because of her hard work, we'll have one more Corona bottle in the world, saved from being one of the many of the horrible statistic of Corona bottles that have drowned in pools.

Sunday: Climbing day! Ken, Amanda, the girl, and I went to Rockville! I love that gym. I wish I lived a bit closer. I'm still sore from climbing. We ate dinner at the Mongolian Barbeque, went back, and waited out the storm at Amanda's place, with ice cream! Thanks Amanda!