7.0.1 - Sites Module fails

I've just upgraded from 7.0 -> 7.0.1 and tried to install the "sites" module.

I get the following error :

[quote]Installation of: Sites Failed
-- Changing database:
-- -- There are errors in the following MySQL queries:
-- -- Error: Column 'Order' cannot be null
INSERT INTO `sys_menu_top` VALUES(NULL, 4, 'Sites', '_bx_sites_menu_my_sites_profile', 'modules/?r=sites/browse/my', @iCatProfileOrder, 'memb', '', '', '', 1, 1, 1, 'custom', '', '', 0, '');[/quote]

But the sites tab appears across the site (not working properly obviously) and I have the option to access the modules settings in the admin section at Modules > _bx_sites which when clicked results in the following :

[quote]MODULE(SITES) WAS NOT FOUND[/quote]

Now, you'd think it would be an easy problem to fix as I could just uninstall the module, but it isn't showing up in the installed list.

So how can I go about getting rid of this now? I'm not bothered about the module, I was just checking a few out to see what they did (I now know after reading a few threads on here and I don't need it)

Many thanks.

Just wanted to boost this and add to it too.

Quite a few of the mods won't install, and I followed the upgrade to the letter, doubled checked every step so I know I didn't do anything wrong.

When I tried to perform one of the manual upgrade steps, can't remember which one now but it was about a reinstalling a mod (that I don't use anyway), I got a "you are using the wrong version error".

Also my site now re-directs every login to member.php no matter what I tell it to do...

I think i'm gonna scrap the lot and do a fresh 7.0.1 install, as my site to be pretty messed up since the upgrade.