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.