November 12, 2012 at 5:53 pm #7886
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 #51310PeterMember
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
Thank you Peter. Awaiting response from Admin.November 16, 2012 at 3:45 am #51312
Have you tried loading a fresh copy of the affiliate pluign?
Are you using a Windows server?November 26, 2012 at 3:27 pm #51313
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
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
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
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
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
Please read the following two posts. These posts have information on where and how you can download an update/new copy:
- You must be logged in to reply to this topic.