« 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
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