We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 24530
    • 100 Posts
    Are there news for the Vanilla-integration?
    Soon I will have to realize a forum on my own ... vanilla sounds great!
      my newest webpage [url=http://gitarren.zucali.at]Meisterwerkstatt f
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      Well, I’m trying... but so far all I get is an error...

      Error Message
      An error occurred while retrieving discussions.
      Affected Elements
      DiscussionManager.GetDiscussionList();

      The error occurred on or near: Unknown column ’u.username’ in ’field list’
      I’m working on trying to figure out where this is and why it’s causing the error. With all the classes and objects and inherited classes and factories and general clever OOP crap it’s really hard to follow the program flow.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 25551 ☆ A M B ☆
        • 1,231 Posts
        I don’t suppose anyone’s managed to integrate Vanilla yet? smiley
          Ross Sivills - MD AugmentBLU Edinburgh, Scotland UK
          AugmentBLU - MODX Partner

          BLUcart - MODX Revolution E-Commerce & Shopping Cart
          • 7455
          • 2,204 Posts
          So is this another treat that died? no forum intergration for modx?

          its sad.
            follow me on twitter: @dimmy01
            • 4172
            • 5,888 Posts
            Thanks for this great bridge, sirlancelot!

            Had some problems because my id and internalKey have not the same value in my table webuserattributes. After hours of searching and debugging I found a little bug, I think, and fixed it like this:

            In function GetUserBuilder() changed
            $s->AddSelect(array('Name', 'RoleID'), 'usr');
            $s->AddSelect(array('UserID', 'FirstName', 'LastName', 'Email', 'UtilizeEmail', 'Icon', 'Picture', 'Attributes', 'Preferences', 'CountVisit', 'CountDiscussions', 'CountComments', 'RemoteIp', 'DateFirstVisit', 'DateLastActive', 'StyleID', 'CustomStyle', 'ShowName', 'UserBlocksCategories', 'DefaultFormatType', 'Discovery', 'SendNewApplicantNotifications'), 'u');


            to

            $s->AddSelect(array('UserID','Name', 'RoleID'), 'usr');
            $s->AddSelect(array('FirstName', 'LastName', 'Email', 'UtilizeEmail', 'Icon', 'Picture', 'Attributes', 'Preferences', 'CountVisit', 'CountDiscussions', 'CountComments', 'RemoteIp', 'DateFirstVisit', 'DateLastActive', 'StyleID', 'CustomStyle', 'ShowName', 'UserBlocksCategories', 'DefaultFormatType', 'Discovery', 'SendNewApplicantNotifications'), 'u');


            In function function GetUserById($UserID) changed

            $s->AddWhere('u', 'UserID', '', $UserID, '=');

            to
            $s->AddWhere('u', 'internalKey', '', $UserID, '=');


            Seems to work now.

            Quote from: sottwell at Jul 28, 2008, 09:23 AM

            I’m working on trying to figure out where this is and why it’s causing the error. With all the classes and objects and inherited classes and factories and general clever OOP crap it’s really hard to follow the program flow.

              -------------------------------

              you can buy me a beer, if you like MIGX

              http://webcmsolutions.de/migx.html

              Thanks!
              • 1331
              • 129 Posts
              Man, too bad this never matured.
                • 4172
                • 5,888 Posts
                  -------------------------------

                  you can buy me a beer, if you like MIGX

                  http://webcmsolutions.de/migx.html

                  Thanks!