Hi buddy, welcome to the club.
I had similar issue with code 34. Like said before, I put the 1 megaohm 0.25watt resistor in the pin holes, and it was fine. its £25 to get the knock sensor relocated as not ideal to run a turbo engine with a knocksensor bypass!
The knock sensor itself is over £200 from Nissan, but there are cheaper ones on eBay - however I cant vouch for them - you may be able to get a good one from a breaker, but its still going to be very old and near the end of its life.
The resistor was 29 pence from maplin, and the plug is at the back of the engine in the middle, at the top. there are 3 connectors, two together, and one on its own. Its the one on its own, closest to drivers side.
When located, literally just pop the two connectors apart, one side goes to ecu and one to the det sensor - bridge the two pin holes and should run fine.
As for reseting fault codes, dont disconnect battery for an hour, takes too long.
There is a Connector port in the drivers footwell, just under the dash, next to the kickpanel by the door. you can do this to diagnose faults without lifting passenger carpet, and it also auto resets fault codes when you disabloe it, by repeating the disabling procedure.....
Using a paperclip, or small wire, jump the connection between pins 8 and 9 on the Consult connector, as shown below:
[ATTACH]65203[/ATTACH]
Hold the jump for three seconds, then remove the jump. This is essentially the same as turning the potentiometer on the ECU.
Once the jump is removed, the CEL will start blinking codes.
Insert the jump again, and hold for three seconds. Then remove it. This will clear all codes.
Turn the key off, and run codes again to ensure they’re gone.