Hi Andrew,
I tried mysql for duplicates and turning it to false but no luck. I decided to time a forced sitemap and the script seems to stop after about 8 seconds. I guess there is mysql limits (connection time and memory) that I am reaching. I don't have access to change these. I'll think i'll stick with the products I have in the sitemap and save up for a vps.

Cheers
Tim