lorax - 1:59 pm on Mar 6, 2013 (gmt 0)
Did you set up your permalinks?
It appears that site map generator isn't looking at the site as a bot would. It's looking at the database. You need a site map generator that develops a site map as the bots would see it. I suggest you locate google site map generator and then set it up to run on a cron job this way it will get updated automatically.