Re: SilverStripe forums + Recaptcha module

forumq42 — Fri, 17 May 2013 06:50:08 +1200

Resolved.

The issue was neither the keys nor any sort of firewall issue.

The issue was there were 2 captcha fields being created, and they must have been one on top of the other on the page because it appeared only 1 was on the page when the registration form appeared. However after submitting and looking at the network traffic it was obvious 2 challenges were being sent to Google/recaptcha. The first returned as correct, the second always returning incorrect. Additionally, looking at the page source there were 2 different regions that called recaptcha Javascript code which looked suspicious.

I had added the line:
$protector = SpamProtectorManager::update_form($form, 'MyCaptcha');

to ForumMemberProfile.php and also added a Recaptcha field to the forum. From what I gather, the Spam Protection module must generate that on it's own when it's configured to use Recaptcha so in essence I had added a 2nd field. I removed the added 2 lines and things were working. Checking the network traffic there was then only a single challenge to Google/recaptcha.

Posted to: SilverStripe forums + Recaptcha module | Show Thread | Post Reply

SilverStripe forums + Recaptcha module

forumq42 — Wed, 15 May 2013 07:12:30 +1200

http://www.silverstripe.org/recaptcha-module/

I had SilverStripe 2.4.x + the Forum module + Recaptcha (+Spam Protection module) working on a fresh install of SilverStripe. However, repeating the same steps on the production server I seem to be getting the response:

"Your answer didn't match the captcha words, please try again"

after submitting the Forum user registration form, even when the Recaptcha is obviously correct.

I'm wondering if there's some domain/keys issue. I've tried using public/private global keys for both the domain of the URL (http://foo.bar.org) and the hostname of the actual web servers (let's say: server1.gronk.org).

The steps I have done are basically:

- installed Forum module
- installed Recaptcha into /html/recaptcha
- registered w/google.com/recaptcha and generated a public/private keypair for the domain I am using
- installed Spam Protection module into /html/spamprotector
- /dev/build on the site
- ?flush=1 on the site

- in /mysite/_config.php added 3 lines:
RecaptchaField::$public_api_key = '<public key copied from google.com/recaptcha>';
RecaptchaField::$private_api_key = '<private key copied from google.com/recaptcha>'';
SpamProtectorManager::set_spam_protector('RecaptchaProtector');

- in /forums/code, edited 2 files: ForumMemberProfile.php, ForumRole.php

ForumMemberProfile.php, added this line under line 165 the check "if(class_exists('SpamProtectionManager')":
$protector = SpamProtectorManager::update_form($form, 'MyCaptcha'); // to make the recaptcha work with your form

ForumRole.php, added a recaptca field under line 171 to the $personalDetailsField form code:
new RecaptchaField('MyCaptcha')

A Recpatcha image box appears but 100% of the time after the form is submitted the response is:
"Your answer didn't match the captcha words, please try again"

and the user is not registered but rather brought back to the form back to try again. Is there something obvious I am forgetting?

Suggestions?

Posted to: SilverStripe forums + Recaptcha module | Show Thread | Post Reply

Re: problem adding moderators

forumq42 — Sat, 11 May 2013 10:26:55 +1200

If one has installed the Forum module and the TagField module, any suggestion as to why the moderator tab would not appear in the Content tab when a particular forum is selected from within the CMS?

I do not see the moderator tab regardless of which member I am logged is as or whether the user is in the Security tab designated as an Admin or a Moderator.

Posted to: problem adding moderators | Show Thread | Post Reply

Re: SilverStripe 3 and Forum Search

Ramon — Thu, 09 May 2013 06:14:25 +1200

Hi nbenn,

even though your post is a bit older, I ran across the same issues today.

I am upgrading our website from SS2 to SS3 and the forum does not run perfectly out of the box and sure needs some love...

Being a pragmatical developer, I just used the Google Custom Search. Took about 30 Minutes to implement (the long way, with a separate search results page).

This may not be a valid way for everybody, but I think it should be mentioned here.

Cheers
Ramon

Posted to: SilverStripe 3 and Forum Search | Show Thread | Post Reply

Re: SESSIONS!!

susgeek — Sun, 05 May 2013 00:04:49 +1200

You may need to change your session.save_path in php.ini

Posted to: SESSIONS!! | Show Thread | Post Reply

