Sparkfun Can-Bus Shield example not working
SPI pins are located on different pins in Arduino Mega. You have to wire it correctly with your shield. Some shields uses ICSP (6-pin header) for better compatibility but this one doesn't.

See Arduino SPI Reference for more details (section: Connections)