4.1 upgrade sql exception ALTER TABLE sf_subscriber_sf_lst
After upgrade when I access any page I see. What to do?
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
|
|
Hi Alex,
We've identified the issue with the upgrade of the Newsletters module data. The fix requires deleting all your Newsletters related data (lists, subscribers, campaigns).
If you have just given a try of the module and the data can be safely deleted, run the following SQL script against your database (after stopping the project manager and IIS):
IF OBJECT_ID('sf_message_body', 'U') ISNOTNULLDELETEFROMsf_message_body
IF OBJECT_ID('sf_campaing_link', 'U') ISNOTNULLDELETEFROMsf_campaign_link
IF OBJECT_ID('sf_ab_campaign', 'U') ISNOTNULLDELETEFROMsf_ab_campaign
IF OBJECT_ID('sf_campaign', 'U') ISNOTNULLDELETEFROMsf_campaign
IF OBJECT_ID('sf_subscription_info', 'U') ISNOTNULLDELETEFROMsf_subscription_info
IF OBJECT_ID('sf_unsubscription_info', 'U') ISNOTNULLDELETEFROMsf_unsubscription_info
IF OBJECT_ID('sf_subscriber', 'U') ISNOTNULLDELETEFROMsf_subscriber
IF OBJECT_ID('sf_subscriber_sf_lst', 'U') ISNOTNULLDELETEFROMsf_subscriber_sf_lst
IF OBJECT_ID('sf_subscriber_sf_lst2', 'U') ISNOTNULLDELETEFROMsf_subscriber_sf_lst2
IF OBJECT_ID('sf_lst', 'U') ISNOTNULLDELETEFROMsf_lst
IF OBJECT_ID('sf_link_click_stat', 'U') ISNOTNULLDELETEFROMsf_link_click_stat
IF OBJECT_ID('sf_dynamic_list', 'U') ISNOTNULLDELETEFROMsf_dynamic_list
IF OBJECT_ID('sf_delivery_entry', 'U') ISNOTNULLDELETEFROMsf_delivery_entry
IF OBJECT_ID('sf_open_stat', 'U') ISNOTNULLDELETEFROMsf_open_stat
Thank you very much, Ivan!
Formatted version of SQL code:
IF OBJECT_ID('sf_message_body', 'U') IS NOT NULL DELETE FROM sf_message_body IF OBJECT_ID('sf_campaing_link', 'U') IS NOT NULL DELETE FROM sf_campaign_link IF OBJECT_ID('sf_ab_campaign', 'U') IS NOT NULL DELETE FROM sf_ab_campaign IF OBJECT_ID('sf_campaign', 'U') IS NOT NULL DELETE FROM sf_campaign IF OBJECT_ID('sf_subscription_info', 'U') IS NOT NULL DELETE FROM sf_subscription_info IF OBJECT_ID('sf_unsubscription_info', 'U') IS NOT NULL DELETE FROM sf_unsubscription_info IF OBJECT_ID('sf_sbscriber_subscription_info', 'U') IS NOT NULL DELETE FROM sf_sbscriber_subscription_info IF OBJECT_ID('sf_subscriber', 'U') IS NOT NULL DELETE FROM sf_subscriber IF OBJECT_ID('sf_subscriber_sf_lst', 'U') IS NOT NULL DELETE FROM sf_subscriber_sf_lst IF OBJECT_ID('sf_subscriber_sf_lst2', 'U') IS NOT NULL DELETE FROM sf_subscriber_sf_lst2 IF OBJECT_ID('sf_lst', 'U') IS NOT NULL DELETE FROM sf_lst IF OBJECT_ID('sf_link_click_stat', 'U') IS NOT NULL DELETE FROM sf_link_click_stat IF OBJECT_ID('sf_dynamic_list', 'U') IS NOT NULL DELETE FROM sf_dynamic_list IF OBJECT_ID('sf_delivery_entry', 'U') IS NOT NULL DELETE FROM sf_delivery_entry IF OBJECT_ID('sf_open_stat', 'U') IS NOT NULL DELETE FROM sf_open_statHello Ivan,
I am a developer for a medium sized software company, and have upgraded a sitefinity instance to version 5.0.2860.0.
I have the same issue as above. I have wiped the data from the tables using the script, and re-imported the data. Is there a solution to this, or do I have to send a database backup file somewhere to get this dealt with.
Thanks