Re: Problem with Forum Modul Installation

blogsash — Sun, 28 Apr 2013 12:27:35 +1200

The problem has now been solved by itself. The Forum was suddenly there and I was able to register've already written the first posts.

Posted to: Problem with Forum Modul Installation | Show Thread | Post Reply

Problem with Forum Modul Installation

blogsash — Sat, 27 Apr 2013 06:47:39 +1200

Hello people,

I've got a problem and that I would bring the Forum module for running. I have now installed the module and it is on my website under http://internet-blogger.org forum accessible.

The problem is that I can not see any link to register. I've probably done something wrong or?

Can anyone help me? Thanks in advance!

Posted to: Problem with Forum Modul Installation | Show Thread | Post Reply

Re: Notifications of New Postings by Email - Module

davepolyester — Wed, 24 Apr 2013 09:27:26 +1200

Hey beautiful people,

Thought you might be interested in my latest developments to elgordo's Forum Notifications module. This version sends a notification email only to the designated Moderators of each forum, plus all Administrators. I've also made minor cosmetic improvements to the generated email to include the recipient Member's first name and the title of the forum that has been posted to (see populateTemplate array).

Next stage:
- filter out Administrators from the Moderators group so people who are both an Administrator and Moderating a particular forum don't get two emails.
- allow the email sender address to be defined via the CMS, plus other text in the email.
- further extend the the Forum module so individual Members can opt in and out of receiving emails for particular forums. (At this stage planning to achieve this by duplicating and tweaking the code that assigns Moderators to particular forums, and allowing people to opt in and out via their Profile page.)

Cheers,

Dave

Posted to: Notifications of New Postings by Email - Module | Show Thread | Post Reply

Re: Forum module in SilverStripe 3.1 beta

Platypus — Wed, 24 Apr 2013 04:15:57 +1200

Thanks for this hint, it helped me very much with SS 3.1 and the forums module.

Posted to: Forum module in SilverStripe 3.1 beta | Show Thread | Post Reply

click on Button new Thread and Post

kerry — Fri, 19 Apr 2013 17:49:17 +1200

Hello
I have a question. I want to insert a Button into the SilverStripe a Page. When I click this button it should creates a new thread and post with the name "test" automatically . How can I do that? Where should I write down what?

Does anyone have an idea?

Sorry for bad english ;)

Posted to: click on Button new Thread and Post | Show Thread | Post Reply

Re: Integrating other forum software

forumq42 — Fri, 08 Mar 2013 11:37:48 +1300

I was also wondering if there were any easy solutions to integrating other forum software (e.g. SimpleMachines Forum, phpBB) as a module under SilverStripe.

Posted to: Integrating other forum software | Show Thread | Post Reply

Re: Problem with GeoIP

tutalib — Sun, 17 Feb 2013 16:01:57 +1300

good answer
__________
tutalib

Posted to: Problem with GeoIP | Show Thread | Post Reply

Re: [newbie] installation maxskitter module

pali — Sat, 16 Feb 2013 07:35:40 +1300

Hi,

SS3 version doesn't use checkboxes, relations are added via autocomplete searach above the gridfield...

Pali

Posted to: [newbie] installation maxskitter module | Show Thread | Post Reply

Re: [newbie] installation maxskitter module

tragicGlory — Sat, 16 Feb 2013 07:33:11 +1300

I don't see any check boxes on my slides list. Am I missing another module? I have the latest version of SS and downloaded the maxskitter module.

Posted to: [newbie] installation maxskitter module | Show Thread | Post Reply

Server error on register and some profile pages

bo — Sat, 16 Feb 2013 03:48:18 +1300

I have an odd issue, or rather two issues that look the same but may have different causes. Navigating to /ForumMemberProfile/register as well as to some profiles (/ForumMemberProfile/show/xx where xx of course is the ID of the profile) gives me an internal server error and nothing is shown. This happens with my profile and with one of my colleague's, while others' seem fine (have not tested all of them).

While no page is displayed, I can still use some of the debugging tools. The only difference visible through debug_request is that SSViewer never goes out looking for SearchForm.ss when loading these pages (both register and said profile pages). I suppose this could ruin the structure of the page (would this create a server error though?), and in any case I'd like to repair it.

