WP Affiliate – New members sign up but are not being added to Affiliate List

Tagged: Add User, New Affiliate Signup, signup, WP Affiliate

This topic has 9 replies, 3 voices, and was last updated 11 years, 11 months ago by admin.

Viewing 10 posts - 1 through 10 (of 10 total)

Author

Posts
November 12, 2012 at 5:53 pm #7886

pregen
Member

New affiliates that have signed up cannot access their account. They receive an email confirming the signup but that is all that happens. I do not see them in my Manage Affiliates area. I am able to sign them myself through the WP-Affiliate add/edit within WP.

[http://www.egenconsulting.com/wp-content/plugins/wp-affiliate-platform/affiliates/login.php]

November 13, 2012 at 12:34 am #51310

Peter
Member

Hi,

I just signed up for two test accounts and I was able to confirm the problem you are talking about.

At this stage I’m not sure what may be causing it but please be patient until Admin sees this thread and he will suggest the next course of action.

November 15, 2012 at 4:15 pm #51311

pregen
Member

Thank you Peter. Awaiting response from Admin.

November 16, 2012 at 3:45 am #51312

admin
Keymaster

Have you tried loading a fresh copy of the affiliate pluign?

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

Are you using a Windows server?

November 26, 2012 at 3:27 pm #51313

pregen
Member

I have not tried loading a fresh copy of the plugin. I am willing to do this, however, what will happen to my settings and the current affiliates that I have signed up?

Yes, we are using a Windows server.

November 27, 2012 at 12:15 am #51314

admin
Keymaster

Nothing will happen to your settings and affiliates list and any other data that is saved in the plugin. So please go ahead and load a fresh copy of the plugin then check it.

November 28, 2012 at 6:34 pm #51315
pregen
Member
Tried the refresh copy – no effect. Turned on PHP error logging and got the following error:
```
[27-Nov-2012 01:32:16] WordPress database error Field 'account_details' doesn't have a default value for query INSERT INTO wp_affiliates_tbl
```
Putting empty values for the columns account_details and sec_tier_commission_level are sufficient for us for now.

Is this an error in the column definition (not having a default value) or just the missing column in the INSERT?

Hope this helps. We are running satisfactorily for now. Thanks for looking into this.
November 29, 2012 at 6:47 am #51316

admin
Keymaster

The change you have done is correct.

Normally, you don’t have to specify the value of a column if it is not mentioned in the insert statement. However, a particular variation of Windows server throws a fit with it somethings (this is the effect you are seeing).

Downloading a new copy of the affiliate plugin and updating it should have taken care of it. Something definitely went wrong with your update because the code you shared is old code which tells me that the code on your server is not the new affiliate plugin code.

December 7, 2012 at 2:51 pm #51317

pregen
Member

Thanks for the reply. We considered a getting a new copy but were unsure how to do that. For future reference, how do we download a new copy? My original download link expired.

December 7, 2012 at 10:01 pm #51318

admin
Keymaster

Please read the following two posts. These posts have information on where and how you can download an update/new copy:

https://support.tipsandtricks-hq.com/forums/topic/forum-rules

https://support.tipsandtricks-hq.com/forums/topic/how-to-efficiently-use-the-forum
Author

Posts