Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Let's Just Pretend That I'm A Moron...

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

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

Page: 1 2
Go to End
Author Topic: 4894 Views
  • revstevens
    Avatar
    Community Member
    9 Posts

    Re: Let's Just Pretend That I'm A Moron... Link to this post

    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?

  • revstevens
    Avatar
    Community Member
    9 Posts

    Re: Let's Just Pretend That I'm A Moron... Link to this post

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

  • Phalkunz
    Avatar
    69 Posts

    Re: Let's Just Pretend That I'm A Moron... Link to this post

    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.

  • revstevens
    Avatar
    Community Member
    9 Posts

    Re: Let's Just Pretend That I'm A Moron... Link to this post

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

  • Phalkunz
    Avatar
    69 Posts

    Re: Let's Just Pretend That I'm A Moron... Link to this post

    Try not to use flush option.

  • revstevens
    Avatar
    Community Member
    9 Posts

    Re: Let's Just Pretend That I'm A Moron... Link to this post

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

    4894 Views
Page: 1 2
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.