The "debug" URL variable shows no differences between working and failing pages.

It's been a long time since I tinkered with this, but when I implemented the forum I made a couple of changes to the structure. Quite possible that this is the source of the problems, but since I have looked all over the place without getting much wiser I figured I'd see if anyone here spots the fault.

Side note: Me and my colleague are also set apart by our db records, which are the only ones containing AutoLoginHash and -Expired values. Can't see a connection, but perhaps there's something (else?) in our records that messes up some part of the call.

Any help and pointing in directions greatly appreciated.

Posted to: Server error on register and some profile pages | Show Thread | Post Reply

Re: Forum module in SilverStripe 3.1 beta

Tony Air — Mon, 04 Feb 2013 23:35:29 +1300

The same issue
fast and dirty solution is to replace 2 functions in ForumHolder.php

CurrentlyOnline()

function CurrentlyOnline() {
      $groupIDs = array();
      $where = '';
      if($forumGroup = Group::get()->filter('Code', 'forum-members')->first()) {
         //$groupIDs[] = $forumGroup->ID;
         $where .= ' "GroupID" = \''.$forumGroup->ID.'\'';
      }

      if($adminGroup = Group::get()->filter('Code', array('administrators', 'Administrators'))->first()) {
         //$groupIDs[] = $adminGroup->ID;
         if($where!=='') {$where .= ' OR';}
         $where .= ' "GroupID" = \''.$adminGroup->ID.'\'';
      }

      return Member::get()
         ->leftJoin('Group_Members', 'Member.ID = Group_Members.MemberID')
         ->where($where)
         //->filter('GroupID', $groupIDs)
         ->filter("LastViewed:GreaterThan", DB::getConn()->datetimeIntervalClause('NOW', '-15 MINUTE'))
         ->sort('Member.FirstName, Member.Surname');
   }

and getLatestMembers()

return $latestMembers;
}

Posted to: Forum module in SilverStripe 3.1 beta | Show Thread | Post Reply

Forum Registration: 3 hours of errors

Oakleaf — Mon, 04 Feb 2013 18:16:26 +1300

Took me over 3 hours to sign up for this Forum; it was by far the most difficult I've seen in over 10 years of web surfing and joining many forums. First, it used the most difficult type of Captcha available. For the 8% of web users whose eyes are not perfect, it is impossible. I had to drive over to a young nephew's house to get his help at reading it.
But then, it refused to accept any of my 5 emails! (And each time, we had to fill out the entire form again, and then go through the Captcha gauntlet yet again). I then called a friend, who let me use one of his email accounts, at comcast, to get it to go through.
But then, repeated attempts brought up every time this error:
"Security token doesn't match, possible CSRF attack"
(And again, another 5 or 10 mintues with each try, needing to refill the forms and re-do the captcha. I ended up paying my nephew $50 for his time.).
3 hours later, I got on, and luckily, was able to then switch to my actual email account, rather than my friends.
What I read about Silverstripe CMs sounds good, but the Forum registration is undoubtedly the worst on the internet. No end-user customer/client anywhere would spend more than 5 or 10 minutes trying to sign up, let alone 3 hours!!

Posted to: Forum Registration: 3 hours of errors | Show Thread | Post Reply

Forum module in SilverStripe 3.1 beta

Josua — Fri, 25 Jan 2013 00:00:02 +1300

Hi all!

The forum module work with Silverstripe 3.1 beta?
It produces errors:
Fatal error: Class declarations may not be nested in C:\wamp\www\forum\code\ForumHolder.php on line 227 (SilverStripe 3.1 beta from github)
[User Error] Couldn't find field GroupID in any of Member's tables (SS 3.1 beta from github)

Somebody has tried it with SS 3.1?

Is there any fix?

Thanks,
Regards,
Jose A.

Posted to: Forum module in SilverStripe 3.1 beta | Show Thread | Post Reply

Re: Internationalization

frankmullenger — Sun, 20 Jan 2013 16:26:37 +1300

You are probably looking for this module:
https://github.com/silverstripe/silverstripe-translatable/blob/master/docs/en/index.md

Posted to: Internationalization | Show Thread | Post Reply

Internationalization

webguync — Fri, 18 Jan 2013 10:10:16 +1300

I am new to SilverStripe and just evaluating it for now. We may need to add a drop down menu to convert the site to different languages. Is there a module available for this?

