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.

General Questions /

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

All pages got unpublished, can't reach the login panel


Reply


657 Views

Avatar
Bockbertil

Community Member, 1 Post

15 April 2009 at 12:05am

Hello all!

I'm new to SilverStipre and I've run in to a serious problem. After installing SilverStripe my co-worker was putting on some finishing touches, and for some reason he decided to unpublish all the pages. Even the 'home' page. The only pages he left published (I think) were some sub-pages and the 404 page. Now I can't get access to the page anymore. Even when I try to access the /admin page I receive this error:

Fatal error: Couldn't run query: SELECT * FROM SiteTree_Live WHERE Sort = 1 And Priority = 1 Unknown column 'Priority' in 'where clause' in C:\xampp\htdocs\CUSTOMER_INFO\sapphire\core\model\MySQLDatabase.php on line 394

From what I can tell there is no "Priority" column in any of the tables, even in a fresh SilverStripe install, so I suppose some PHP script takes care of this depending on the sorting of the pages. As there are no published pages, there are no sorting, hence I've got a problem. Is there anyway to publish a page manuallay so that I do not have to re-install silverstripe on this client? Any help is more then welcome, thanks.