Skip to the Main Content

Note:These pages make extensive use of the latest XHTML and CSS Standards. They ought to look great in any standards-compliant modern browser. Unfortunately, they will probably look horrible in older browsers, like Netscape 4.x and IE 4.x. Moreover, many posts use MathML, which is, currently only supported in Mozilla. My best suggestion (and you will thank me when surfing an ever-increasing number of sites on the web which have been crafted to use the new standards) is to upgrade to the latest version of your browser. If that's not possible, consider moving to the Standards-compliant and open-source Mozilla browser.

March 6, 2003

The Back End

In the interests of greater efficiency and data integrity, I converted to a MySQL backend from the default Berkeley DB.

If you want to try that, and have implemented ThreadedComments, be sure to modify the database schema before running mt-db2sql.cgi (i.e., don’t make the same mistake I did).

You need to add two columns and an index to the database:

--- schemas/mysql.dump.orig   Thu Mar  6 12:45:41 2003
+++ schemas/mysql.dump        Thu Mar  6 12:48:05 2003
@@ -80,12 +80,15 @@
     comment_email varchar(75),
     comment_url varchar(255),
     comment_text text,
+    comment_subject text,
+    comment_parent_id integer,
     comment_created_on datetime not null,
     comment_modified_on timestamp not null,
     comment_created_by integer,
     comment_modified_by integer,
     index (comment_created_on),
     index (comment_entry_id),
+    index (comment_parent_id),
     index (comment_blog_id)

Anybody know how stable MySQL 3.23.55 is under MacOSX? Will I need to check periodically to see if the daemon has died?

Update: A couple of things did break.

  • <$MTEntryBody smarty_pants="2" process_tags="1"$> worked before the upgrade, but caused rebuilds to fail after upgrading. Re-ordering it to <$MTEntryBody process_tags="1" smarty_pants="2"$> fixed the problem (you can imagine how long it took to figure this one out!).
  • The mt-rssfeed plugin now requires an explicit choice of directory where the RSS feeds are cached. It defaulted to the db directory when using Berkeley DB. But now, with no path specified, rebuilds would “work,” but no RSS feeds would appear.
Posted by distler at March 6, 2003 3:23 PM

TrackBack URL for this Entry:

3 Comments & 0 Trackbacks

Re: The Back End

Just a comment (mainly to test whether the “Remember Me” cookie really is persistent now).

The MySQL database seems to be rock-solid. Makes me think about other things I could do with it…

Posted by: Jacques Distler on March 9, 2003 11:01 AM | Permalink | Reply to this

Re: The Back End

Egads! Doesn’t seem to be setting a cookie at all, now.

Posted by: Jacques Distler on March 9, 2003 11:40 AM | Permalink | Reply to this

Re: The Back End

Ah! This article explains how to do it in an XHTML-friendly way.

Posted by: Jacques Distler on March 9, 2003 10:26 PM | Permalink | Reply to this

Post a New Comment