What's really weird is that I can get it working perfectly in my test environment but when I move it to production (live) site, that's when I have the issue of not being able to change the month on the store pages, or when I click on "New Event" in the admin it does nothing.

Could it have something to do with the sql as my test environment run on sql version 4 and production is sql version 5?