Yeah, my sister suffers from horrible migraines and she takes Topamax (topiramite) and Imitrex and sometimes they don't even help. I really feel for you. If you're photosensitive, I don't know of anything that can help, offhand, so it may be worth it to talk to a doctor...who knows, there may be something out there that will make going to clubs bearable!
Oh, and there is
such a thing as photosensitive epilepsy, so you could look into that...best wishes!