Reggie Thomson’s Diary

Diary of a Digital Photographer

December 31st, 2006

Dreams, not resolutions

I’m way too wimpish to write resolutions for 2007, so instead here are some dreams:

WordPress

  • Convert my photography blog to a daily-updated blog with simple theme
  • Develop multi-lingual sites based on Gengo
  • Develop geo plug-in to have gpx uploads, kml for maps.google.com
  • Create a page template for WordPress to allow eg photo reviews, movie reviews
  • Increase commercial sites on server using WordPress

Server:

  • WikiMedia installation
  • Imagemagick

Hobbies:

  • Dancing - improve by going to classes
  • Chinese - perhaps private exchange only
  • Japanese - not sure yet - bilingual photo blog if it doesn’t drain too much time
  • Cooking - maybe I’ll earn enough money to take up entertaining again

Photography

  • Get permission to take commercial photos in Cambridge
  • Take lots more photos
  • Improve knowledge of Photoshop
  • Improve commercial aspects of website
  • Tidy up website to improve css and html structure

House:

  • I need a wiki for this, not a static blog
December 29th, 2006

Invalid XHTML due to DupPrevent with upper-case META

The plug-in DupPrevent gave me a failure when trying to validate my HTML using validator.w3.org.

It has the tag META in upper-case. According to www.w3.org it should be lower-case for XHTML 1.0.

I’ll write a comment on the author’s page.

December 29th, 2006

Installing phpBB2 v2.0.22

I’m installing phpBB2 on several websites. These are my installation notes.

First attempt - tried to use “Attempt to FTP config file into place” option, but I seemed to go round in circles - “Finish” just led to the install again.

Prior to the second installation, I removed all tables from the database, and reconfirmed that the default collation was “utf8_general_ci”.

Second time round I chose to “Just send the file to me and I’ll FTP it manually”. After clicking “Download Config”, you remain on that page (nothing changes).

I FTP uploaded the config.php file. Then I removed install/update_to_latest.php, install/install.php and install/upgrade.php as per phpBB user guide.

I ignored the line “Additionally you may delete the db/schemas and this docs/ directory if you wish.” I assume it means the “install/schemas” directory, and there is no need to delete “docs”.

Running the http://www.mydomain.com/forum/ I got the message:

Please ensure both the install/ and contrib/ directories are deleted

I deleted these with FTP.

Installation worked a treat

December 29th, 2006

Removing Joomla

I have decided not to install and support Joomla.

Some of the reasons are:

  1. The current version of Joomla (1.0.12) was based on TABLEs rather than DIVs
  2. The Beta version (1.5) did not integrate with SMF forums
  3. The administrator panel was complex - possibly too complex for non-IT personnel
  4. I will use WordPress as a general CMS instead.
December 27th, 2006

More changes necessary for full converstion to UTF8

I’ve just noticed that individual tables are set to the wrong collation in phpmyadmin. I will have to search through each table in every database and convert all the text and varchar settings.

December 27th, 2006

Gengo giving a database error

I’ve updated another blog, and get the following error


WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
SELECT category_nicename AS original, sanitised FROM wp_chinese_categories c INNER JOIN wp_chinese_cat2syn syn ON c.cat_ID = syn.cat_id WHERE c.category_nicename IN ('classes') AND syn.language_id =....

I thought it was an Ultimate Tag Warrior problem, but it is just a Gengo installation problem - I had the plug-in activated, but hadn’t set the default languages.

December 27th, 2006

Converting MySQL collation to UTF8

I decided I had to change all the collations on the databases and tables.

Using phpMyAdmin, I ran the command


show databases

Then I copy the results to Textpad and use the following regular expressions:


# ^([^#^\n])(.*)\n => \1\2\n\n
# ^([^#^\n])(.*)\n => ALTER DATABASE \1\2 COLLATE utf8_general_ci ;\n

Similarly for each table in each database:


show tables

# ^([^#^\n])(.*)\n => \1\2\n\n
# ^([^#^\n])(.*)\n => ALTER TABLE \1\2 COLLATE utf8_general_ci ;\n
December 26th, 2006

Current list of plug-ins used with WordPress

