I was having this problem with Photoshop that double-clicking on a file would go to Photoshop but not open the file. I was also getting a missing support file error message when PS opened. The problem began after upgrading from OS10.3 to OS10.4. Here is the solution: