We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 7243
    • 21 Posts
    whooops, shoulda posted in login area....sorry darn I am making enemies here fast sad but problem still stands:

    first, modx revo 2.0.8 mysql 5.5.12, php 5.3.6 and apache 2.2.17

    having a problem with login.register on local host, the call for register is fine, based on the RTFM, the redirect to the "check your email" page is fine, the id for the activation page is fine, it’s just I have a problem where the email (setup using gmail on localhost for testing) is returning the wrong page, though the id in the browser bar is correct, I deleted the resource it was returning to and now it returns the 404...reset password works fine though
    here is the error.
     [2011-05-17 21:34:37] (ERROR @ /site/index.php) modUserProfile: Attempt to set NOT NULL field internalKey to NULL


    here’s the call
    [[!Register?
        &preHooks=`recaptcha`
        &submitVar=`registerbtn`
        &activationEmailTpl=`ActivationEmailTpl`
        &activationEmailSubject=`Thanks for Registering!`
        &activationResourceId=`112`<---goes to activation page when click on link in email
        &submittedResourceId=`46`<---goes to thanks check your email redirect page
        &usergroups=`sitemember`
    ]]

    and here’s the email template
    <p>[[+username]],</p>
    
    <p>Thanks for registering! To activate your new account, please click on the following link:</p>
    
    <p><a href="[[+confirmUrl]]">[[+confirmUrl]]</a></p>
    
    <p>After activating, you may login with your password and username:</p>
    
    <p>
    Username: <strong>[[+username]]</strong><br />
    Password: <strong>[[+password]]</strong></p>
    
    <p>If you did not request this message, please ignore it.</p>

    the activation page is published, has it’s template, even weirder is if I try to preview the page, it too returns a 404

    the call on the activation page
    [[!ConfirmRegister]]
    if I remove the confimRegister call I can preview the page, I am sure this has something to do with permissions willl try to change how long the email is "live" just saw that in RTFM
    the page in page settings is set to the class key moddocument...dunno if that has anything to do with it, it’s not rich text.

    and yes I do have a user group created called sitemember

    does register need friendly urls to work? cause I don’t know how to edit the .htaccess file for localhost
      • 3749
      • 24,544 Posts
      Do you have Friendly URLs turned on? If so I’d suggest turning them off and making sure there’s no .htaccess file (rename it to ht.access).

      If that fixes it, there’s something wrong with your .htaccess file (or you don’t have one).

      IOW,

      With FURLs on -> .htaccess
      With FURLs off -> no .htaccess

      Usually, it’s the Rewrite Base line that’s wrong.

      The default (/) usually works -- try that first, but if your MODX install is in a subdirectory, you may have to change it to /dirname/.

        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting
        • 7243
        • 21 Posts
        no not at all I am on a localhost and don’t go to furls until I move to a host
        but just notice something, as I am testing I have to remove the users I’ve registered
        and I get this error in the logs in manager
         [2011-05-18 03:27:39] (ERROR @ /site/connectors/security/user.php) Could not get table name for class: modAccess
        [2011-05-18 03:27:39] (ERROR @ /site/connectors/security/user.php) Error 42000 executing statement: 
        Array
        (
            [0] => 42000
            [1] => 1064
            [2] => 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 'AS `modAccess` WHERE `modAccess`.`principal` = 38' at line 1
        )

        I find this odd, so much so I updated to mysql 5.5 thinking I was on an old mysql version 5.1 though docs say it’s supported, anyway this may be the problem? man I just spent a month on this, doing final tests...do I need to rebuild the site with a fresh install and cut and paste all my templates, chunks, snippets, etc?

        the only tables I see in phpMyadmin with modaccess are:
        modx_access_actiondom
        Structure modx_access_actions
        Structure modx_access_category
        Structure modx_access_context
        Structure modx_access_elements
        Structure modx_access_menus
        Structure modx_access_permissions
        Structure modx_access_policies
        Structure modx_access_policy_templates
        Structure modx_access_policy_template_groups
        Structure modx_access_resources
        Structure modx_access_resource_groups
        Structure modx_access_templatevars

        am I missing something?
          • 3749
          • 24,544 Posts
          It could just be a corrupted file in MODX or the Login package. I don’t see anything wrong with what you’re doing.

          You should be able to re-download and do an upgrade install of either one without losing your content.
            Did I help you? Buy me a beer
            Get my Book: MODX:The Official Guide
            MODX info for everyone: http://bobsguides.com/modx.html
            My MODX Extras
            Bob's Guides is now hosted at A2 MODX Hosting