If you have a G24q base bulb that comes on for a second and then turns off, this is almost always an issue of a ballast incompatibility. Your pin-base fixture most likely is running off of a ballast, as there used to be a fluorescent bulb in that application that required one.
Please go to the source of the fixture's power and bypass the ballast, wiring the fixture directly to the source. Your bulb should work right away afterwards!
You can go here for more info on how to bypass the ballast