Hello, I searched through the forum and could not seem to find this already posted.
I have the membership suite and the affiliate suite installed. They both seem to be working well. I just can't figure out one thing.
I want the user to earn 10% on the first 10 members they get to sign up and then 25% on all members they sign up for over 10. I can not figure out how to set this up so the system will know after 10 being referred then to bump comissions up to 25%.
The other problem is that when I ran my drupal database update after I installed the Affiliate Suite I got the following errors. I am not sure if this is going to cause me problems later down the road? Thanks.
user warning: Duplicate column name 'date' query: ALTER TABLE ms_affiliates_genealogy ADD `date` INT DEFAULT NULL in /home/prayingh/public_html/includes/database.mysql-common.inc on line 298.
The following queries were executed
ms_paypal_api module
Update #6200
• Failed: ALTER TABLE {ms_affiliates_genealogy} ADD `date` INT DEFAULT NULL
• ALTER TABLE {ms_affiliates_genealogy} CHANGE `date` `date` INT NOT NULL
**Send Trouble Ticket to developer - I can not find any errors due to the above message.
Mcleodn,
That error isn't important, it was just there because some versions of MySQL had trouble with setting the field to NULL instead of 0.
As for the other feature, that isn't possible right now, but I think I may be able to put it in as a feature. I'm adding it to the list now, but it may be a month before it gets put in, simply because of more pressing features and issues that need to be taken care of first.
Sincerely,
Leighton Whiting