We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 46886
    • 1,154 Posts
    Hello, I have found a problem that seems to only cause trouble so far when confirming the account in mobile. However the user is confirmed and can login with the generated password

    Here is my snippet:

    [[!Register?
        &form=`register`
        &submitVar=`login-register-btn`
        &activationResourceId=`[[++sbs_confirm_register_page_id]]`
        &submittedResourceId=`[[++sbs_thank_you_page_id]]`
        &postHooks=`SubscribeForm`
        &usergroups=`Users:Member`
        &generatePassword=`1`
        &activationttl=`9990`
        &useExtended=`0`
        &activationEmailTpl=`sbsActivationEmailTpl`
        &activationEmailSubject=`Please activate your account at [[++site_name]]!`
        &validate=`nospam:blank,
             email:required:email`


    Also I have errors upon creation and confirmation of accounts, even when the confirmation goes through

    [2018-09-06 14:29:09] (ERROR @ /home/rayxilaw/public_html/core/xpdo/xpdo.class.php : 644) Could not load class: msCategory from mysql.mscategory.
    [2018-09-06 14:29:14] (ERROR @ /home/rayxilaw/public_html/core/xpdo/xpdo.class.php : 1320) Could not get table class for class: modAccess
    [2018-09-06 14:29:14] (ERROR @ /home/rayxilaw/public_html/core/xpdo/xpdo.class.php : 1289) Could not get table name for class: modAccess
    [2018-09-06 14:29:14] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 240) 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` = 61' at line 1
    )
    
    [2018-09-06 14:29:46] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 811) fdPaths: Attempt to set NOT NULL field media_source_id to NULL
    [2018-09-06 14:29:46] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 811) fdPaths: Attempt to set NOT NULL field media_source_id to NULL
    [2018-09-06 14:29:46] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 811) fdPaths: Attempt to set NOT NULL field media_source_id to NULL
    [2018-09-06 14:30:03] (ERROR @ /home/rayxilaw/public_html/core/xpdo/xpdo.class.php : 644) Could not load class: msCategory from mysql.mscategory.
    [2018-09-06 14:30:17] (ERROR @ /home/rayxilaw/public_html/core/xpdo/xpdo.class.php : 1320) Could not get table class for class: modAccess
    [2018-09-06 14:30:17] (ERROR @ /home/rayxilaw/public_html/core/xpdo/xpdo.class.php : 1289) Could not get table name for class: modAccess
    [2018-09-06 14:30:17] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 240) 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` = 62' at line 1
    )
    
    [2018-09-06 14:31:08] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 811) fdPaths: Attempt to set NOT NULL field media_source_id to NULL
    [2018-09-06 14:31:08] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 811) fdPaths: Attempt to set NOT NULL field media_source_id to NULL
    [2018-09-06 14:31:08] (ERROR @ /home/rayxilaw/public_html/core/xpdo/om/xpdoobject.class.php : 811) fdPaths: Attempt to set NOT NULL field media_source_id to NULL


    could the &usergroups be causing the problem?
      • 3749
      • 24,544 Posts
      It looks like an error with Media Sources, though I can't think of any reason that would be relevant to the process.

      Also, Afaik, fdPaths is not field used by MODX or Subscribe, so maybe another extra has a plugin that's causing the problem.
        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
        • 46886
        • 1,154 Posts
        Looks like a bug in FileDownload-R. Could it be causing the error on confirmation? I've re-routed them to the signin page and it seems nothing else is wrong
          • 3749
          • 24,544 Posts
          It's a snippet, so maybe there's a tag for it on the page or in the template? If not, the error msg may be unrelated.
            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
            • 46886
            • 1,154 Posts
            I will haul it out, looks like I can use another option.

            But if its not related, then something is going wrong with no error...

            Hmm I got to pull out the filedownload code and see [ed. note: nuan88 last edited this post 5 years, 7 months ago.]