Jump to:

22997 Posts in 11844 Topics by 2828 members

General Questions

SilverStripe Forums » General Questions » Table 'ss_silver.staffpage_live' doesn't exist. Help please!

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Page: 1
Go to End
Author Topic: 979 Views
  • mauzik
    Avatar
    Community Member
    2 Posts

    Table 'ss_silver.staffpage_live' doesn't exist. Help please! Link to this post

    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.

  • ajshort
    Avatar
    Community Member
    244 Posts

    Re: Table 'ss_silver.staffpage_live' doesn't exist. Help please! Link to this post

    The URL to rebuild the database is "/dev/build", not just build.

  • mauzik
    Avatar
    Community Member
    2 Posts

    Re: Table 'ss_silver.staffpage_live' doesn't exist. Help please! Link to this post

    Thank you!!!! Couldn't see such a simple mistake!!! Thank you once again!!!!

    979 Views
Page: 1
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.