Mega with wiznet shield (wire hack)+thingspeak+sd problem

You may be running out of SRAM. The SD open function requires a lot of memory. If you run out of SRAM, the open function may return success, but if you try to read or write, that is when it seems to fail. I'll take a quick guess that it does not check if the memory is available, just if it can open the file on the SD card.