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

FreePBX Multi-Language Directory keeps playing "dir_intro" in English instead of your chosen language? Quick Hack to fix it!

Tonight we were debugging a customers PBX system for them because of what seemed like a really simple issue with their company directory. As they are located in a bi-lingual area they wanted to have english and french menus available to them. They use a combination of Asterisk 1.4 and FreePBX 2.5. With this software they already had the Languages module available to them, so they were able to create one main IVR, and then several branching IVR’s dependant on the language that was selected....

January 13, 2009 · 4 min · 744 words · Matt G

Disable Auto Saving and Post Revisions with WordPress

Simply add this to your wp-config.php define('AUTOSAVE_INTERVAL', 600); define ('WP_POST_REVISIONS', 0); Done. No more database fat.

December 27, 2008 · 1 min · 16 words · Matt G

Tutorial: Fixing Kayako’s broken SSL so Gmail can be used without STunnel.

A little while ago we posted an article on configuring STunnel to use with Kayako because SSL over POP3 with Google Mail/Google Applications wasn’t working properly. Today we finally had some time to sit down and think about this and worked out a much better solution that doesn’t require STunnel to be involved in the mix. In the Kayako cron script, they have hard-set a “notls” option when trying to connect to the IMAP or POP3 email servers....

December 10, 2008 · 4 min · 694 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