Category: Software

Office 2007 and the Live Office Popup window keeps popping up. Here’s how to remove it.

Have office? Want to get rid of that annoying “have you tried live office yet?” popup, that just doesn’t go away?

Create a new file on your desktop, called “officefix.txt”

Paste this into it;

Windows Registry Editor Version 5.00


Then rename that file to “officefix.reg”

Double click it to add it to your registry.

Re-run word, powerpoint, or whatever.

Thank me in the comments.

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

if (is_array($_POST[“criteria_values”])) {
# The following code checks for null values in the criteria_attribute array and removes them
$values = $_POST[“criteria_values”];
foreach ($values as $key=>$value) {
if (!$value) {
array_splice($values, $key, 1); // Remove null value from array
$values = join(“, “,$values);
# $values = join(“, “,$_POST[“criteria_values”]);
} else {
$values = $_POST[“criteria_values”];

Now everything should work, with no more mysql errors!

Illustrator or Photoshop “Unknown Error” when saving or can’t use type tool. Fixed!

No thanks to Adobe, even after numerous complaints going all the way back to Creative Suite 1, if you have a bad font on your system, you may have issues saving as an .ai in Illustrator. You’ll get the dreaded “an unknown error has occured”.

If you disable PDF compatibility, it will save, but that’s not good enough!

You may also have a problem in Photoshop, where whenever you try and type on the canvas, it says an unknown error has occured in the font rendering engine or something to that effect. Again, similar error, stupid Adobe.

Turns out if you go to your fonts directory, hit CTRL-A to select all items, then go to the file menu, “copy fonts to” and select a folder on your desktop. Copy all the fonts to this folder, wait till it’s done.

Now go ahead and download a free trial of Font Agent for Windows. And let it analyze all your fonts. It will tell you which fonts are bad.

Go back to your windows font directory, delete the bad fonts. Restart Photoshop, or illustrator, and you should be able to save again.

This comes after probably 6 hours of trying different fixes with the transparancy settings, the font cache, font .lst files, adobe presets deleting, app setttings deleting, etc this is the only thing that fixed it.

Maybe it’d be nice if Adobe included a little “verify my fonts” checkbox and alerted us to bad fonts. That’d probably be too easy though.