#7 Critical database update for WebsitePanel 1.0

[Pavel Tsurbeleu]

Symptoms:

- When a reseller adds or updates a hosting plan ASP.NET 4.0 is not shown in Web Sites section of the hosting plan quotas list;
- “MailForwarding” label instead of “MailAlias” can be observed when browsing or managing Mail menu in control panel;
- TypeLoadException error message may appear when trying to add or update a mail alias;
- “Merak Mail Server 10.x (BETA)” label is in the list of available mail providers to choose from;
- “hMailServer 5.x (BETA)” label is in the list of available mail providers to choose from;
- “MDaemon 9.x - 11.x (BETA)” label is in the list of available mail providers to choose from;
- When add a new IIS 7 service provider ColdFusion and ASP.NET 4.0 text fields are empty and not pre-filled with the defaults;
- “Auto-discovery” is not disabled by default when add a BlackBerry or OCS Server service provider;

Instructions how to apply the patch:

1. Create a backup of WebsitePanel’s database via SQL Server Management Studio;
2. Open the attached script in SQL Server Management Studio;
3. Replace “Database_name_goes_here” string within the square brackets with the actual name of WebsitePanel database name;
4. Run the script and review the results;

If there is an error(s) then please save the results of the script execution in a file and proceed with the database restoration process from the backup copy you made in Step 1. For all such issues please send me a private message via Sourceforge’s “Send me a message” form and I’ll respond to you at my earliest convenience.

Best regards,
Pavel Tsurbeleu.

[Pavel Tsurbeleu]

Transact-SQL script

[Bill Hiers]

Thanks this fixed me right up..