4/2/2008 2:46:17 PM
v1.4002 - There is already an object named 'WebSites_bak' in the database
Continue or restart VDM - This error was queued for analysis, we apologize.


--------------
-- WebSites --
--------------

if ( select [Value] from ::fn_listextendedprop
0001:002416FC       axView.txView.ExecuteSql line 9469
0001:001EA4FC       axView.txTree.DoOnExpanding line 2533 base: 00A61000


--------------
-- WebSites --
--------------

if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, default, default, default ) ) < '1.10' begin
  if       exists ( select * from INFORMATION_SCHEMA.TABLES  where Table_Name = 'WebPages' ) begin
    select * into WebSites_bak from WebSites
    select * into WebPages_bak from WebPages
    if exists ( select * from sysobjects where [Name] = 'Notes' AND [Type] = 'U' ) begin
  	  alter table Notes drop constraint FK_Notes_WebSites
    end
    drop table WebPages
    drop table WebSites
  end
  execute sp_updateextendedproperty 'Version', '1.1'
end

4/2/2008 2:45:34 PM
v1.4002 - Invalid column name 'Variation'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou
0001:00240A84       axView.txView.ExecuteRS line 9403
0001:002513A4       axView.txTabsEx.DoOnClick line 11141 base: 00A61000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[Quantity],[Hours],[Price],[Unit],[Discount_Amount],[Percent_Discount],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Made_to_Order],[Tree_Path],[Note], cast( isNull( DataLength( [Audio] ), 0 ) as int ) as Audio_Length from OrderItems where (([Order_ID]=0)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID]

4/2/2008 2:45:30 PM
v1.4002 - Invalid column name 'Variation'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou
0001:00240A84       axView.txView.ExecuteRS line 9403
0001:002513A4       axView.txTabsEx.DoOnClick line 11141 base: 00A61000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[Quantity],[Hours],[Price],[Unit],[Discount_Amount],[Percent_Discount],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Made_to_Order],[Tree_Path],[Note], cast( isNull( DataLength( [Audio] ), 0 ) as int ) as Audio_Length from OrderItems where (([Order_ID]=0)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID]

4/2/2008 2:45:27 PM
v1.4002 - Invalid column name 'Variation'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou
0001:00240A84       axView.txView.ExecuteRS line 9403
0001:002513A4       axView.txTabsEx.DoOnClick line 11141 base: 00A61000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[Quantity],[Hours],[Price],[Unit],[Discount_Amount],[Percent_Discount],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Made_to_Order],[Tree_Path],[Note], cast( isNull( DataLength( [Audio] ), 0 ) as int ) as Audio_Length from OrderItems where (([Order_ID]=0)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID]

4/2/2008 2:45:26 PM
v1.4002 - Invalid column name 'Variation'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou
0001:00240A84       axView.txView.ExecuteRS line 9403
0001:002513A4       axView.txTabsEx.DoOnClick line 11141 base: 00A61000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[Quantity],[Hours],[Price],[Unit],[Discount_Amount],[Percent_Discount],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Made_to_Order],[Tree_Path],[Note], cast( isNull( DataLength( [Audio] ), 0 ) as int ) as Audio_Length from OrderItems where (([Order_ID]=0)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID]

3/30/2008 6:21:09 PM
v1.3972 - There is already an object named 'WebSites_bak' in the database
Continue or restart VDM - This error was queued for analysis, we apologize.


--------------
-- WebSites --
--------------

if ( select [Value] from ::fn_listextendedprop
0001:002416FC       axView.txView.ExecuteSql line 9459
0001:001EA4FC       axView.txTree.DoOnExpanding line 2535 base: 00A61000


--------------
-- WebSites --
--------------

if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, default, default, default ) ) < '1.10' begin
  if       exists ( select * from INFORMATION_SCHEMA.TABLES  where Table_Name = 'WebPages' ) begin
    select * into WebSites_bak from WebSites
    select * into WebPages_bak from WebPages
    if exists ( select * from sysobjects where [Name] = 'Notes' AND [Type] = 'U' ) begin
  	  alter table Notes drop constraint FK_Notes_WebSites
    end
    drop table WebPages
    drop table WebSites
  end
  execute sp_updateextendedproperty 'Version', '1.1'
end

3/30/2008 6:19:13 PM
v1.3972 - Invalid column name 'Name'
Continue or restart VDM - This error was queued for analysis, we apologize.


