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, Ed, biapar, Willr, Ingo, swaiba

Ver 2.3 | Admin side crash

Go to End

2 Posts   1308 Views


Community Member, 57 Posts

29 January 2009 at 4:31am

Edited: 29/01/2009 4:36am

To start with I install ver 2.3 RC2 on my wamp server.

In the admin end I could not see the custom fields, so I downloaded the daily build 27-jan and 28-jan.
Overwrited the entire code and then flushed db.

My front is working fine as usual but I am not able to access admin. I get following error.

[User Error] Couldn't run query: SELECT "SiteTree".*, "GhostPage".*, "ErrorPage".*, "RedirectorPage".*, "VirtualPage".*, "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "GhostPage" ON "GhostPage"."ID" = "SiteTree"."ID" LEFT JOIN "ErrorPage" ON "ErrorPage"."ID" = "SiteTree"."ID" LEFT JOIN "RedirectorPage" ON "RedirectorPage"."ID" = "SiteTree"."ID" LEFT JOIN "VirtualPage" ON "VirtualPage"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ParentID" = 0 AND "SiteTree"."ID" != 0) AND ("Lang" = 'en' OR "Lang" = '' OR "Lang" IS NULL ) AND ("Lang" = 'en' OR "Lang" = '' OR "Lang" IS NULL ) ORDER BY "Sort" Unknown column 'Lang' in 'where clause'
GET /cms2/admin
Line 428 in D:\wamp\www\cms2\sapphire\core\model\MySQLDatabase.php

419 	}
421 	function databaseError($msg, $errorLevel = E_USER_ERROR) {
422 		// try to extract and format query
423 		if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
424 			$formatter = new SQLFormatter();
425 			$msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
426 		}
428 		user_error($msg, $errorLevel);
429 	}
431 	/**
432 	 * Return a boolean type-formatted string
433 	 * 
434 	 * @params array $values Contains a tokenised list of info about this data type

We are developing themes so decided to work on 2.3 directly.


Community Member, 57 Posts

30 January 2009 at 6:13pm

Edited: 30/01/2009 7:40pm

Any suggestion please ? I checked up 29th Jan mid night build too but still no solutions.


I found the solution, seems Windows Folder permission issue.
For me it was folder mysite

Solution, installed in new folder.

I think we need some debug error that should point to the folder permission issue.