939 Posts in 271 Topics by 291 members
Forum Module
SilverStripe Forums » Forum Module » Server Error after Rebuilding Database
Discuss the Forum Module.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 688 Views |
-
Server Error after Rebuilding Database
10 December 2012 at 9:02am
Hello,
I just installed the forum module, and rebuilt the database. There were no errors while rebuilding, and the site is fine until I attempt to login to the admin area, where I get a message saying:
Server error
Sorry, there was a problem with handling your request.Additionally, all CSS and the theme no longer work on the page displaying the server error (though they do elsewhere, eg the About page) and all links are based on the root instead of the subdirectory in which Silverstripe is installed — eg the About link points to ./about-us instead of ./silverstripe/about-us.
I've tried reinstalling twice. Any help?
-
Re: Server Error after Rebuilding Database
11 December 2012 at 8:02pm
Please read the common questions sticky post. Generic server errors are not useful so you'll have to put the site into dev mode.
http://www.silverstripe.org/general-questions/show/16055
http://doc.silverstripe.org/framework/en/topics/debugging#dev-mode -
Re: Server Error after Rebuilding Database
12 December 2012 at 6:12am Last edited: 12 December 2012 6:14am
In dev mode I now get:
[User Error] Couldn't run query: SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."Bounced", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."ForumRank", "Member"."Occupation", "Member"."Company", "Member"."City", "Member"."Country", "Member"."Nickname", "Member"."FirstNamePublic", "Member"."SurnamePublic", "Member"."OccupationPublic", "Member"."CompanyPublic", "Member"."CityPublic", "Member"."CountryPublic", "Member"."EmailPublic", "Member"."LastViewed", "Member"."Signature", "Member"."SuspendedUntil", "Member"."AvatarID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Email" = 'jeremiirossu@gmail.com' AND "Password" IS NOT NULL) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 Unknown column 'Member.ForumRank' in 'field list'
POST /silverstripe/Security/LoginForm
Line 580 in /home/arekkusu/blackwhitestudios.com/silverstripe/framework/model/MySQLDatabase.php
Source
571 }
572
573 public function databaseError($msg, $errorLevel = E_USER_ERROR) {
574 // try to extract and format query
575 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
576 $formatter = new SQLFormatter();
577 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
578 }
579
580 user_error($msg, $errorLevel);
581 }
582
583 /**
584 * Return a boolean type-formatted string
585 *
586 * @param array $values Contains a tokenised list of info about this data type
Trace
Couldn't run query: SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."Bounced", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."ForumRank", "Member"."Occupation", "Member"."Company", "Member"."City", "Member"."Country", "Member"."Nickname", "Member"."FirstNamePublic", "Member"."SurnamePublic", "Member"."OccupationPublic", "Member"."CompanyPublic", "Member"."CityPublic", "Member"."CountryPublic", "Member"."EmailPublic", "Member"."LastViewed", "Member"."Signature", "Member"."SuspendedUntil", "Member"."AvatarID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Email" = 'jeremiirossu@gmail.com' AND "Password" IS NOT NULL) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 Unknown column 'Member.ForumRank' in 'field list'
MySQLDatabase.php:580
MySQLDatabase->databaseError(Couldn't run query: SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."Bounced", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."ForumRank", "Member"."Occupation", "Member"."Company", "Member"."City", "Member"."Country", "Member"."Nickname", "Member"."FirstNamePublic", "Member"."SurnamePublic", "Member"."OccupationPublic", "Member"."CompanyPublic", "Member"."CityPublic", "Member"."CountryPublic", "Member"."EmailPublic", "Member"."LastViewed", "Member"."Signature", "Member"."SuspendedUntil", "Member"."AvatarID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Email" = 'jeremiirossu@gmail.com' AND "Password" IS NOT NULL) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 | Unknown column 'Member.ForumRank' in 'field list',256)
MySQLDatabase.php:132
MySQLDatabase->query(SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."Bounced", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."ForumRank", "Member"."Occupation", "Member"."Company", "Member"."City", "Member"."Country", "Member"."Nickname", "Member"."FirstNamePublic", "Member"."SurnamePublic", "Member"."OccupationPublic", "Member"."CompanyPublic", "Member"."CityPublic", "Member"."CountryPublic", "Member"."EmailPublic", "Member"."LastViewed", "Member"."Signature", "Member"."SuspendedUntil", "Member"."AvatarID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Email" = 'jeremiirossu@gmail.com' AND "Password" IS NOT NULL) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1,256)
DB.php:130
DB::query(SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."Bounced", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."ForumRank", "Member"."Occupation", "Member"."Company", "Member"."City", "Member"."Country", "Member"."Nickname", "Member"."FirstNamePublic", "Member"."SurnamePublic", "Member"."OccupationPublic", "Member"."CompanyPublic", "Member"."CityPublic", "Member"."CountryPublic", "Member"."EmailPublic", "Member"."LastViewed", "Member"."Signature", "Member"."SuspendedUntil", "Member"."AvatarID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Email" = 'jeremiirossu@gmail.com' AND "Password" IS NOT NULL) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1,256)
SQLQuery.php:930
SQLQuery->execute()
DataList.php:716
DataList->first()
DataObject.php:2844
DataObject::get_one(Member,"Email" = 'jeremiirossu@gmail.com' AND "Password" IS NOT NULL)
MemberAuthenticator.php:49
MemberAuthenticator::authenticate(Array,MemberLoginForm)
call_user_func_array(Array,Array)
MemberLoginForm.php:237
MemberLoginForm->performLogin(Array)
MemberLoginForm.php:128
MemberLoginForm->dologin(Array,MemberLoginForm,SS_HTTPRequest)
Form.php:363
Form->httpSubmission(SS_HTTPRequest)
RequestHandler.php:184
RequestHandler->handleRequest(SS_HTTPRequest,DataModel)
RequestHandler.php:204
RequestHandler->handleRequest(SS_HTTPRequest,DataModel)
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel)
Director.php:307
Director::handleRequest(SS_HTTPRequest,Session,DataModel)
Director.php:119
Director::direct(/Security/LoginForm,DataModel)
main.php:126I have no programming experience. What should I do now?
-
Re: Server Error after Rebuilding Database
13 December 2012 at 8:01pm
Ah so that indicates that it's querying the member database incorrectly (before it's been rebuilt). You should be able to run site.com/dev/build?isDev=1 to bypass the member query part.
-
Re: Server Error after Rebuilding Database
14 December 2012 at 6:12am
The database was successfully rebuilt, but now when I try to access /forums/ or any individual forum I get a 403 Forbidden error. What now?
| 688 Views | ||
|
Page:
1
|
Go to Top |