----------------
-- Conversion --
----------------

if exists ( select * from sysobjects whe
0001:002414A4       axView.txView.ExecuteSql line 9439
0001:001EA54C       axView.txTree.DoOnExpanding line 2534 base: 00A61000


----------------
-- Conversion --
----------------

if exists ( select * from sysobjects where [Name] = 'WebSites_bak' AND [Type] = 'U' ) begin
  set IDENTITY_INSERT WebSites ON
  insert WebSites ( ID, GUID, Template_ID, Default_Template_ID, Date_Created, Date_Modified, ServerName, Workstation, UserName,
                    Title, Meta_Description, Meta_Keywords, Template_Name, Default_Template_Name, Destination_URL, Destination_Path, 
                    Local_Path, Original_URL, FTP_URL, FTP_Path, FTP_Username, FTP_Password, Note, Audio, 
                    Photo1, Photo1Name, Photo1Thumb, Photo2, Photo2Name, Photo2Thumb, Photo9, Photo9Name, Photo9Thumb )
  select ID, GUID, Template_ID, Default_Template_ID, Date_Created, Date_Modified, ServerName, Workstation, UserName,
         isNull( [Name], ID ), Meta_Description, Meta_Keywords, Template_Name, Default_Template_Name, Destination_URL, Destination_Path, 
         Local_Path, Original_Home_Address, FTP_Home_Address, FTP_HTML_Path, FTP_Username, FTP_Password, Note, Audio, 
         Photo1, Photo1Name, Photo1Thumb, Photo2, Photo2Name, Photo2Thumb, Photo9, Photo9Name, Photo9Thumb from WebSites_bak
  set IDENTITY_INSERT WebSites OFF
  exec sp_rename 'WebSites_bak', 'WebSites_Old'
  if exists ( select * from sysobjects where [Name] = 'Notes' AND [Type] = 'U' ) begin
    alter table Notes add constraint FK_Notes_WebSites foreign key ( WebSite_ID ) references WebSites ( ID ) on delete cascade
  end
end

3/23/2008 8:33:10 AM
v1.3525 - Command text was not set for the command object
Continue or restart VDM - This error was queued for analysis, we apologize.

0001:00230C04       axView.txView.FormPrintCount line 8195
0001:001E6018       axView.txTree.NodePathName line 2220 base: 00A61000


1/16/2008 4:54:08 PM
v1.3599 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou
0001:001F0E28       axView.txTree.LoadValues line 3235
0001:00241948       axView.txTabsEx.DoOnClick line 10036 base: 00A61000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[Quantity],[Hours],[Price],[Unit],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Made_to_Order],[Tree_Path],[Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from OrderItems where (([Order_ID]=4)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID]

1/16/2008 4:54:07 PM
v1.3599 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resou
0001:001F0E28       axView.txTree.LoadValues line 3235
0001:00241948       axView.txTabsEx.DoOnClick line 10036 base: 00A61000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Sequence],[Resource_Code],[Resource_UPC],[Resource_Name],[Variation],[Quantity],[Hours],[Price],[Unit],[Total],[Back_Order],[Date_Start],[Date_Stop],[Reference_Code],[Serial_or_Lot_Number],[Contact_Name],[Template_Name],[Taxable],[Made_to_Order],[Tree_Path],[Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from OrderItems where (([Order_ID]=0)) AND (isNull( OrderItem_ID, 0 ) = 0) order by [Resource_Name], [ID]

1/16/2008 4:52:25 PM
v1.3599 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[D
0001:001F0E28       axView.txTree.LoadValues line 3235
0001:00241948       axView.txTabsEx.DoOnClick line 10036 base: 00A61000
select top 101 [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Serial_or_Lot_Number],[Minutes],[Hours],[Days],[Date_Start],[Date_Stop],[Tree_Path],[Note] from Activities where (([Catalog_Name]=0)) AND ([Type] = 'Activity' AND isNull( Date_Locked, 0 ) = 0) order by [ID]

1/7/2008 9:13:07 AM
v1.3525 - Operation is not allowed when the object is closed
Continue or restart VDM - This error was queued for analysis, we apologize.
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' )
0001:001F1AE4       axView.txTree.RefreshValues line 3242
0001:0021FE38       axView.txView.DoOnTimer line 6791 base: 00AB1000
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' -