We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 20911
    • 84 Posts
    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Unknown column ’memberName’ in ’field list’ »
    SQL: SELECT memberName, lastLogin, realName, passwd, emailAddress, gender FROM xxxxxxxxx_xxxxxxxxxxx.smf_members
    [Copy SQL to ClipBoard]

    Parser timing
    MySQL: 0.0432 s (6 Requests)
    PHP: 1272995027.0291 s
    Total: 1272995027.0724 s

    Is this normal with this Module or?

    Also when i try to enter the Administration area for SMF Connector it shows Zero sized reply... what to do?
      Mysql 5.1.52
      Apache 2.2.17
      PHP 5.2.12
      Linux
      • 24952
      • 2 Posts
      You’ve likely either found a solution given up on this however I’m posting for the benefit of myself (tracking) and anyone else trying to work through this problem.

      Obviously I’m not a programer or coder - so I’m not suggeting anyone try the below.

      I installed the newest version of SMF (2.0 RC5) because I wanted to try it then I found out the connector isn’t written for this version of SMF.

      The error you have listed seem to be from a difference in the field names between what the connector is calling and what is actually stored in the tables for SMF.
      i.e. in my table it’s "member_name" not "memberName"

      You can edit these field names in the smf.sync.class.inc.php and smf.admin.class.inc.php files in your /assets/modules/smforum/ folder.

      Please Note - I’ve done that and it doesn’t give me the SQL errors but when I click on the connector Admin or Sync links it give me an "Internet Explorer cannot display the Webpage" error.

      I also get that when I manually go to my forum but signout - so there’s still some sort of URL addressing that’s off.

        Ryan Hanlin - nonprofit tech guy
        PHP 5.2.12
        MySQL 5.0.84
        MODx 1.0.4
        Apache 2.2.? - hosted