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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Content Editor Discussions /

Forum for content editors and CMS users.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

MemberProfiles Moudle Error while using 3.1.8 release


Go to End


7 Posts   3206 Views

Avatar
Nwa9ja

Community Member, 8 Posts

24 December 2014 at 5:22am

I keep getting error when trying to install MemberProfiles module.

Server Error. There was a problem handling your request.

When I remove the module all is well but as soon as I try to re-install it the same thing.
A user profile management module is essential to the project I am working on so the whole thing is beginning to get frustrating.

PLEASE HELP!

Avatar
martimiz

Forum Moderator, 1391 Posts

25 December 2014 at 2:02am

Hard to tell what's going on based on this info. You can try to get more error information by putting your site in dev mode. Read more about debugging here:

http://doc.silverstripe.org/framework/en/topics/debugging

Avatar
Nwa9ja

Community Member, 8 Posts

28 December 2014 at 7:08am

Hi, thanks for the response.

Here is my error stack

Building database thelord6_central using MySQL 5.5.40-36.1-log

Creating database tables
File
Folder
Image
Image_Cached
Group
LoginAttempt
Member
Field Member.Bio: created as mediumtext character set utf8 collate utf8_general_ci
Field Member.Website: created as varchar(255) character set utf8 collate utf8_general_ci
Field Member.Twitter: created as varchar(30) character set utf8 collate utf8_general_ci
Field Member.Facebook: created as varchar(255) character set utf8 collate utf8_general_ci
Field Member.GooglePlus: created as varchar(255) character set utf8 collate utf8_general_ci
Field Member.HeadshotID: created as int(11) not null default 0
Index Member.HeadshotID: created as ("HeadshotID")
MemberPassword
Permission
PermissionRole
PermissionRoleCode
MemberProfileField
SiteConfig
SiteTree
Field SiteTree.ProvideComments: created as tinyint(1) unsigned not null default 0
Field SiteTree_Live.ProvideComments: created as tinyint(1) unsigned not null default 0
Field SiteTree_versions.ProvideComments: created as tinyint(1) unsigned not null default 0
Page
[User Error] Couldn't run query: SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."Bio", "Member"."Website", "Member"."Twitter", "Member"."Facebook", "Member"."GooglePlus", "Member"."ValidationKey", "Member"."NeedsValidation", "Member"."NeedsApproval", "Member"."PublicFieldsRaw", "Member"."HeadshotID", "Member"."ProfilePageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Member"."ID" = 1) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 Unknown column 'Member.Bio' in 'field list'
GET /dev/build/?flushtoken=868812d32f9968d5eef8423ba8b67d5b&flush=1
Line 598 in /home4/thelord6/public_html/framework/model/MySQLDatabase.php
Source
589 	}
590 
591 	public function databaseError($msg, $errorLevel = E_USER_ERROR) {
592 		// try to extract and format query
593 		if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
594 			$formatter = new SQLFormatter();
595 			$msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
596 		}
597 
598 		user_error($msg, $errorLevel);
599 	}
600 
601 	/**
602 	 * Return a boolean type-formatted string
603 	 *
604 	 * @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"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."Bio", "Member"."Website", "Member"."Twitter", "Member"."Facebook", "Member"."GooglePlus", "Member"."ValidationKey", "Member"."NeedsValidation", "Member"."NeedsApproval", "Member"."PublicFieldsRaw", "Member"."HeadshotID", "Member"."ProfilePageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Member"."ID" = 1) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 Unknown column 'Member.Bio' in 'field list' 
MySQLDatabase.php:598
MySQLDatabase->databaseError(Couldn't run query: SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."Bio", "Member"."Website", "Member"."Twitter", "Member"."Facebook", "Member"."GooglePlus", "Member"."ValidationKey", "Member"."NeedsValidation", "Member"."NeedsApproval", "Member"."PublicFieldsRaw", "Member"."HeadshotID", "Member"."ProfilePageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Member"."ID" = 1) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1 | Unknown column 'Member.Bio' in 'field list',256) 
MySQLDatabase.php:150
MySQLDatabase->query(SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."Bio", "Member"."Website", "Member"."Twitter", "Member"."Facebook", "Member"."GooglePlus", "Member"."ValidationKey", "Member"."NeedsValidation", "Member"."NeedsApproval", "Member"."PublicFieldsRaw", "Member"."HeadshotID", "Member"."ProfilePageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Member"."ID" = 1) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1,256) 
DB.php:208
DB::query(SELECT DISTINCT "Member"."ClassName", "Member"."Created", "Member"."LastEdited", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."RememberLoginToken", "Member"."NumVisit", "Member"."LastVisited", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."DateFormat", "Member"."TimeFormat", "Member"."Bio", "Member"."Website", "Member"."Twitter", "Member"."Facebook", "Member"."GooglePlus", "Member"."ValidationKey", "Member"."NeedsValidation", "Member"."NeedsApproval", "Member"."PublicFieldsRaw", "Member"."HeadshotID", "Member"."ProfilePageID", "Member"."ID", CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName" ELSE 'Member' END AS "RecordClassName" FROM "Member" WHERE ("Member"."ID" = 1) ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC LIMIT 1,256) 
SQLQuery.php:947
SQLQuery->execute() 
DataList.php:762
DataList->first() 
DataList.php:849
DataList->byID(1) 
Member.php:748
Member::currentUser() 
BlogEntry.php:53
BlogEntry->populateDefaults() 
DataObject.php:429
DataObject->__construct() 
ReflectionClass->newInstance() 
InjectionCreator.php:20
InjectionCreator->create(BlogEntry,Array) 
Injector.php:548
Injector->instantiate(Array,BlogEntry) 
Injector.php:854
Injector->get(BlogEntry) 
Core.php:158
singleton(BlogEntry) 
DatabaseAdmin.php:205
DatabaseAdmin->doBuild(,1) 
DatabaseAdmin.php:100
DatabaseAdmin->build() 
DatabaseAdmin.php:80
DatabaseAdmin->index(SS_HTTPRequest) 
RequestHandler.php:288
RequestHandler->handleAction(SS_HTTPRequest,index) 
Controller.php:194
Controller->handleAction(SS_HTTPRequest,index) 
RequestHandler.php:200
RequestHandler->handleRequest(SS_HTTPRequest,DataModel) 
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel) 
DevBuildController.php:25
DevBuildController->build(SS_HTTPRequest) 
RequestHandler.php:288
RequestHandler->handleAction(SS_HTTPRequest,build) 
Controller.php:194
Controller->handleAction(SS_HTTPRequest,build) 
RequestHandler.php:200
RequestHandler->handleRequest(SS_HTTPRequest,DataModel) 
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel) 
RequestHandler.php:222
RequestHandler->handleRequest(SS_HTTPRequest,DataModel) 
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel) 
Director.php:370
Director::handleRequest(SS_HTTPRequest,Session,DataModel) 
Director.php:153
Director::direct(/dev/build/,DataModel) 
main.php:177

I cannot seem to make sense of it for the life of me.

Avatar
martimiz

Forum Moderator, 1391 Posts

29 December 2014 at 12:38am

Looks kind of similar to this issue:

https://github.com/silverstripe-australia/silverstripe-memberprofiles/issues/79

In this case seems like something on your Page class might call Member before the Member table is actually fysically updated. Does your Page class have any custom code added to it? Did you try a second time dev/build?flush=all ?

Avatar
Nwa9ja

Community Member, 8 Posts

29 December 2014 at 3:29am

I tried the solution stated in the issue and nothing worked.
I did http://www.***********.org/dev/build?isDev=1&flush=all a good number of times to no avail, still getting the error message I put up earlier

Avatar
martimiz

Forum Moderator, 1391 Posts

29 December 2014 at 5:28am

Edited: 29/12/2014 5:29am

OK, does your Page have any custom code?

Can you verify that the Bio field actually exists in the Member table in your Database?

Avatar
Nwa9ja

Community Member, 8 Posts

26 January 2015 at 9:36pm

Problem Fixed!
Apparently the Blog module was the cause of the error because when I deleted the blog module the Member profile module installed perfectly.
Thanks for the help.