Are there any tricks to the join the aren't mentioned in this forum? If I strip out the join it's fine -- and I've checked and double checked the table/column names. I have this and it does not work:
AuthName "Member Only Area"
AuthType Basic
AuthGroupFile /dev/null
AuthMySQLKeepAlive Off
AuthMySQLHost localhost
AuthMySQLDB db_ii3
AuthMySQLUser ii3_member
AuthMySQLPassword password
AuthMySQLUserTable "Members, SubAccounts"
AuthMySQLNameField MemberUsername
AuthMySQLPasswordField MemberPassword
AuthMySQLCryptedPasswords Off
AuthMySQLPwEncryption none
# Column “status” with value of 1:
AuthMySQLUserCondition "Members.MemberSubAccountID = SubAccounts.SubAccountID AND SubAccounts.SubAccountSiteID = 16 AND MemberActive = 1"
require valid-user
ErrorDocument 401 /401.php
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Unfortunately, the module isn't currently designed to handle joins between tables. If you check the Apache log, you'll probably see an error about your SQL syntax being incorrect.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are there any tricks to the join the aren't mentioned in this forum? If I strip out the join it's fine -- and I've checked and double checked the table/column names. I have this and it does not work:
AuthName "Member Only Area"
AuthType Basic
AuthGroupFile /dev/null
AuthMySQLKeepAlive Off
AuthMySQLHost localhost
AuthMySQLDB db_ii3
AuthMySQLUser ii3_member
AuthMySQLPassword password
AuthMySQLUserTable "Members, SubAccounts"
AuthMySQLNameField MemberUsername
AuthMySQLPasswordField MemberPassword
AuthMySQLCryptedPasswords Off
AuthMySQLPwEncryption none
# Column “status” with value of 1:
AuthMySQLUserCondition "Members.MemberSubAccountID = SubAccounts.SubAccountID AND SubAccounts.SubAccountSiteID = 16 AND MemberActive = 1"
require valid-user
ErrorDocument 401 /401.php
Unfortunately, the module isn't currently designed to handle joins between tables. If you check the Apache log, you'll probably see an error about your SQL syntax being incorrect.