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

Ver 2.3 | Admin side crash


Reply


2 Posts   1032 Views

Avatar
BuddhaSource

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

Source
419    }
420    
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       }
427       
428       user_error($msg, $errorLevel);
429    }
430    
431    /**
432     * Return a boolean type-formatted string
433     *
434     * @params array $values Contains a tokenised list of info about this data type
Trace

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

Avatar
BuddhaSource

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.

EDIT :

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.

Thanks.