Awesometoast.com

The multipurpose website of Aaron W. Herd

Posts in the "Fixing Stuff" category ↓

Make MySQL’s UNIX_TIMESTAMP() work in PostgreSQL

And FROM_UNIXTIME(), too!

Maybe you’re like me, and you’re migrating something from MySQL over to PostgreSQL. Maybe, like me, you’re swearing a great deal and experiencing high blood pressure, too.
(Or maybe not.)

I’ve seen numerous threads that just tell you how you can change all your code to use Postgres’s epoch_something_something_aint_nobody_got_time_fo_dat() function instead, but epic hero Janusz Slota has a better way. He shows you how to, rather easily, make it possible to run … Keep reading »

Posted under: Fixing Stuff | No Comments »

iTunes 11: Restore track skipping with Repeat One turned on (OSX)

In iTunes 10, you could skip to the next/previous track when Repeat One was turned on. In 11, they assume that by “skip ahead”, you really mean “rewind this track”.

This really bothers some people.
Do not judge us, we have our reasons!

And here’s one way to fix it.

It took some work, but I finally came up with some AppleScript to handle this. Basically, we’re checking to see if … Keep reading »

Posted under: Fixing Stuff | 2 Comments »

How to downgrade to iTunes 10.7 from iTunes 11 [OSX]

iTunes 11 is out, and most people seem to think it’s great. You and I are different, however. We hate it and we have our reasons. (Mine happens to be the inability to skip tracks while Repeat One is on. Yup, deal-breaker for me. UPDATE: Fixed that!) So let’s downgrade.

First, you’ll need a backup of your iTunes Library.itl file, … Keep reading »

Posted under: Fixing Stuff | No Comments »

Setting up the Actiontec GT784WN for Qwest/CenturyLink

The Actiontec GT784WN is a pretty nice DSL modem/wireless N router. For most of you, it will work right out of the box — even auto-detecting all your settings.

If you’re on Qwest/CenturyLink, not so much. In fact, they’ll try to tell you that the modem isn’t even compatible.

Lies!

In fact, it’s not only compatible, it’s pretty easy to set up. I’m going to repeat some of the normal setup steps here. If you know what you’re … Keep reading »

Posted under: Fixing Stuff | 18 Comments »

Delete all hidden OSX junk files in Windows (Like .DS_STORE)

If you use OSX and Windows together often, you’re likely to end up with a bunch of hidden .DS_STORE files all over your Windows drives. You can easily search and destroy them all using this command:

(Open the command line first of course. You can do this by going to Start > Run, then typing “cmd” and mashing enter. Or just type “cmd” in the Windows 7 search box.)
del /s /q /f /a:h .DS_STORE
That will find every instance of this Mac … Keep reading »

Posted under: Fixing Stuff | 15 Comments »

Xfce4 Power Manager Icon Missing?

Recently, I installed Lubuntu 11.10 (a netbook-optimized version of Ubuntu) on my wife’s netbook at Lifehacker’s suggestion. And wow–did it make an incredible difference. It’s like a brand new machine compared to Windows 7 running on it, which was getting unbearably slow.

While Lubuntu will look and act pretty familiar to anyone born and raised on Windows, I wanted to make sure when I handed the netbook back to her, she was as comfortable as possible. That meant configuring, … Keep reading »

Posted under: Fixing Stuff | 3 Comments »

Add spacers to your Mac’s dock

Ever wanted to have some more organization on your dock? I like to keep things separated more or less by group: everyday things, development tools, and apps that just happen to be open but aren’t permanent fixtures on my dock. I also like to keep my documents and folders separated from minimized things and the trash on the right side.

It’s fairly simple to drop some spacers … Keep reading »

Posted under: Fixing Stuff | 1 Comment »

Recording what you hear in Windows 7

Recording what you hear in Windows 7

At first glance, it may look like Microsoft disabled recording of internal—or “what you hear”—sounds in Windows 7. Well, they didn’t. It’s a little trickier, granted, but this is (often) a quick fix.

To enable it:
1. Right click on the speaker icon in the system tray (bottom right).
2. Choose Recording Devices
3. In the empty white space, right-click and choose Show Disabled Devices. You should see Stereo Mix appear in the list.
4. Right click on Stereo Mix and choose Enable.
5. Right click … Keep reading »

Posted under: Fixing Stuff | 94 Comments »

Fix iTunes 10 vertical control buttons

Fix iTunes 10 vertical control buttons

iTunes 10. Good stuff. But I’m really surprised that Apple — who are known for their design expertise — would not only violate a well-known design convention, but their own well-known design convention with those stoplight control buttons. It may seem like a simple annoyance, but multiply it by 1000 times over the course of a week or a month, and you have a fairly irritating problem.

Fortunately, putting those buttons back the way they should be is pretty easy. (Mac … Keep reading »

Posted under: Fixing Stuff | No Comments »

Wallpaper Won’t Change on Windows 7?

Wallpaper Won’t Change on Windows 7?

We have Windows 7 Home Premium 3-bit on one computer and suddenly couldn’t change the wallpaper. This seems to be a problem out there. There can be various ways to fix it. This one worked for us:

Hit the Start ball

Type “adjust appearance”

A link called “Adjust the appearance and performance of Windows” will appear. Click that.

Toggle the top check box “Animate controls and elements inside windows”

 

Worked for us. Your actual mileage may vary.

Posted under: Fixing Stuff | 2 Comments »
Page 1 of 212