I've done everything y'all have advised, here, but I still get a page with "registration by invitation only" on it when I try to use an affiliate url created by a new affiliate member.
I created a 2nd account then signed up as an affiliate then used the affiliate link assigned to it like this http://lovencherish.com/?idAff=2 but I still get the same page with these words on it when I click on the Join link on the top right side of the page.
I cleared my browser cache, deleted all of my browser cookies & deleted the cache files the script creates in the cache folder on the server but still the same thing.
I tried it in both I.E. & FireFox but the same thing in both.
Reckon I should try it on another computer other than the one I'm using to build the site?
This is the only thing I haven't tried yet seeing as I only have one computer here.
Is there a setting that I need to find that controls how the cookies are set on the browser when someone visits through an affiliate link?
Any help on this will be greatly appreciated!
Shalom,
Calev
{Edited on 5/28/09 @ 01:44am cdt}
Well... Whether this is how your supposed to do it or not it worked, so far.
What I did was I went back into my admin area to the "Advanced Settings" area & I un-check marked the one that says: "Registration by invitation only (need before Enable affiliate support)" then I tried to access it by way of the affiliate link & was able to signup a new account & the affiliate account whom the url was associated with got the credit.
Only thing is tho when I click on the affiliate number to the right of the member's name under the heading "Memb" in the back office I get an sql error message.
Here it is:
========================
Error
Database query error
Query:
SELECT
`Profiles`.`ID` as `ID`,
`NickName`,
`Email`,
`Sex`,
DATE_FORMAT(`DateLastLogin`, '%m-%d-%y %H:%i' ) AS `DateLastLoginCur`,
DATE_FORMAT(`DateReg`, '%m-%d-%y %H:%i' ) AS `DateReg`,
`Status`
, `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`
FROM `Profiles`
,aff_members
LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID`
WHERE
1 AND `idAff` = 'a number' AND `idProfile` = `Profiles`.`ID` AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
GROUP BY `Profiles`.`ID`
ORDER BY DateLastLogin
LIMIT 0, 30
Mysql error:
Unknown column 'Profiles.ID' in 'on clause'
And this is beneath it
Found error in file
/home/I deleted this/public_html/admin/profiles.php at line
280. Called
db_res function
with erroneous argument #
0Debug backtrace:Array
(
[1] => Array
(
[file] => /home/I deleted this/public_html/admin/profiles.php
[line] => 280
[function] => db_res
[args] => Array
(
[0] =>
SELECT
`Profiles`.`ID` as `ID`,
`NickName`,
`Email`,
`Sex`,
DATE_FORMAT(`DateLastLogin`, '%m-%d-%y %H:%i' ) AS `DateLastLoginCur`,
DATE_FORMAT(`DateReg`, '%m-%d-%y %H:%i' ) AS `DateReg`,
`Status`
, `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`
FROM `Profiles`
,aff_members
LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID`
WHERE
1 AND `idAff` = 'a number' AND `idProfile` = `Profiles`.`ID` AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
GROUP BY `Profiles`.`ID`
ORDER BY DateLastLogin
LIMIT 0, 30
)
)
)
Called script: /admin/profiles.php
Request parameters:Array
(
[showAffMembers] => a number
[sortor] => DateLastLogin
[idAff] => a number
[strSec] => I deleted this
[memberID] => a number
[memberPassword] => I deleted this
[_fjvid1] => I deleted this
[adminID] => I'm not tellin ya
[adminPassword] => I deleted this
Any Ideas about what could be causing this error?
It does the same thing when I click on the other affiliates link for members signed up through their affiliate url's, too.
This is in the admin area not in the affiliate admin.
Shalom,
Calev