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   4938 Views

Avatar
revstevens

Community Member, 9 Posts

29 September 2008 at 7:26am

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

Community Member, 9 Posts

29 September 2008 at 7:31am

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

Avatar
Phalkunz

69 Posts

29 September 2008 at 11:40am

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

Community Member, 9 Posts

29 September 2008 at 12:01pm

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

Avatar
Phalkunz

69 Posts

29 September 2008 at 12:04pm

Try not to use flush option.

Avatar
revstevens

Community Member, 9 Posts

30 September 2008 at 1:01pm

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