I know I've already found this answer before but I'm damned if I can find it now. About three weeks ago my otherwise perfectly behaved MBP 15" 2.2Ghz 10.5.8 stopped waking from sleep. After much searching and trying all sorts of different advice I found a thread suggesting deleting or installing the Firewire port then re-installing the Firewire port which worked.
I was intending to install a new hard-drive (120GB - 320GB) and decided to install the new drive ready for Snow Leopard. The install worked well Installed Tiger - no problems - upgraded to Leopard - ran the software updates and now it will not wake from sleep without rebooting. So I've been looking for the missing thread with no luck. In the middle of all this I've discovered that if I plug a firewire device in whilst the MBP is sleeping (or comatose - take your pick) hey presto it wakes up. Any help gratefully received although I must say after 5 years+ of Mac heaven the shine is coming off!