WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: kStats Reloaded] New Version MySQL Error (4 posts)

  1. Wasee
    Member
    Posted 4 years ago #

    I just upgraded to the new version of kstat that was available before a couple of hours after that i started getting an error which is getting written in my err0r_log file after every few seconds.

    WordPress database error Column 'ip' cannot be null for query INSERT /*! HIGH_PRIORITY */ INTO wp_kstats_raw ( timestamp, ip, url, user_agent, referrer, spider, search_engine, search_terms, os, browser, feed, user ).......

    Can you please check it? Thanks

    http://wordpress.org/extend/plugins/kstats-reloaded/

  2. Mark Waterous
    Member
    Posted 4 years ago #

    @Wasee,
    Every few seconds? How many times total has it happened?

    There should be no possible way for a hit to occur that doesn't have an IP address attached to it, and kStats looks for this address in HTTP_CLIENT_IP, HTTP_X_FORWARDED_FOR (filtered for local loopbacks) and failing finding it there will use REMOTE_ADDR.

    If it keeps occurring or anybody else sees it I would almost be interested in turning off NOT NULL for that column just to see what other kind of data is being recorded for those hits.

  3. Wasee
    Member
    Posted 4 years ago #

    In morning here it was happening after every few second but from now its happening with delay of few minutes like 10 minutes or 20 etc.

    [24-Nov-2009 16:36:00]
    [24-Nov-2009 16:36:47]
    [24-Nov-2009 16:52:58]
    [24-Nov-2009 17:08:19]
    [24-Nov-2009 17:18:43]
    [24-Nov-2009 17:26:25]
    [24-Nov-2009 19:17:49]
    [24-Nov-2009 19:20:20]
    ..........

    I just realize most of times its happening for Feedburner RSS Bot and sometimes for Visitors.

  4. Mark Waterous
    Member
    Posted 4 years ago #

    What's odd about that is the fact that if kStats doesn't find a valid IP in HTTP_CLIENT_IP or after filtering HTTP_X_FORWARDED_FOR it falls back on REMOTE_ADDR. In so far as I know, it's impossible for REMOTE_ADDR to be empty as it's set on the server and the server needs to know the REMOTE_ADDR in order to send any data.

    Would you be willing to help me debug this? I will of course attempt to locally but since I'm not seeing the same occurrence it's a little harder. If you would, please drop me a line through the contact form on my blog (author homepage or plugin homepage link on the repository) and I'll email you back with some instructions.

    When all is said and done we can post back here with our findings?

Topic Closed

This topic has been closed to new replies.

About this Topic