• Hi,

    I can’t add any subscribers to my email lists. No matter what method I try in admin, I get no confirmation nor error message on submitting a new subscriber. And, the subscriber data isnt added to the list. I even get a new subscriber notification email, but minus the subscribers name/details.

    Here my set-up info:

    ### Begin System Info ###

    ## Please include this information when posting support requests ##

    Multi-site: No

    SITE_URL: http://wordpress.codeclinic.de
    HOME_URL: http://wordpress.codeclinic.de

    SP Version: 0.9.4.1
    WordPress Version: 3.5

    Platform: Windows
    Browser Name: Firefox
    Browser Version: 22.0
    User Agent String: Mozilla/5.0 (Windows NT 6.2; WOW
    64; rv:22.0) Gecko/20100101 Fire
    fox/22.0

    Database Tables:
    wp_sendpress_subscribers_event OK
    wp_sendpress_report_url Not Installed
    wp_sendpress_subscribers_status OK
    wp_sendpress_subscribers OK
    wp_sendpress_list_subscribers OK
    wp_sendpress_queue OK

    PHP Version: 5.5.1
    MySQL Version: 5.6.11-log
    Web Server Info: Microsoft-IIS/7.5

    PHP Memory Limit: 256M
    PHP Post Max Size: 8M

    WP_DEBUG: Disabled

    WP Table Prefix: Length: 3 Status: Acceptable

    Show On Front: page
    Page On Front: Home #1193
    Page For Posts: Home #1193

    Session: Enabled
    Session Name: PHPSESSID
    Cookie Path: /
    Save Path: C:\Windows\Temp\
    Use Cookies: On
    Use Only Cookies: On

    UPLOAD_MAX_FILESIZE: 3MB
    POST_MAX_SIZE: 8MB
    WordPress Memory Limit: 40MB
    WP_DEBUG: Off
    DISPLAY ERRORS: N/A
    FSOCKOPEN: Your server supports fsockopen.

    ACTIVE PLUGINS:

    Contact Form 7: 3.4.2
    Email Address Encoder: 1.0.4
    Hotfix: 1.0
    SendPress: Email Marketing and Newsletters: 0.9.4.1
    Simple Twitter Tweets: 1.3.3
    WordPress SEO: 1.4.13
    WP Events Calendar Plugin: 1.0.1
    WPML Media: 1.4
    WPML Multilingual CMS: 2.9.1
    WPML String Translation: 1.8.1
    WP Project Manager: 0.4.3
    WP SMTP: 1.1.5

    CURRENT THEME:

    Salient: 1.7

    ### End System Info ###

    In the php log file I get the following entry when trying to submit the new subscriber via admin:

    [31-Jul-2013 21:13:26 UTC] WordPress database error Field ‘ip’ doesn’t have a default value for query INSERT INTO wp_knewsusers (email, lang, state, joined, confkey) VALUES (‘[email protected]’,’en’, 1, ‘2013-07-31 23:13:26′,’ac490709’); made by do_action(‘k-news_page_knews_users’), call_user_func_array, KnewsPlugin->KnewsAdminUsers, require(‘I:\wordpress\wp-content\plugins\knews\admin\knews_admin_users.php’)
    [31-Jul-2013 21:14:53 UTC] WordPress database error Field ‘ip’ doesn’t have a default value for query INSERT INTO wp_knewsusers (email, lang, state, joined, confkey) VALUES (‘[email protected]’,’de’, 2, ‘2013-07-31 23:14:53′,’0d5d812f’); made by do_action(‘k-news_page_knews_users’), call_user_func_array, KnewsPlugin->KnewsAdminUsers, require(‘I:\wordpress\wp-content\plugins\knews\admin\knews_admin_users.php’)

    Any ideas what the issue is?

    http://ww.wp.xz.cn/plugins/sendpress/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author itdoug

    (@itdoug)

    do you get that php error when you try to add subscribers? Could be a plugin conflict or possibly something to do with running on a Windows server (unlikely).

    Please try this.

    http://sendpress.com/support/knowledgebase/troubleshooting-plugin-and-theme-conflicts/

    That Knews plugin is not listed above but the errors are for it I think.

    Thread Starter Phill Healey

    (@munklefish)

    Hi,

    Sorry it appears I pasted the wrong lines from the log. Here is the actual error reported in the php log file:

    [05-Aug-2013 15:30:43 UTC] WordPress database error Field ‘registered’ doesn’t have a default value for query INSERT INTO wp_sendpress_subscribers (firstname,email,lastname,join_date,identity_key) VALUES (‘XXXX’,’[email protected]’,’XXXXXXX’,’2013-08-05 15:30:43′,’64333ae3fafd8c5′) made by do_action(‘admin_init’), call_user_func_array, SendPress->admin_init, require_once(‘I:\wordpress\wp-content\plugins\sendpress\inc\helpers\sendpress-post-actions.php’), SendPress->addSubscriber, SendPress_Data->add_subscriber

    Plugin Author Josh Lyford

    (@joshl)

    Hi,

    Thanks for the error log. This is a big help. I am looking into this and will let you know as soon as i have a fix for it.

    Thanks,
    Josh

    Plugin Author Josh Lyford

    (@joshl)

    Hi,

    The next release should fix this problem and should be out this week. Hopefully later today.

    Best,
    josh

    Thread Starter Phill Healey

    (@munklefish)

    Hi,

    Thats great news. Any idea when the update will be available?

    Thanks.

    If can help, I solved the same error changing the default value of the field ‘registered’ in the table wp_sendpress_subscribers from null to 0, my site is on windows

    Thread Starter Phill Healey

    (@munklefish)

    I see no update had been posted yet….

    @Ablesoft – We are also using Windows, so hopefully your suggestion will halp fix the issue for us. Thanks for your help.

    Plugin Author Josh Lyford

    (@joshl)

    Albesoft and munklefish,

    Are you running 0.9.4.6? This should have been resolved with that release if not please let me know.

    Thanks,
    Josh

    Sorry , I was out line for some days cause work, yes, I use the version 0.9.4.6 on a hosting Windows, and I had the same problem, I understand that the solution I have used is just a trick to fix the problem without analyze why the issue is present ( I am novice to php and i have not analyzed the plugin code ), I just thought that was like windows had problems to use the null value so I tried that trick . Thanks You

    Thread Starter Phill Healey

    (@munklefish)

    I can confirm that this is also the case for me.

    I had already uninstalled this plugin, so have just reinstalled it. I set everything up and then tried adding a subscriber manually to my list. It failed as on all previous attempts.

    I went into the MySQL DB and edited the field mention above. It seems this is a DATATIME field so probably shouldnt have a default of NULL set. As a result I couldnt change the default to just ‘0’. I had to change it to ‘000000’ so that the system could interpret it as a DATETIME.

    I went back to sendpress and tried adding the same user details, and this time it worked.

    I installed the latest version of SendPress on a Windows based WP install.

    This would appear to be a quirk related to Windows. However, I suggest that Windows is seeing the NULL value as being invalid for a DATETIME field and so refuses to work. Linux is evidently a bit more forgiving.

    Plugin Author Josh Lyford

    (@joshl)

    Hi munklefish,

    Thanks for the info. I have updated the plugin to set all datetime fields to have a default of ‘0000-00-00 00:00:00’. This should hopefully fix the issue on windows. It will be in the 0.9.4.7 release.

    Best,
    josh

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Cant Add Subscribers’ is closed to new replies.