Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Let's Just Pretend That I'm A Moron...


Reply

14 Posts   4913 Views

Avatar
revstevens

29 September 2008 at 7:26am Community Member, 9 Posts

OK. I dropped the database, recreated it, flushed it and got this:

Building Database

Creating database tables

Newsletter
Table Newsletter: created
Field Newsletter.ClassName: created as enum('Newsletter') character set utf8 collate utf8_general_ci default 'Newsletter'
Field Newsletter.Created: created as datetime
Field Newsletter.LastEdited: created as datetime
Field Newsletter.Status: created as enum('Draft','Send') character set utf8 collate utf8_general_ci default 'Draft'
Field Newsletter.Content: created as mediumtext character set utf8 collate utf8_general_ci
Field Newsletter.Subject: created as varchar(255) character set utf8 collate utf8_general_ci
Field Newsletter.SentDate: created as datetime
Field Newsletter.ParentID: created as int(11) not null default '0'
Index Newsletter.ParentID: created as (ParentID)
Index Newsletter.ClassName: created as (ClassName)
Newsletter_SentRecipient
Table Newsletter_SentRecipient: created
Field Newsletter_SentRecipient.ClassName: created as enum('Newsletter_SentRecipient') character set utf8 collate utf8_general_ci default 'Newsletter_SentRecipient'
Field Newsletter_SentRecipient.Created: created as datetime
Field Newsletter_SentRecipient.LastEdited: created as datetime
Field Newsletter_SentRecipient.ParentID: created as int(11) not null default '0'
Field Newsletter_SentRecipient.Email: created as varchar(255) character set utf8 collate utf8_general_ci
Field Newsletter_SentRecipient.Result: created as enum('Sent','Failed','Bounced','BlackListed') character set utf8 collate utf8_general_ci default 'Sent'
Field Newsletter_SentRecipient.MemberID: created as int(11) not null default '0'
Index Newsletter_SentRecipient.MemberID: created as (MemberID)
Index Newsletter_SentRecipient.ClassName: created as (ClassName)
Newsletter_Recipient
Table Newsletter_Recipient: created
Field Newsletter_Recipient.ClassName: created as enum('Newsletter_Recipient') character set utf8 collate utf8_general_ci default 'Newsletter_Recipient'
Field Newsletter_Recipient.Created: created as datetime
Field Newsletter_Recipient.LastEdited: created as datetime
Field Newsletter_Recipient.ParentID: created as int(11) not null default '0'
Field Newsletter_Recipient.MemberID: created as int(11) not null default '0'
Index Newsletter_Recipient.MemberID: created as (MemberID)
Index Newsletter_Recipient.ClassName: created as (ClassName)
NewsletterType
Table NewsletterType: created
Field NewsletterType.ClassName: created as enum('NewsletterType') character set utf8 collate utf8_general_ci default 'NewsletterType'
Field NewsletterType.Created: created as datetime
Field NewsletterType.LastEdited: created as datetime
Field NewsletterType.Title: created as varchar(50) character set utf8 collate utf8_general_ci
Field NewsletterType.Template: created as varchar(50) character set utf8 collate utf8_general_ci
Field NewsletterType.FromEmail: created as varchar(50) character set utf8 collate utf8_general_ci
Field NewsletterType.Sent: created as datetime
Field NewsletterType.ParentID: created as int(11) not null default '0'
Field NewsletterType.GroupID: created as int(11) not null default '0'
Index NewsletterType.ParentID: created as (ParentID)
Index NewsletterType.GroupID: created as (GroupID)
Index NewsletterType.ClassName: created as (ClassName)
PageComment
Table PageComment: created
Field PageComment.ClassName: created as enum('PageComment') character set utf8 collate utf8_general_ci default 'PageComment'
Field PageComment.Created: created as datetime
Field PageComment.LastEdited: created as datetime
Field PageComment.Name: created as varchar(50) character set utf8 collate utf8_general_ci
Field PageComment.Comment: created as mediumtext character set utf8 collate utf8_general_ci
Field PageComment.IsSpam: created as tinyint(1) unsigned not null default '0'
Field PageComment.NeedsModeration: created as tinyint(1) unsigned not null default '0'
Field PageComment.ParentID: created as int(11) not null default '0'
Index PageComment.ParentID: created as (ParentID)
Index PageComment.ClassName: created as (ClassName)
Email_BounceRecord
Table Email_BounceRecord: created
Field Email_BounceRecord.ClassName: created as enum('Email_BounceRecord') character set utf8 collate utf8_general_ci default 'Email_BounceRecord'
Field Email_BounceRecord.Created: created as datetime
Field Email_BounceRecord.LastEdited: created as datetime
Field Email_BounceRecord.BounceEmail: created as varchar(50) character set utf8 collate utf8_general_ci
Field Email_BounceRecord.BounceTime: created as datetime
Field Email_BounceRecord.BounceMessage: created as varchar(50) character set utf8 collate utf8_general_ci
Field Email_BounceRecord.MemberID: created as int(11) not null default '0'
Index Email_BounceRecord.MemberID: created as (MemberID)
Index Email_BounceRecord.ClassName: created as (ClassName)
Email_BlackList
Table Email_BlackList: created
Field Email_BlackList.ClassName: created as enum('Email_BlackList') character set utf8 collate utf8_general_ci default 'Email_BlackList'
Field Email_BlackList.Created: created as datetime
Field Email_BlackList.LastEdited: created as datetime
Field Email_BlackList.BlockedEmail: created as varchar(50) character set utf8 collate utf8_general_ci
Field Email_BlackList.MemberID: created as int(11) not null default '0'
Index Email_BlackList.MemberID: created as (MemberID)
Index Email_BlackList.ClassName: created as (ClassName)
PageView
Table PageView: created
Field PageView.ClassName: created as enum('PageView') character set utf8 collate utf8_general_ci default 'PageView'
Field PageView.Created: created as datetime
Field PageView.LastEdited: created as datetime
Field PageView.IP: created as varchar(255) character set utf8 collate utf8_general_ci
Field PageView.Browser: created as varchar(255) character set utf8 collate utf8_general_ci
Field PageView.BrowserVersion: created as decimal(9,2)
Field PageView.FromExternal: created as tinyint(1) unsigned not null default '0'
Field PageView.Referrer: created as varchar(255) character set utf8 collate utf8_general_ci
Field PageView.SearchEngine: created as tinyint(1) unsigned not null default '0'
Field PageView.Keywords: created as varchar(255) character set utf8 collate utf8_general_ci
Field PageView.OS: created as varchar(255) character set utf8 collate utf8_general_ci
Field PageView.PageID: created as int(11) not null default '0'
Field PageView.UserID: created as int(11) not null default '0'
Index PageView.PageID: created as (PageID)
Index PageView.UserID: created as (UserID)
Index PageView.ClassName: created as (ClassName)
SiteTree
Table SiteTree: created
Field SiteTree.ClassName: created as enum('SiteTree','GhostPage','Page','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree'
Field SiteTree.Created: created as datetime
Field SiteTree.LastEdited: created as datetime
Field SiteTree.URLSegment: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree.Title: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree.MenuTitle: created as varchar(100) character set utf8 collate utf8_general_ci
Field SiteTree.Content: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree.MetaTitle: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree.MetaDescription: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree.MetaKeywords: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree.ExtraMeta: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree.ShowInMenus: created as tinyint(1) unsigned not null default '0'
Field SiteTree.ShowInSearch: created as tinyint(1) unsigned not null default '0'
Field SiteTree.HomepageForDomain: created as varchar(100) character set utf8 collate utf8_general_ci
Field SiteTree.ProvideComments: created as tinyint(1) unsigned not null default '0'
Field SiteTree.Sort: created as int(11) not null default '0'
Field SiteTree.LegacyURL: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree.HasBrokenFile: created as tinyint(1) unsigned not null default '0'
Field SiteTree.HasBrokenLink: created as tinyint(1) unsigned not null default '0'
Field SiteTree.Status: created as varchar(50) character set utf8 collate utf8_general_ci
Field SiteTree.ReportClass: created as varchar(50) character set utf8 collate utf8_general_ci
Field SiteTree.Priority: created as float
Field SiteTree.Viewers: created as enum('Anyone','LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'Anyone'
Field SiteTree.Editors: created as enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers'
Field SiteTree.ViewersGroup: created as int(11) not null default '0'
Field SiteTree.EditorsGroup: created as int(11) not null default '0'
Field SiteTree.ToDo: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree.ParentID: created as int(11) not null default '0'
Index SiteTree.ParentID: created as (ParentID)
Index SiteTree.SearchFields: created as fulltext (Title,MenuTitle,Content,MetaTitle,MetaDescription,MetaKeywords)
Index SiteTree.TitleSearchFields: created as fulltext (Title)
Index SiteTree.ClassName: created as (ClassName)
Table SiteTree_LinkTracking: created
Field SiteTree_LinkTracking.SiteTreeID: created as int(11) not null default '0'
Field SiteTree_LinkTracking.ChildID: created as int(11) not null default '0'
Field SiteTree_LinkTracking.FieldName: created as varchar(50) character set utf8 collate utf8_general_ci
Index SiteTree_LinkTracking.SiteTreeID: created as (SiteTreeID)
Index SiteTree_LinkTracking.ChildID: created as (ChildID)
Table SiteTree_ImageTracking: created
Field SiteTree_ImageTracking.SiteTreeID: created as int(11) not null default '0'
Field SiteTree_ImageTracking.FileID: created as int(11) not null default '0'
Field SiteTree_ImageTracking.FieldName: created as varchar(50) character set utf8 collate utf8_general_ci
Index SiteTree_ImageTracking.SiteTreeID: created as (SiteTreeID)
Index SiteTree_ImageTracking.FileID: created as (FileID)
Field SiteTree.Version: created as int(11) not null default '0'
Table SiteTree_Live: created
Field SiteTree_Live.ClassName: created as enum('SiteTree','GhostPage','Page','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree'
Field SiteTree_Live.Created: created as datetime
Field SiteTree_Live.LastEdited: created as datetime
Field SiteTree_Live.URLSegment: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_Live.Title: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_Live.MenuTitle: created as varchar(100) character set utf8 collate utf8_general_ci
Field SiteTree_Live.Content: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree_Live.MetaTitle: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_Live.MetaDescription: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_Live.MetaKeywords: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_Live.ExtraMeta: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree_Live.ShowInMenus: created as tinyint(1) unsigned not null default '0'
Field SiteTree_Live.ShowInSearch: created as tinyint(1) unsigned not null default '0'
Field SiteTree_Live.HomepageForDomain: created as varchar(100) character set utf8 collate utf8_general_ci
Field SiteTree_Live.ProvideComments: created as tinyint(1) unsigned not null default '0'
Field SiteTree_Live.Sort: created as int(11) not null default '0'
Field SiteTree_Live.LegacyURL: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_Live.HasBrokenFile: created as tinyint(1) unsigned not null default '0'
Field SiteTree_Live.HasBrokenLink: created as tinyint(1) unsigned not null default '0'
Field SiteTree_Live.Status: created as varchar(50) character set utf8 collate utf8_general_ci
Field SiteTree_Live.ReportClass: created as varchar(50) character set utf8 collate utf8_general_ci
Field SiteTree_Live.Priority: created as float
Field SiteTree_Live.Viewers: created as enum('Anyone','LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'Anyone'
Field SiteTree_Live.Editors: created as enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers'
Field SiteTree_Live.ViewersGroup: created as int(11) not null default '0'
Field SiteTree_Live.EditorsGroup: created as int(11) not null default '0'
Field SiteTree_Live.ToDo: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree_Live.ParentID: created as int(11) not null default '0'
Index SiteTree_Live.ParentID: created as (ParentID)
Index SiteTree_Live.SearchFields: created as fulltext (Title,MenuTitle,Content,MetaTitle,MetaDescription,MetaKeywords)
Index SiteTree_Live.TitleSearchFields: created as fulltext (Title)
Index SiteTree_Live.ClassName: created as (ClassName)
Field SiteTree_Live.Version: created as int(11) not null default '0'
Table SiteTree_versions: created
Field SiteTree_versions.RecordID: created as int(11) not null default '0'
Field SiteTree_versions.Version: created as int(11) not null default '0'
Field SiteTree_versions.WasPublished: created as tinyint(1) unsigned not null default '0'
Field SiteTree_versions.AuthorID: created as int(11) not null default '0'
Field SiteTree_versions.PublisherID: created as int(11) not null default '0'
Field SiteTree_versions.ClassName: created as enum('SiteTree','GhostPage','Page','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm') character set utf8 collate utf8_general_ci default 'SiteTree'
Field SiteTree_versions.Created: created as datetime
Field SiteTree_versions.LastEdited: created as datetime
Field SiteTree_versions.URLSegment: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_versions.Title: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_versions.MenuTitle: created as varchar(100) character set utf8 collate utf8_general_ci
Field SiteTree_versions.Content: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree_versions.MetaTitle: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_versions.MetaDescription: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_versions.MetaKeywords: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_versions.ExtraMeta: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree_versions.ShowInMenus: created as tinyint(1) unsigned not null default '0'
Field SiteTree_versions.ShowInSearch: created as tinyint(1) unsigned not null default '0'
Field SiteTree_versions.HomepageForDomain: created as varchar(100) character set utf8 collate utf8_general_ci
Field SiteTree_versions.ProvideComments: created as tinyint(1) unsigned not null default '0'
Field SiteTree_versions.Sort: created as int(11) not null default '0'
Field SiteTree_versions.LegacyURL: created as varchar(255) character set utf8 collate utf8_general_ci
Field SiteTree_versions.HasBrokenFile: created as tinyint(1) unsigned not null default '0'
Field SiteTree_versions.HasBrokenLink: created as tinyint(1) unsigned not null default '0'
Field SiteTree_versions.Status: created as varchar(50) character set utf8 collate utf8_general_ci
Field SiteTree_versions.ReportClass: created as varchar(50) character set utf8 collate utf8_general_ci
Field SiteTree_versions.Priority: created as float
Field SiteTree_versions.Viewers: created as enum('Anyone','LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'Anyone'
Field SiteTree_versions.Editors: created as enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers'
Field SiteTree_versions.ViewersGroup: created as int(11) not null default '0'
Field SiteTree_versions.EditorsGroup: created as int(11) not null default '0'
Field SiteTree_versions.ToDo: created as mediumtext character set utf8 collate utf8_general_ci
Field SiteTree_versions.ParentID: created as int(11) not null default '0'
Index SiteTree_versions.RecordID_Version: created as (RecordID,Version)
Index SiteTree_versions.RecordID: created as (RecordID)
Index SiteTree_versions.Version: created as (Version)
Index SiteTree_versions.AuthorID: created as (AuthorID)
Index SiteTree_versions.PublisherID: created as (PublisherID)
Index SiteTree_versions.ParentID: created as (ParentID)
Index SiteTree_versions.SearchFields: created as fulltext (Title,MenuTitle,Content,MetaTitle,MetaDescription,MetaKeywords)
Index SiteTree_versions.TitleSearchFields: created as fulltext (Title)
Index SiteTree_versions.ClassName: created as (ClassName)
QueuedEmail
Table QueuedEmail: created
Field QueuedEmail.ClassName: created as enum('QueuedEmail') character set utf8 collate utf8_general_ci default 'QueuedEmail'
Field QueuedEmail.Created: created as datetime
Field QueuedEmail.LastEdited: created as datetime
Field QueuedEmail.Send: created as datetime
Field QueuedEmail.Subject: created as varchar(50) character set utf8 collate utf8_general_ci
Field QueuedEmail.From: created as varchar(50) character set utf8 collate utf8_general_ci
Field QueuedEmail.Content: created as mediumtext character set utf8 collate utf8_general_ci
Field QueuedEmail.ToID: created as int(11) not null default '0'
Index QueuedEmail.ToID: created as (ToID)
Index QueuedEmail.ClassName: created as (ClassName)
File
Table File: created
Field File.ClassName: created as enum('File','Image','Folder','Image_Cached') character set utf8 collate utf8_general_ci default 'File'
Field File.Created: created as datetime
Field File.LastEdited: created as datetime
Field File.Name: created as varchar(255) character set utf8 collate utf8_general_ci
Field File.Title: created as varchar(255) character set utf8 collate utf8_general_ci
Field File.Filename: created as varchar(255) character set utf8 collate utf8_general_ci
Field File.Content: created as mediumtext character set utf8 collate utf8_general_ci
Field File.Sort: created as int(11) not null default '0'
Field File.ParentID: created as int(11) not null default '0'
Field File.OwnerID: created as int(11) not null default '0'
Index File.ParentID: created as (ParentID)
Index File.OwnerID: created as (OwnerID)
Index File.SearchFields: created as fulltext (Filename,Title,Content)
Index File.ClassName: created as (ClassName)
EditableCheckboxOption
Table EditableCheckboxOption: created
Field EditableCheckboxOption.ClassName: created as enum('EditableCheckboxOption') character set utf8 collate utf8_general_ci default 'EditableCheckboxOption'
Field EditableCheckboxOption.Created: created as datetime
Field EditableCheckboxOption.LastEdited: created as datetime
Field EditableCheckboxOption.Name: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableCheckboxOption.Title: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableCheckboxOption.Default: created as tinyint(1) unsigned not null default '0'
Field EditableCheckboxOption.Sort: created as int(11) not null default '0'
Field EditableCheckboxOption.ParentID: created as int(11) not null default '0'
Index EditableCheckboxOption.ParentID: created as (ParentID)
Index EditableCheckboxOption.ClassName: created as (ClassName)
EditableDropdownOption
Table EditableDropdownOption: created
Field EditableDropdownOption.ClassName: created as enum('EditableDropdownOption') character set utf8 collate utf8_general_ci default 'EditableDropdownOption'
Field EditableDropdownOption.Created: created as datetime
Field EditableDropdownOption.LastEdited: created as datetime
Field EditableDropdownOption.Name: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableDropdownOption.Title: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableDropdownOption.Default: created as tinyint(1) unsigned not null default '0'
Field EditableDropdownOption.Sort: created as int(11) not null default '0'
Field EditableDropdownOption.ParentID: created as int(11) not null default '0'
Index EditableDropdownOption.ParentID: created as (ParentID)
Index EditableDropdownOption.ClassName: created as (ClassName)
EditableFormField
Table EditableFormField: created
Field EditableFormField.ClassName: created as enum('EditableFormField','EditableCheckbox','EditableCheckboxGroupField','EditableDateField','EditableDropdown','EditableEmailField','EditableFileField','EditableFormHeading','EditableMemberListField','EditableRadioField','EditableTextField') character set utf8 collate utf8_general_ci default 'EditableFormField'
Field EditableFormField.Created: created as datetime
Field EditableFormField.LastEdited: created as datetime
Field EditableFormField.Name: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableFormField.Title: created as varchar(255) character set utf8 collate utf8_general_ci
Field EditableFormField.Default: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableFormField.Sort: created as int(11) not null default '0'
Field EditableFormField.Required: created as tinyint(1) unsigned not null default '0'
Field EditableFormField.CanDelete: created as tinyint(1) unsigned not null default '0'
Field EditableFormField.CustomParameter: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableFormField.ParentID: created as int(11) not null default '0'
Index EditableFormField.ParentID: created as (ParentID)
Index EditableFormField.ClassName: created as (ClassName)
EditableRadioOption
Table EditableRadioOption: created
Field EditableRadioOption.ClassName: created as enum('EditableRadioOption') character set utf8 collate utf8_general_ci default 'EditableRadioOption'
Field EditableRadioOption.Created: created as datetime
Field EditableRadioOption.LastEdited: created as datetime
Field EditableRadioOption.Name: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableRadioOption.Title: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableRadioOption.Default: created as tinyint(1) unsigned not null default '0'
Field EditableRadioOption.Value: created as varchar(50) character set utf8 collate utf8_general_ci
Field EditableRadioOption.Sort: created as int(11) not null default '0'
Field EditableRadioOption.ParentID: created as int(11) not null default '0'
Index EditableRadioOption.ParentID: created as (ParentID)
Index EditableRadioOption.ClassName: created as (ClassName)
SubmittedForm
Table SubmittedForm: created
Field SubmittedForm.ClassName: created as enum('SubmittedForm') character set utf8 collate utf8_general_ci default 'SubmittedForm'
Field SubmittedForm.Created: created as datetime
Field SubmittedForm.LastEdited: created as datetime
Field SubmittedForm.Recipient: created as varchar(50) character set utf8 collate utf8_general_ci
Field SubmittedForm.SubmittedByID: created as int(11) not null default '0'
Field SubmittedForm.ParentID: created as int(11) not null default '0'
Index SubmittedForm.SubmittedByID: created as (SubmittedByID)
Index SubmittedForm.ParentID: created as (ParentID)
Index SubmittedForm.ClassName: created as (ClassName)
SubmittedFormField
Table SubmittedFormField: created
Field SubmittedFormField.ClassName: created as enum('SubmittedFormField','SubmittedFileField') character set utf8 collate utf8_general_ci default 'SubmittedFormField'
Field SubmittedFormField.Created: created as datetime
Field SubmittedFormField.LastEdited: created as datetime
Field SubmittedFormField.Name: created as varchar(50) character set utf8 collate utf8_general_ci
Field SubmittedFormField.Value: created as mediumtext character set utf8 collate utf8_general_ci
Field SubmittedFormField.Title: created as varchar(50) character set utf8 collate utf8_general_ci
Field SubmittedFormField.ParentID: created as int(11) not null default '0'
Index SubmittedFormField.ParentID: created as (ParentID)
Index SubmittedFormField.ClassName: created as (ClassName)
Group
Table Group: created
Field Group.ClassName: created as enum('Group','Group_Unsecure') character set utf8 collate utf8_general_ci default 'Group'
Field Group.Created: created as datetime
Field Group.LastEdited: created as datetime
Field Group.Title: created as varchar(50) character set utf8 collate utf8_general_ci
Field Group.Description: created as mediumtext character set utf8 collate utf8_general_ci
Field Group.Code: created as varchar(50) character set utf8 collate utf8_general_ci
Field Group.CanCMS: created as tinyint(1) unsigned not null default '0'
Field Group.CanCMSAdmin: created as tinyint(1) unsigned not null default '0'
Field Group.Locked: created as tinyint(1) unsigned not null default '0'
Field Group.Sort: created as int(11) not null default '0'
Field Group.ParentID: created as int(11) not null default '0'
Index Group.ParentID: created as (ParentID)
Index Group.ClassName: created as (ClassName)
Table Group_Members: created
Field Group_Members.GroupID: created as int(11) not null default '0'
Field Group_Members.MemberID: created as int(11) not null default '0'
Index Group_Members.GroupID: created as (GroupID)
Index Group_Members.MemberID: created as (MemberID)
Member
Table Member: created
Field Member.ClassName: created as enum('Member') character set utf8 collate utf8_general_ci default 'Member'
Field Member.Created: created as datetime
Field Member.LastEdited: created as datetime
Field Member.FirstName: created as varchar(50) character set utf8 collate utf8_general_ci
Field Member.Surname: created as varchar(50) character set utf8 collate utf8_general_ci
Field Member.Email: created as varchar(50) character set utf8 collate utf8_general_ci
Field Member.Password: created as varchar(64) character set utf8 collate utf8_general_ci
Field Member.RememberLoginToken: created as varchar(50) character set utf8 collate utf8_general_ci
Field Member.NumVisit: created as int(11) not null default '0'
Field Member.LastVisited: created as datetime
Field Member.Bounced: created as tinyint(1) unsigned not null default '0'
Field Member.AutoLoginHash: created as varchar(30) character set utf8 collate utf8_general_ci
Field Member.AutoLoginExpired: created as datetime
Field Member.BlacklistedEmail: created as tinyint(1) unsigned not null default '0'
Field Member.PasswordEncryption: created as enum('none','md2','md4','md5','sha1','sha256','sha384','sha512','ripemd128','ripemd160','ripemd256','ripemd320','whirlpool','snefru','gost','adler32','crc32','crc32b','password','old_password') character set utf8 collate utf8_general_ci default 'none'
Field Member.Salt: created as varchar(50) character set utf8 collate utf8_general_ci
Field Member.Locale: created as varchar(6) character set utf8 collate utf8_general_ci
Field Member.IdentityURL: created as varchar(255) character set utf8 collate utf8_general_ci
Index Member.Email: created as (Email)
Index Member.AutoLoginHash: created as unique (AutoLoginHash)
Index Member.IdentityURL: created as unique (IdentityURL)
Index Member.ClassName: created as (ClassName)
Member_UnsubscribeRecord
Table Member_UnsubscribeRecord: created
Field Member_UnsubscribeRecord.ClassName: created as enum('Member_UnsubscribeRecord') character set utf8 collate utf8_general_ci default 'Member_UnsubscribeRecord'
Field Member_UnsubscribeRecord.Created: created as datetime
Field Member_UnsubscribeRecord.LastEdited: created as datetime
Field Member_UnsubscribeRecord.NewsletterTypeID: created as int(11) not null default '0'
Field Member_UnsubscribeRecord.MemberID: created as int(11) not null default '0'
Index Member_UnsubscribeRecord.NewsletterTypeID: created as (NewsletterTypeID)
Index Member_UnsubscribeRecord.MemberID: created as (MemberID)
Index Member_UnsubscribeRecord.ClassName: created as (ClassName)
Permission
Table Permission: created
Field Permission.ClassName: created as enum('Permission') character set utf8 collate utf8_general_ci default 'Permission'
Field Permission.Created: created as datetime
Field Permission.LastEdited: created as datetime
Field Permission.Code: created as varchar(50) character set utf8 collate utf8_general_ci
Field Permission.Arg: created as int(11) not null default '0'
Field Permission.Type: created as int(11) not null default '1'
Field Permission.GroupID: created as int(11) not null default '0'
Index Permission.GroupID: created as (GroupID)
Index Permission.Code: created as (Code)
Index Permission.ClassName: created as (ClassName)
Widget
Table Widget: created
Field Widget.ClassName: created as enum('Widget') character set utf8 collate utf8_general_ci default 'Widget'
Field Widget.Created: created as datetime
Field Widget.LastEdited: created as datetime
Field Widget.ParentID: created as int(11) not null default '0'
Field Widget.Sort: created as int(11) not null default '0'
Index Widget.ClassName: created as (ClassName)
WidgetArea
Table WidgetArea: created
Field WidgetArea.ClassName: created as enum('WidgetArea') character set utf8 collate utf8_general_ci default 'WidgetArea'
Field WidgetArea.Created: created as datetime
Field WidgetArea.LastEdited: created as datetime
Index WidgetArea.ClassName: created as (ClassName)
GhostPage

Then I tried to return to my login page and got this:

FATAL ERROR: DataObject::buildSQL: Can't find data classes (classes linked to tables) for SiteTree
At line 1367 in /Users/RevStevens/Desktop/Site Test/silverstripe/sapphire/core/model/DataObject.php

user_error(DataObject::buildSQL: Can't find data classes (classes linked to tables) for SiteTree,256)
line 1367 of DataObject.php

DataObject->buildSQL(HomepageForDomain REGEXP '(,|^) *localhost *(,|$)')
line 1611 of DataObject.php

DataObject->instance_get_one(HomepageForDomain REGEXP '(,|^) *localhost *(,|$)',)
line 1572 of DataObject.php

DataObject::get_one(SiteTree,HomepageForDomain REGEXP '(,|^) *localhost *(,|$)')
line 40 of RootURLController.php

RootURLController::get_homepage_urlsegment()
line 23 of RootURLController.php

RootURLController->run(Array)
line 104 of Director.php

Director::direct()
line 158 of main.php

Context

Debug (Debug::showError() in line 180 of Debug.php)

filter =
HomepageForDomain REGEXP '(,|^) *localhost *(,|$)'
sort =
Sort
limit =
join =
restrictClasses =
1
having =
tableClasses =

Ideas?

Avatar
revstevens

29 September 2008 at 7:31am Community Member, 9 Posts

And, now I can't login...
I know this isn't a Silverstripe problem, but damn...

Avatar
Phalkunz

29 September 2008 at 11:40am 69 Posts

Looks like you didn't delete _config.php from mysite or tutorial folder. If you didn't, drop the database and delete _config.php then try again.

Avatar
revstevens

29 September 2008 at 12:01pm Community Member, 9 Posts

OK I just tried that and now it isn't flushing at all.

Avatar
Phalkunz

29 September 2008 at 12:04pm 69 Posts

Try not to use flush option.

Avatar
revstevens

30 September 2008 at 1:01pm Community Member, 9 Posts

But you have to flush it to get the db to rebuild, yes?