0000867: Fatal Error on Installation of Demo data

Index: _install/english.lang =================================================================== --- _install/english.lang (revision 13951) +++ _install/english.lang (working copy) @@ -4,6 +4,7 @@ <PHRASE Label="lu_AProblemInForm" Module="Core" Type="0">T25lIG9yIG1vcmUgZmllbGRzIG9uIHRoaXMgZm9ybSBoYXMgYW4gZXJyb3IuPGJyLz4NClBsZWFzZSByZXZpZXcgdGhlIGZpZWxkcyBtYXJrZWQgd2l0aCByZWQgY2FyZWZ1bGx5IGFuZCBzdWJtaXQgdGhlIGZvcm0gYWdhaW4u</PHRASE> <PHRASE Label="lu_btn_Reset" Module="Core" Type="0">UmVzZXQ=</PHRASE> <PHRASE Label="lu_btn_Send" Module="Core" Type="0">U2VuZA==</PHRASE> + <PHRASE Label="lu_fld_Captcha" Module="Core" Type="0">Q2FwdGNoYSBJbWFnZQ==</PHRASE> <PHRASE Label="lu_fld_Company" Module="Core" Type="0">Q29tcGFueQ==</PHRASE> <PHRASE Label="lu_fld_Email" Module="Core" Type="0">RS1tYWls</PHRASE> <PHRASE Label="lu_fld_Message" Module="Core" Type="0">TWVzc2FnZQ==</PHRASE> Index: _install/install_data.sql =================================================================== --- _install/install_data.sql (revision 13951) +++ _install/install_data.sql (working copy) @@ -1,9 +1,9 @@ UPDATE Category SET IsMenu = 1 WHERE Template = 'index'; -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 0, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 0, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 0, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 0, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 0, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 0, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 0, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 0, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0); UPDATE IdGenerator SET lastid = lastid + 100; @@ -22,14 +22,14 @@ INSERT INTO PermCache VALUES(DEFAULT, 202, 1, '11'); INSERT INTO PermCache VALUES(DEFAULT, 203, 1, '11'); ~~-INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', '');~~ +INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 5, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', ''); ~~-INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 0);~~ +INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 1); INSERT INTO FormFields VALUES(2, 1, 0, 'Company', 'lu_fld_Company', NULL, 'la_fld_Company', 'text', NULL, 4, 0, 1, 1, NULL, 0, 1, 0); ~~-INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 0);~~ +INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 2); INSERT INTO FormFields VALUES(4, 1, 0, 'Phone', 'lu_fld_Phone', NULL, 'la_fld_Phone', 'text', NULL, 2, 0, 0, 1, NULL, 0, 1, 0); ~~-INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 0);~~ -INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 0); +INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4); +INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 3); ALTER TABLE FormSubmissions ADD COLUMN fld_1 text,

Index: _install/english.lang =================================================================== --- _install/english.lang (revision 13951) +++ _install/english.lang (working copy) @@ -4,6 +4,7 @@ <PHRASE Label="lu_AProblemInForm" Module="Core" Type="0">T25lIG9yIG1vcmUgZmllbGRzIG9uIHRoaXMgZm9ybSBoYXMgYW4gZXJyb3IuPGJyLz4NClBsZWFzZSByZXZpZXcgdGhlIGZpZWxkcyBtYXJrZWQgd2l0aCByZWQgY2FyZWZ1bGx5IGFuZCBzdWJtaXQgdGhlIGZvcm0gYWdhaW4u</PHRASE> <PHRASE Label="lu_btn_Reset" Module="Core" Type="0">UmVzZXQ=</PHRASE> <PHRASE Label="lu_btn_Send" Module="Core" Type="0">U2VuZA==</PHRASE> + <PHRASE Label="lu_fld_Captcha" Module="Core" Type="0">Q2FwdGNoYSBJbWFnZQ==</PHRASE> <PHRASE Label="lu_fld_Company" Module="Core" Type="0">Q29tcGFueQ==</PHRASE> <PHRASE Label="lu_fld_Email" Module="Core" Type="0">RS1tYWls</PHRASE> <PHRASE Label="lu_fld_Message" Module="Core" Type="0">TWVzc2FnZQ==</PHRASE> Index: _install/install_data.sql =================================================================== --- _install/install_data.sql (revision 13951) +++ _install/install_data.sql (working copy) @@ -1,9 +1,9 @@ UPDATE Category SET IsMenu = 1 WHERE Template = 'index'; -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 0, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 0, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 0, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, IsSystem, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 0, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 1, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 1, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 1, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 1, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0); UPDATE IdGenerator SET lastid = lastid + 100; @@ -22,14 +22,14 @@ INSERT INTO PermCache VALUES(DEFAULT, 202, 1, '11'); INSERT INTO PermCache VALUES(DEFAULT, 203, 1, '11'); ~~-INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', '');~~ +INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 5, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', ''); ~~-INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 0);~~ +INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 1); INSERT INTO FormFields VALUES(2, 1, 0, 'Company', 'lu_fld_Company', NULL, 'la_fld_Company', 'text', NULL, 4, 0, 1, 1, NULL, 0, 1, 0); ~~-INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 0);~~ +INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 2); INSERT INTO FormFields VALUES(4, 1, 0, 'Phone', 'lu_fld_Phone', NULL, 'la_fld_Phone', 'text', NULL, 2, 0, 0, 1, NULL, 0, 1, 0); ~~-INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 0);~~ -INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 0); +INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4); +INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 3); ALTER TABLE FormSubmissions ADD COLUMN fld_1 text,

