Fixing MySQL Error 1064 with PHPList when selecting new criteria

Today we had to fix a clients PHPlist. There was an error in their mysql select statement for whatever reason – whether it was their setup (they had some really weird group names and country names) or something with PHPList. Took us a while to figure it out, but as it turns out someone else had the same issue. Basically the fix is this: # nano /lists/admin/send_core.php Find this if (is_array($_POST["criteria_values"])) { $values = join(", ",$_POST["criteria_values"]); } else { $values = $_POST["criteria_values"]; } and replace it with this...

January 29, 2009 · 1 min · 153 words · Matt G

Getting Sendmail to work with Rogers and Smarthost settings

I didn’t do this myself so I can’t vouch for it, but there was a recent discussion on one of the mailing lists I’m on about getting Sendmail to work with Rogers Smarthost settings. Apparently this howto: http://www.newthink.net/2007/05/18/smarthost-authentication-with-sendmail/ Will get you going, but there is one critical change you must make as determined by the Hugo on the mailing list. Don’t forget to use smtp-rog.mail.yahoo.com in authinf and not smtp.broadband.rogers.com!...

November 11, 2008 · 3 min · 486 words · Matt G

Installing Custom Themes with Trac 10.x. Beautify your Development and set yourself Apart.

Ever wanted to install a new theme to your TRAC installation? Often we’ll want our development environments to look a little different from every other trac site on the Internet. We’d never tried to change the theme before, so decided to write a small tutorial on how it’s done for our archiving purposes, and for anyone else that wants to change their TRAC theme. We’re using Ubuntu Linux, and this tutorial assume you’ve already installed TRAC on a global basis to your development server....

November 2, 2008 · 2 min · 408 words · Matt G

Tutorial on how to Install Apache, Subversion and Trac with Virtual Hosting suppor in Ubuntu Linux

We recently had to setup Apache, Subversion and Trac all within a virtual hosting environment for one of our Clients to be able to develop easily and effictively among team members. They wanted to use multiple domain names for separate projects. Made sense to us, so we started looking for instructions on setting this up. We wanted to setup LigHTTPD, however it’s not nearly as easy because of no svn-dav module available, so we stuck with Apache 2 for now....

November 2, 2008 · 5 min · 941 words · Matt G

Installing Habari Blog on Ubuntu Server to Replace WordPress

You may have heard of Habari, you may not have. It’s yet another blogging software, written from the ground up to take advantage of all the latest technologies available. For this reason it’s not supported everywhere and probably is why you haven’t heard of it yet. I think this software could replace WordPress if done correctly, it will just take some time to get a little more robust, but the guts of it is definately there....

October 29, 2008 · 3 min · 569 words · Matt G