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

YieldBuild Comparison Results for 30 Day Test

While we love the guys over at Yieldbuild, and we love the idea behind their software we’re just not sure all the bugs or worked out, or it’s completely possible that the site we’re trying it has far too low traffic to make a difference. We had decided to run a test with YieldBuild for 30 days vs regular adsense. Here’s what we came out with: Nov 15 – Dec 15 Adsense Only...

January 18, 2009 · 1 min · 176 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