Plugin Version Description
Adsense-Deluxe 0.8 Place Google AdSense ads in your WordPress Posts. Requires WordPress 1.5 or higer. For complete usage and configuration click on AdsenseDeluxe under the “Options” menu. By Acme Technologies.
Akismet 1.2.1 Akismet checks your comments against the Akismet web serivce to see if they look like spam or not. You need a WordPress.com API key to use this service. You can review the spam it catches under “Manage” and it automatically deletes old spam after 15 days. To show off your Akismet stats just put <?php akismet_counter(); ?> in your template. By .
Audio player 1.2.3 Highly configurable single track mp3 player. By Martin Laine.
Code Auto Escape 2.0 Automatically escape code within <code>…</code> tag By Priyadi Iman Nurcahyo.
Dean’s Code Highlighter 1.1 this plugin using Geshi to highlight source code in your posts. . By Dean Lee.
DupPrevent 1.0 DupPrevent eliminates duplicate content from google index. For comments and feedback click here. By WPSEO.COM.
Emotions 1.9 在用??注中添加表情符号 By Xenium & andot.
Event Calendar 3.1.0 Manage future events as an online calendar. Display upcoming events in a dynamic calendar, on a listings page, or as a list in the sidebar. You can subscribe to the calendar from iCal (OSX) or Sunbird. Change settings on the Event Calendar Options screen. By Alex Tingle.
Event Calendar Widget 3.1.0 Adds sidebar widgets for Event Calendar and Upcoming Events. Requires the EventCalendar and Widget plugins. After activating, please visit Sidebar Widgets to configure and arrange your new widgets. By Darrell Schulte.
FAlbum 0.6.9 A plugin for displaying your Flickr photosets and photos in a gallery format on your Wordpress site. By Elijah Cornell.
Gengo 0.8 Multi-language blogging for WordPress.Licensed under the MIT License, Copyright © 2006 Jamie Talbot. By Jamie Talbot.
Geo 1.9.1 Attaches geographic coordinate information to posts. By Owen Winkler.
Google Search widget 1.0 Adds a sidebar widget to let users search your site with Google. By Automattic, Inc..
Google Sitemaps 3.0b4 This generator will create a sitemaps.org compliant sitemap of your WordPress blog. Configuration Page By Arne Brachhold.
Gravatars 2.6 This plugin provides an administrative interface to control default gravatar options. Registered users can also (optionally) define local gravatar images that will override their gravatar.com default. Copyright 2005 Scott Merrill; Licensed under the terms of the GPL. By Scott Merrill.
My Tube 1.0 Plugin to integrate youtube with WordPress By Vaam Yob.
Organizer 1.2.1 Organizer is a simple plugin to view and manage your upload folder files. By Imthiaz.
Recent Comments Widget 4.0 This plugin will add a list of the most frequent comments posted to your blog. They are gathered in descending order (newest at the top), but then group them together by post title, so that comments from the same post are listed together. The list items will be links to the comments, and will contain the name of the commenter. Derived from the “Top/Recent Commenters” plugin by Scott Reilly (http://www.coffee2code.com/wp-plugins/) By Jared Bangs.
Search Everything 2.5 Oct23 Adds search functionality with little setup. Including options to search pages, attachments, drafts, comments and custom fields (metadata). By Dan Cameron.
Sidebar Widgets 1.0.20060711 Adds “Sidebar Widgets” panel under Presentation menu By Automattic, Inc..
Social Bookmarks 3.1 Social Bookmarks adds a list of XHTML compliant graphic linkss at the end of your posts that allow your visitors to easily submit them to a number of social bookmarking sites. Use plugin options (In menu Options>Social Bookmarks) to configure the plugin. By Apostolos Dountsis.
Subscribe To Comments 2.0.8 Allows readers to recieve notifications of new comments that are posted to an entry. Based on version 1 from Scriptygoddess By Mark Jaquith.
SyntHihol 1.1 Syntax highlighting using Geshi. Sythihal is small, simple, and doesn’t require Enscript installed on the server. By Jay Tuley.
Ultimate Tag Warrior 3.141592 Ultimate Tag Warrior is a tagging plugin, that’s heavy on tag visualisation. I Like Pi! By Christine Davis.
WordPress Database Backup 1.8 On-demand backup of your WordPress database. By Scott Merrill.
WordPress Mobile Edition Redirect mobile devices to a mobile friendly interface. Version 1.8, compatible with WP 1.5.x/2.x. By Alex King.
WP-Amazon 1.3.2 WP-Amazon adds the ability to search and include items from Amazon to your entries. This plugin adds a button called “Amazon” on the post page. Make sure to configure the plugin before using. By Rich Manalang.
wp-cache 2.0.19 Very fast cache module. It’s composed of several modules, this plugin can configure and manage the whole system. Once enabled, go to “Options” and select “WP-Cache”. By Ricardo Galli Granada.
WP-ContactForm 1.4.3 WP Contact Form is a drop in form for users to contact you. It can be implemented on a page or a post. It currently works with WordPress 2.0+ By Ryan Duff.
WP-Translate 2 (September 6, 2005) Translate your site to any language using Google By Scott Hough.
WPG2 2.0 Embeds Gallery2 within Wordpress to share photos, videos and any other Gallery2 content seamlessly into your Blog & Sidebar Content. Documentation, Support Forums. By Ozgreg help and invaluable support by WPG2 Team.
WPG2 Random Image 1.0 Adds a sidebar widget to display a ramdom image from a WPG2 album By Javier Rodriguez.
WPG2 Sidebar Grid Block 1.0 Adds a sidebar widget to display WPG2 gallery By Javier Rodriguez.
WP Paginate .2.2 Create pagination for pages By Jennifer - Scriptygoddess.
December 26th, 2006

Error in live-comment-preview

Looking in my error logs, I see:

PHP Notice: Undefined variable: livePreviewDivAdded in /.../wp-content/plugins/live-comment-preview.php on line 24, referer: http://www.fionamacleod.org/ 

It probably explains why “live-comment-preview” didn’t work, and so was deleted from my installation.

December 24th, 2006

Test of code escape and highlighter plug-ins

I’ve tested three:

  1. Dean’s Code Highlighter
  2. Code AutoEscape
  3. SyntHihol

I have reverted to Code AutoEscape, because neither Dean’s CodeHighlighter nor SyntHihol treat single quotes correctly (they get converted to the pretty versions), and neither of them allow for direct copying of the code to put into a text document (Dean’s adds a # at the start of each line, SyntHihol adds the line numbers). I would prefer everything to be put as ordered lists (so you only select the text of the code), and a mixture of SyntHihol and Dean’s formating - Dean’s has a great limit on the text entry, and SyntHihol allows you to see the unescaped version.

Also, I slightly modified the geshi settings for the PHP highlighter.