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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

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

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

Table 'ss_silver.staffpage_live' doesn't exist. Help please!


Go to End


3 Posts   1895 Views

Avatar
mauzik

Community Member, 2 Posts

19 January 2010 at 12:38am

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.

Avatar
ajshort

Community Member, 244 Posts

19 January 2010 at 1:42am

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

Avatar
mauzik

Community Member, 2 Posts

19 January 2010 at 1:49am

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