Issue History
Date Modified	Username	Field	Change
2010-11-30 12:50	Dmitry	Note Added: 0003094
2010-11-30 12:50	Dmitry	Status	resolved => closed
2010-09-18 05:01	alex	Relationship added	child of 0000683
2010-09-18 05:00	alex	Note Added: 0002849
2010-09-18 05:00	alex	Status	reviewed and tested => resolved
2010-09-18 05:00	alex	Fixed in Version	=> 5.1.1-B1
2010-09-18 05:00	alex	Resolution	open => fixed
2010-09-18 05:00	alex	Assigned To	!COMMUNITY => alex
2010-09-18 05:00	alex	Changeset attached	5.1.x r13953
2010-09-18 04:59	alex	Note Added: 0002848
2010-09-18 04:59	alex	Assigned To	alex => !COMMUNITY
2010-09-18 04:59	alex	Status	needs testing => reviewed and tested
2010-09-17 16:59	Dmitry	Note Added: 0002847
2010-09-17 16:59	Dmitry	Assigned To	Dmitry => alex
2010-09-17 16:59	Dmitry	Status	needs work => needs testing
2010-09-17 16:59	Dmitry	File Added: Fatal-on-Default-theme-Demo-install-v2.patch
2010-09-17 12:47	alex	Note Added: 0002843
2010-09-17 12:47	alex	Assigned To	alex => Dmitry
2010-09-17 12:47	alex	Status	needs testing => needs work
2010-09-17 11:19	Dmitry	Note Added: 0002841
2010-09-17 11:19	Dmitry	Assigned To	=> alex
2010-09-17 11:19	Dmitry	Developer	=> Dmitry
2010-09-17 11:19	Dmitry	Status	active => needs testing
2010-09-17 11:19	Dmitry	New Issue
2010-09-17 11:19	Dmitry	File Added: Fatal-on-Default-theme-Demo-install.patch
2010-09-17 11:19	Dmitry	Change Log Message	=> Minor fix in Demo content for Default theme

Notes
(0002841) Dmitry (manager) 2010-09-17 11:19	Please test this patch.

(0002843) alex (manager) 2010-09-17 12:47	Also Type column has 0 for records, but that's not true, since it must be 1 - for virtual pages and 2 for templates.

(0002847) Dmitry (manager) 2010-09-17 16:59	Please review and commit if looks good.

(0002848) alex (manager) 2010-09-18 04:59	Works fine, but you set 5 as UseSecurityImage column value, but it should be 1 or 0 instead. Fixed.

(0002849) alex (manager) 2010-09-18 05:00	Fix committed to 5.1.x branch. Commit Message: Fixes 0000867: Fatal Error on Installation of Demo data

(0003094) Dmitry (manager) 2010-11-30 12:50	Released.

Related Changesets
Themes :: Default: 5.1.x r13953 Timestamp: 2010-09-18 05:00:12 Author: alex [ Details ] [ Diff ]	Fixes 0000867: Fatal Error on Installation of Demo data
	mod - /themes/default/branches/5.1.x/_install/english.lang	[ Diff ] [ File ]
	mod - /themes/default/branches/5.1.x/_install/install_data.sql	[ Diff ] [ File ]

In-Portal Issue Tracker