We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 34162
    • 1 Posts
    I applied the new inc file and install the new module.

    For some reason I can not login to SMF as the admin any longer so I have to re-install SMF to be able to login as the admin.

    Once I re-install I was able to login to SMF as the admin so I start my testing from MODx again but as soon as I click on my link that I setup via TV View Port Widget I still get this message for the first time and is ok after I refresh it.

    : Table ’chanh_zmodx.smf_sessions’ doesn’t exist
    /home/chanh/public_html/smf/Sources/Load.php
    1867

    And is the link: http://www.chanh.blogdns.com/modx/WrapperSMF.html
      • 25663 MODX Staff
      • 12,272 Posts
      I still have errors with the new code and an older copy of the SMF forums on a test server:
      « MODx Parse Error »
      MODx encountered the following error while attempting to parse the requested resource:
      « Execution of a query to the database failed - UPDATE command denied to user 'tattoocms'@'localhost' for table 'smf_members' »
            SQL: UPDATE tattoosmf.smf_members SET dateRegistered='1142975180',ID_GROUP='37',ID_POST_GROUP='4',showOnline='1',lastLogin='1126491154',gender='0',is_activated='1' WHERE ID_MEMBER='3205'; 


      Incidentally, 3205 is the very last record in the smf_members table. The record also contains a hyphen in the email address, so I don’t know if that’s the problem or not... and it’s not as I deleted that record, and then got the following error:
      MODx encountered the following error while attempting to parse the requested resource:
      « Execution of a query to the database failed - UPDATE command denied to user 'tattoocms'@'localhost' for table 'smf_members' »
            SQL: UPDATE tattoosmf.smf_members SET dateRegistered='1142976950',ID_GROUP='37',ID_POST_GROUP='4',showOnline='1',lastLogin='1135640509',gender='0',is_activated='1' WHERE ID_MEMBER='3206'; 


      Member ID 3206 contains no crazy characters, but it’s the first one created (in fact it’s aNoble!).

      Running it again, I get another error message with the same incremental member id and it adds one more record (banzai).

      The SMF database is the big database, btw, and I’m hoping this will pull all the records, not just push them to there. This is strange.

      The module will not run in Safari, I still get the file not found errors.

      These tests were all performed with the files from the Mar 1 7PM email from Raymond and with the files in the first message here on rev 646.

        Ryan Thrash, MODX Co-Founder
        Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
        • 25663 MODX Staff
        • 12,272 Posts
        I also just updated to rev 805 and have identical errors. sad

        If you look at the error, it’s trying to use the tattoocms user to update the tattoosmf table. That’s not going to be allowed, or shouldn’t be I don’t think, as the database user and password are different for the two databases (MODx and SMF).
          Ryan Thrash, MODX Co-Founder
          Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
          • 32963
          • 1,732 Posts
          Ok

          I think I see what’s going on here.

          Edit the file smf.sync.class.inc.php and goto line 126.

          Change it from:

          $modx->db->update($flds,$tbl,"ID_MEMBER='$id'");

          to
          $db->update($flds,$tbl,"ID_MEMBER='$id'");


          save the file then try it again.

          Also remeber to update your log class file with the on that’s attached.



            xWisdom
            www.xwisdomhtml.com
            The fear of the Lord is the beginning of wisdom:
            MODx Co-Founder - Create and do more with less.
            • 25663 MODX Staff
            • 12,272 Posts
            Bingo! Not only didn’t bork out, but it also even told me what it did! laugh
              Ryan Thrash, MODX Co-Founder
              Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me