Posted to: Internationalization | Show Thread | Post Reply

Re: Short Codes (or Extending BBCode) in the Forum Module

johnmblack — Thu, 10 Jan 2013 10:49:48 +1300

I'm actually not on that project anymore since last year; but I think the rest of the team worked something else out. I'll reach out to the current developers to see if they ever solved this, and if so, how.

-John

Posted to: Short Codes (or Extending BBCode) in the Forum Module | Show Thread | Post Reply

Re: Short Codes (or Extending BBCode) in the Forum Module

wojt — Thu, 10 Jan 2013 09:56:31 +1300

Hi johnmblack, have you managed to implement short codes in forums? I'd like to do exactly the same.

Regards,
wojt

Posted to: Short Codes (or Extending BBCode) in the Forum Module | Show Thread | Post Reply

SilverStripe 3 and Forum Search

nbenn — Sat, 05 Jan 2013 05:34:10 +1300

Dear SilverStripe Community

I would like to set up a forum with SilverStripe 3. Unfortunately, however, searching is currently unsupported. Furthermore it does not look as if that is to change anytime soon. The planned search implementation depends on the Fulltext search module (https://github.com/silverstripe-labs/silverstripe-fulltextsearch), which appears to be nowhere near a state where it could be reliably called upon.

While appearing to provide promising features, the Fulltext search module may be an overkill for many smaller projects. As far as i understand, it will rely on a search server such as Solr or Sphinx, which might pose problematic hosting constraints.

In my opinion, the ability to search a forum is among the essential set of features, a forum should provide. Why has there been no initiative to stick with MyISAM 'Post' and 'ForumThread' Tables and continue using the MySQL Fulltext index for searching. From what I have read, InnoDB in MySQL 5.6 supports Fulltext searching, making the inconvenience of having to use different storage engines a temporary one. And even if the long-term plan was to move away from whatever searching capabilities MySQL offers, wouldn't it be a reasonable temporary solution to use the MySQL index?

If anyone has suggestions for an alternate path, or an argument for why the Fulltext search module is the only sensible way to go, please tell.

I forked the forum module (https://github.com/nbenn/silverstripe-forum/commits/master) and restored very basic searching of post contents. Unfortunately I broke result pagination, the ability to search for authors/thread titles, and possibly other functionality. As will be evident to anyone who wants to look at my modifications, I am a complete beginner (this my first web project). I would therefore be very excited if anyone was interested in helping me.

Posted to: SilverStripe 3 and Forum Search | Show Thread | Post Reply

ConfirmedPasswordField sets password to empty

micschk — Fri, 04 Jan 2013 23:09:35 +1300

I am using the forum module on 3.0.3, and am customizing the memberprofile form. What I want is for a user's password to be unchanged if the password field is left empty. (In the default form, you have to fill out your password twice every time you want to update something in your profile.)

So, I'm using the following code:

...
public function updateForumFields(FieldList $fieldset) {

   $member = Member::currentUser();
   if($member){
      // Make filling out password optional for existing members (
      $fieldset->removeByName('Password');
      $fieldset->push( $pw = new ConfirmedPasswordField("Password", "Wachtwoord", null, null, $showOnClick = true, "Bevestig wachtwoord") );
   }
   return $fieldset;

}

This is producing a collapsible ConfirmedPasswordField ('Click link to change password'). But, the password still gets updated (to an empty string) even when a user hasn't edited/updated the password fields.

Should I be checking for an empty password by hand somewhere in doSave()? Right now, the updating routine just consists of:

$form->saveInto($member);
$member->write();

Posted to: ConfirmedPasswordField sets password to empty | Show Thread | Post Reply

Re: Notifications of New Postings by Email - Module

davepolyester — Thu, 03 Jan 2013 15:45:36 +1300

Hi again,

Good news, have made some progress, building on Gordon's great little module.

This version sends an email to all Forum Members with a ForumRank of either Moderator or Administrator:

class ForumEmailPostDecoratorV2 extends DataObjectDecorator {

   //Email all Forum Administrators and Moderators when a post is made to any forum
   function onAfterWrite() {
      $moderators = DataObject::get("Member","ForumRank = 'Administrator' OR ForumRank = 'Moderator'", "", "");
      if($moderators) {
         foreach($moderators as $member) {

            error_log("LOG MESSAGE FROM FORUM EMAIL POST DECORATOR LINK IS ".$this->owner->AbsoluteLink());
            $email = new Email();
            $email->setFrom(Email::getAdminEmail());
            $email->setTo($member->Email);
            $email->setSubject('New Forum Posting - ' . $this->owner->Title);
            $email->setTemplate('Forum_ModeratorNotificationV2'); //duplicate the original template, rename and modify it as desired, including adding the Recipient's name, see below.
            $email->populateTemplate(array(
               'Recipient' => $member->FirstName, //personalise the email with the recipients first name.
               'AbsoluteLink' => $this->owner->AbsoluteLink(),
               'Title' => $this->owner->Title,
               'Content' => $this->owner->Content
            ));
            $email->send();
         }
         parent::onAfterWrite();
      }
   }
}

Note - don't forget to modify the module's config file to extend Post:

DataObject::add_extension('Post', 'ForumEmailPostDecoratorV2');

Next step is to refine this so emails are only sent to the designated moderator(s) of specific forums. Any help on that from the experts would be much appreciated.

Cheers,

Dave

Posted to: Notifications of New Postings by Email - Module | Show Thread | Post Reply

recaptcha does not display in chrome browswer.

NA — Fri, 28 Dec 2012 01:44:45 +1300

Hi,

recaptcha does not display in chrome browswer. but working fine in IE and Mozilla.
If i see in devloper tools of chrome browser it has been shwoing error message as below.

Failed to load resource : https://www.google.com/recaptcha/api/challenge?k="Public key"

Please help me out

Thanks in advance

Posted to: recaptcha does not display in chrome browswer. | Show Thread | Post Reply

Re: Server Error after Rebuilding Database

Arekusandaa — Fri, 14 Dec 2012 06:12:57 +1300

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?

Posted to: Server Error after Rebuilding Database | Show Thread | Post Reply

Re: Server Error after Rebuilding Database

Willr — Thu, 13 Dec 2012 20:01:35 +1300

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.

Posted to: Server Error after Rebuilding Database | Show Thread | Post Reply

Re: Using the forum module to manage user registration

cdmein — Wed, 12 Dec 2012 10:49:33 +1300

Thanks so much for that.

I have installed the module and can register / update / login etc. a new user so that is great. I will be working with the module over the coming month so will certainly log anything I find.

If you feel the module is at the stage it can be tested (if not deployed live) it might be worth updating the master readme file to highlight where the 3.0 branch lives. I didn't think of checking for a branch which is silly of me but others might miss it too.

Thanks

Chris

Posted to: Using the forum module to manage user registration | Show Thread | Post Reply

Re: Using the forum module to manage user registration

ajshort — Wed, 12 Dec 2012 10:21:08 +1300

Hi,

If you check out the development branch from the repository, that's where the SS3 compatible version lives. It hasn't yet been fully upgraded, but I think most of the basics work. If you run into any issues it would be good if you could open an issue.

I will eventually finish upgrading the module, but unfortunately at the moment I haven't had the time.

Posted to: Using the forum module to manage user registration | Show Thread | Post Reply

Re: Server Error after Rebuilding Database

Arekusandaa — Wed, 12 Dec 2012 06:12:29 +1300

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:126

I have no programming experience. What should I do now?

Posted to: Server Error after Rebuilding Database | Show Thread | Post Reply

Re: Server Error after Rebuilding Database

Willr — Tue, 11 Dec 2012 20:02:49 +1300

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

Posted to: Server Error after Rebuilding Database | Show Thread | Post Reply

Re: Using the forum module to manage user registration

cdmein — Mon, 10 Dec 2012 16:13:17 +1300

I have just checked the head of GitHub against 3.0.3 - the functionality doesn't build. I get a deprecation error:

[User Deprecated] DataObjectDecorator is deprecated. DataObjectDecorator is deprecated. Use DataExtension instead

Looking at GitHub there is very little activity with a pull-request outstanding. It certainly doesn't appear that the module has been updated to work with SilverStripe 3.0

I'm not sure you have the power but is there some way of SilverStripe contacting AJShort about this module? The thing is that registering users is pretty fundamental stuff and would be great to do in a standard way. What is the standard way in 3.0 is the question I guess?

Chris

Posted to: Using the forum module to manage user registration | Show Thread | Post Reply

Server Error after Rebuilding Database

Arekusandaa — Mon, 10 Dec 2012 09:02:06 +1300

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?

Posted to: Server Error after Rebuilding Database | Show Thread | Post Reply

Re: Using the forum module to manage user registration

Willr — Sun, 02 Dec 2012 18:06:20 +1300

You could do that, though the member profiles module will be better - https://github.com/ajshort/silverstripe-memberprofiles. No idea if will be updated to 3.0 any time soon (or if it is already!)

Posted to: Using the forum module to manage user registration | Show Thread | Post Reply

Using the forum module to manage user registration

cdmein — Tue, 20 Nov 2012 10:05:44 +1300

I am committed to Silverstripe 3 at a new development house and have, after some initial issues (install Widgets first!), am enjoying the CMS/framework.

At present there seems to be a real patchy coverage of modules however. In particular there is no module to support user registration which is what I need to look at with some urgency.

So what I was wondering is whether I could use the Forums module code (that offers registration etc. from the documentation) and use that to register users. My idea is that I could simply hide the forum itself from my site menu but use the backend administation tools to manage the userbase.

Is that a really bad idea or would that be a quick way to get a fully featured user registration 'module' working?

Thanks

Chris

Posted to: Using the forum module to manage user registration | Show Thread | Post Reply

Re: How to reduce form spam?

swaiba — Sat, 10 Nov 2012 01:40:14 +1300

http://www.silverstripe.org/emailverifiedmember-module/

Posted to: How to reduce form spam? | Show Thread | Post Reply

How to reduce form spam?

Fraser — Fri, 09 Nov 2012 10:44:34 +1300

A client of ours has a review form that is getting heavily spammed.

The form currently utilises mathspamprotector and they are getting 1-2 spam submissions an hour. In a bid to reduce this, I tried implementing invisible field spam protection and the recapcha module. The recapcha module was the worst and at one stage, they were getting around 40 submissions an hour getting through. Because of this, I have reverted back to mathspamprotection and they keep trickling through.

Does anyone have any ideas as to other means of protection I could implement?

Thanks
Fraser

Posted to: How to reduce form spam? | Show Thread | Post Reply

Re: Notifications of New Postings by Email - Module

davepolyester — Thu, 08 Nov 2012 17:15:48 +1300

Hi team,

Would love to know if there has been further progress on providing email notifications to Moderators of forums whenever a new post is made?

Client is crying out for this but it's beyond my current coding abilities to deliver on it easily.

Thanks,

Dave

Posted to: Notifications of New Postings by Email - Module | Show Thread | Post Reply

Re: Documentation?

shoostar — Tue, 25 Sep 2012 09:07:15 +1200

Yup, that definitely worked! I remember reading something about the "?flush=1" step somewhere in the official documentation some time back when I first started researching the Silverstripe CMS, I guess it just slipped my mind. Forums and blogs work perfectly fine now, thank you so much! Silverstripe is definitely an awesome CMS. I've already gone through a couple tutorials on how to extend the CMS a bit (creating an articles section and staff directory), and have even made my own tweaks to those as well. Good stuff!

Posted to: Documentation? | Show Thread | Post Reply

Re: Documentation?

Willr — Sat, 22 Sep 2012 17:15:06 +1200

. When I go to my actual website however, I don't see anything in regards to posting a new topic, nor do I see a "registration" or "login" link.

Do you see anything related to the forum (i.e you should see a search form for forms, all the categories and available forums) if you don't see that on your forums page then the templates have not be found. Make sure you're viewing the latest changes to the page by adding ?flush=1 to the URL.

Posted to: Documentation? | Show Thread | Post Reply

Documentation?

shoostar — Thu, 20 Sep 2012 04:56:12 +1200

I've noticed that this was brought up at least once before, but what are the chances of getting a little bit more documentation for the forums module? I'm really new to using Silverstripe, and so far I haven't had too much trouble with getting the basics down, but I seem to be having some major issues with getting the forums to work.

I was able to get them installed (they show up on the Pages list, and the /dev/build/ bit worked as well for building the new database tables), but when I go to my pages module, all I can do is set up the main forum module itself, as well as setting up some categories. When I go to my actual website however, I don't see anything in regards to posting a new topic, nor do I see a "registration" or "login" link. How would I go about adding these to the website? I'm currently running the latest stable versions of Silverstripe and the forums module (as of the time of this writing, that would be v3.0.2 and v1.0-beta1, respectively), and haven't added anything else to the CMS, minus the blog module (v0.6.0).

I feel that it's also worth mentioning that I'm having the same issue with the blog module, as I seem to have no means of actually posting (or viewing) any blogs. A default blog post was set up, but when I click on the "Blog" button in the main navigation, it simply takes me to the blog page (with the description that I was able to edit), but does not show any blogs at all. Mind you, I made sure that the sample blog post was published and made visible to anyone.

Posted to: Documentation? | Show Thread | Post Reply

forum module error

beseti 1 — Wed, 12 Sep 2012 00:41:06 +1200

Hi there, can anyone help?

I have Installed a forum module for SS i'm currently using 2.3.3version

But After I've installed the "forum" file on the back end.

I receive a message that says "File not found" on firefox, and "This webpage is not found" on google Chrome.

_____________________________________________________________

I followed all the instructions but still I get the error message.

Another thing is that, when I run the "mysite.co.za/dev/build/?flush=1" I receive this error message

"[User Error] Couldn't run query: CREATE TABLE `ForumCategory` ( `ID` int(11) not null auto_increment, `ClassName` enum('ForumCategory') character set utf8 collate utf8_general_ci default 'ForumCategory', `Created` datetime, `LastEdited` datetime, `Title` varchar(100) character set utf8 collate utf8_general_ci, `StackableOrder` varchar(2) character set utf8 collate utf8_general_ci, `ForumHolderID` int(11) not null default '0', index `ForumHolderID` (ForumHolderID), index `ClassName` (ClassName), primary key (ID) ) TYPE=MyISAM You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 14
GET /dev/build/flush=1

Line 401 in /home/neutrog7/public_html/sapphire/core/model/MySQLDatabase.php"

I've also attached an image to give more sense of the error that i'm getting.

Thanks

Posted to: forum module error | Show Thread | Post Reply

Re: Customizing the forum registration form

Yokelassence — Sun, 09 Sep 2012 20:25:00 +1200

Hello again, bumping an old topic I know. But I figured I should give you my results

So I decided not to mess with the original registration form for the forum. I have left it as is in order to avoid creating more problems in the long term. Instead I focused on adding the necessary code to my own registration form so that it has the power to create an object of the Member class

In my own registration form I copied the code from the forum function called doregister which is inside the file called ForumMemberProfile.php and added that to my own code

The key part you need is this:

$forumGroup = DataObject::get_one('Group', "Code = 'forum-members'");

if ($member = DataObject::get_one("Member", "`Email` = '" . Convert::raw2sql($data['email']) . "'")) {
if ($member) {
$form->addErrorMessage("Blurb",
_t('ForumMemberProfile.EMAILEXISTS', 'Sorry, that email address already exists. Please choose another.'),
"bad");

// Load errors into session and post back
Session::set("FormInfo.Form_RegistrationForm.data", $data);
Director::redirectBack();
return;
}
} elseif ($this->OpenIDAvailable() && ($member = DataObject::get_one("Member",
"`IdentityURL` = '" . Convert::raw2sql($data['IdentityURL']) . "'"))) {

if ($member) {
$form->addErrorMessage("Blurb",
_t('ForumMemberProfile.OPENIDEXISTS', 'Sorry, that OpenID is already registered. Please choose another or register without OpenID.'),
"bad");

// Load errors into session and post back
Session::set("FormInfo.Form_RegistrationForm.data", $data);
Director::redirectBack();
return;
}
} elseif ($member = DataObject::get_one("Member",
"`Nickname` = '" . Convert::raw2sql($data['Nickname']) . "'")) {
if ($member) {
$form->addErrorMessage("Blurb",
_t('ForumMemberProfile.NICKNAMEEXISTS', 'Sorry, that nickname already exists. Please choose another.'),
"bad");

// Load errors into session and post back
Session::set("FormInfo.Form_RegistrationForm.data", $data);
Director::redirectBack();
return;
}
}

$member = Object::create('Member');
$member->Nickname = $data['Nickname'];
$member->Firstname = $data['Firstname '];
$member->Surname = $data['Surname '];
$member->Occupation = $data['Occupation '];
$member->Company = $data['Company '];
$member->City = $data['City '];
$member->Country = $data['Country '];
$member->Email = $data['Email '];
$member->write();
$member->login();

$forumGroup->Members()->add($member);

I love how I can call such classes from anywhere within Silverstripe. This works just fine outside of the original forum code so long as my registration form still carries the expected database fields (This is all inside $data)

With that together with all the other dependent code snippets from ForumMemberProfile.php tucked away inside my controller it worked like a charm. Whenever customers sign up with the website they automatically get a forum account with their subscription

BUT I should also add that I did this before I saw Willr's comment

Now having seen Willr's comment, I'm going to suggest that instead. I haven't played with DataObjectDecorator before (nice example here) so it did not cross my mind but that would be the correct way of extending the forum's registration form with new fields.

My method dodges around the problem rather than addresses it, although it does give me my own form which I have full control over

Posted to: Customizing the forum registration form | Show Thread | Post Reply

want to cut object

hguiniosaz — Sat, 01 Sep 2012 04:59:00 +1200

It is important to achieve further progress, particularly in the labor market, Mr. Bernanke said in his prepared remarks. Taking due account of the uncertainties and limits of its policy tools, the Federal Reserve will provide additional policy accommodation as needed to promote

chelsea vs atletico madrid live stream - fulham vs west ham united live stream - fulham v west ham live stream - west ham v fulham live stream - Everton vs West Brom Live Stream - Everton v West Brom Live Stream - Wigan Athletic vs Stoke City live stream - Wigan vs Stoke live stream - Tottenham Hotspur vs Norwich City live stream - Tottenham vs Norwich live stream - Tottenham v Norwich live stream - man city vs qpr live stream - Manchester City vs Queens Park Rangers Live stream - Manchester City vs qpr Live stream - liverpool vs arsenal live stream - liverpool v arsenal live stream - - arsenal vs liverpool live stream - arsenal v liverpool live stream - manchester united vs southampton live stream - man utd vs southampton live stream - southampton vs man utd live stream - barcelona vs valencia live stream - barcelona vs valencia live - sunderland vs swansea city live stream - sunderland v swansea live stream - chelsea vs atletico madrid live stream - watch chelsea vs atletico madrid live stream - chelsea v atletico madrid live stream - chelsea atletico madrid live stream - chelsea atletico madrid live

Posted to: want to cut object | Show Thread | Post Reply

unable to permenet move

hguiniosaz — Sat, 01 Sep 2012 04:58:23 +1200

Posted to: unable to permenet move | Show Thread | Post Reply

Re: Removing Search

Willr — Sun, 26 Aug 2012 13:48:02 +1200

If you have a custom forum theme then just remove it from the ForumHeader.ss template. Otherwise you could simply hide the form with CSS (#ForumSearch { display: none; }. A fix for forum searching in 3.0 will be coming soon.

Posted to: Removing Search | Show Thread | Post Reply

Removing Search

facon12 — Sat, 25 Aug 2012 04:12:45 +1200

Since the search function does not work at this time, I am trying to stop the search function from displaying. Is there a simple means to do this? I just dont want something that doesn't work showing on my site but I am struggling to figure out where to remove it from. Thanks in advance.

Posted to: Removing Search | Show Thread | Post Reply

Re: Customizing the forum registration form

facon12 — Fri, 24 Aug 2012 07:30:18 +1200

Is there documentation anywhere on the Forum module other than: https://github.com/silverstripe/silverstripe-forum. The documentation there is pretty lacking for knowing what hooks and functions to use to extend the module. I realize i could read through the code in the module but it seems like this would be documented in an api or something along those lines. I get the impression from other posts that the forum module had more documentation for previous versions of silverstripe.

Posted to: Customizing the forum registration form | Show Thread | Post Reply

Re: Customizing the forum registration form

Willr — Sun, 12 Aug 2012 12:39:01 +1200

Create a DataExtension (or DataObjectDecorator in SS2.4) and apply it to the Member base class.

You can then modify the registration form using the extension hook updateForumFields.

Posted to: Customizing the forum registration form | Show Thread | Post Reply