Hi guys,
I'm on tutorial 2 'Adding a staff section' and run into MySQL Error.
After creating StaffHolder.php and StaffPage.php I've build/?flush=1 and error occur:
[User Error] Couldn't run query: SELECT `SiteTree_Live`.*, `GhostPage_Live`.*, `ArticlePage_Live`.*, `StaffPage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `GhostPage_Live` ON `GhostPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `StaffPage_Live` ON `StaffPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID WHERE (`SiteTree_Live`.URLSegment = 'build') ORDER BY Sort LIMIT 1 Table 'ss_silver.staffpage_live' doesn't exist
As I see that "Table 'ss_silver.staffpage_live' doesn't exist", but when this table was created? and was it created at all? (should it be created automatically as a part of tutorial?)
Could anyone help me please handle this error?
Thank you.