Ok just incase anyone else is having the same prob...

I had mysql5 installed and apparently there is well known problems with it and zencart. downgrading to mysql4 has done the trick.