Getting error message in log

  • Resolved abrown95

    (@abrown95)


    10 years, 7 months ago

    IP Blacklist Cloud is working OK, but I am getting this error message in my logs:

    WordPress database error Specified key was too long; max key length is 1000 bytes for query ALTER TABLE wp_IPBLC_usernames CHANGE COLUMN timestamp timestamp VARCHAR(500) NOT NULL made by do_action(‘admin_init’), call_user_func_array, create_sql, dbDelta

    I recently changed my theme to use a new ComicPress theme, so I don’t know if this affected things. Do you know what that message would mean, and what I could do to fix it? I have a feeling it is due to a new type of post that is created by the ComicPress theme.

    http://wordpress.org/plugins/ip-blacklist-cloud/

Viewing 15 replies - 1 through 15 (of 30 total)
1 2
  • Plugin Author Adiie9

    (@ad33lx)

    10 years, 7 months ago

    Hi,
    which version are you using? no it is not related to theme it is Database error.
    Please tell me the version you are using.

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 7 months ago

    Hi,

    You didn’t reply abrown95 so I believe your problem is solved now.

    Regards,
    Adeel

    Thread Starter abrown95

    (@abrown95)

    10 years, 7 months ago

    I’m sorry – I had such a busy week that I never got a chance to reply.

    I’m using WP 3.6 and IP Blacklist Cloud Version 2.9. I am wondering if the problem is that I installed a different plugin that creates a new type of post.

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 7 months ago

    Hi,

    Its okay about the delay. I rechecked my coding and I am not changing timestamp from INT to varchar 500

    Do you know how to edit plugin files?
    Can you send me error log complete line via email? ad33l@live.com
    error log shows which file created this error I need to know that.

    Regards,
    Adeel

    Jay

    (@jayohare)

    10 years, 5 months ago

    HI – I’m getting a Notice that’s being written to the log over & over again:

    [13-Nov-2013 20:56:16] PHP Notice: Undefined index: action in /wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 2406
    [13-Nov-2013 20:56:16] PHP Notice: Undefined index: action in /wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 2458
    [13-Nov-2013 20:56:16] PHP Notice: Undefined index: action in /wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 2516
    [13-Nov-2013 20:56:16] PHP Notice: Undefined index: action in /wp-content/plugins/ip-blacklist-cloud/ip_blacklist_cloud.php on line 2627

    Is there any way to suppress this?
    Thanks for the great plugin.

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 5 months ago

    Hi,
    Can you tell me which version are you using? I have to check lines of that version in your case.
    -Adeel

    Jay

    (@jayohare)

    10 years, 5 months ago

    Thanks for the quick response – 2.91 on WP 3.5.1

    esmi

    (@esmi)

    10 years, 5 months ago

    Why are you using an old copy of WordPress? Were you aware that your site is currently running a very real risk of being hacked? You need to upgrade WordPress asap.

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 5 months ago

    Hi,
    Jahore Thanks for informing.
    as per “esmi” please update your site and let me know if you are still facing any problem, meanwhile, I am going through my script.
    Thanks.
    -Adeel

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 5 months ago

    I just went through coding and it is recording log for..
    if($_POST[‘action’]==”…”){…}

    As per your PHP settings, if there is no POST variable such as “action”.. it will show error..
    I will keep this in mind and will surely overcome with this issue in next version very soon.
    I am updating IPBLC Server ( http://ip-finder.me/ipblc-server/ )so I am fixing small bugs within plugin as well.
    Meanwhile, please bear with this error log. 🙂
    -Adeel

    Jay

    (@jayohare)

    10 years, 5 months ago

    Thanks @esmi- just updated.

    Jay

    (@jayohare)

    10 years, 5 months ago

    Thank you!

    Robert Darling

    (@robert-darling)

    10 years, 3 months ago

    Hi, I still get this error. You say you aren’t changing timestamp to varchar(500) from int but I beg to differ! I think you’ll find a problem in ip_blacklist_cloud.php. I’ve pulled these two error messages from my error log as I can’t get this plugin to work yet. Using V3.1 at the moment but even after changing the varchar(500) to varchar(300) I still get an error because a default value for visits doesn’t exist.

    01-Jan-2014 16:15:33 UTC] WordPress database error Specified key was too long; max key length is 1000 bytes for query ALTER TABLE wp_IPBLC_usernames CHANGE COLUMN timestamp timestamp VARCHAR(500) NOT NULL made by do_action(‘admin_init’), call_user_func_array, create_sql, dbDelta
    [01-Jan-2014 16:15:35 UTC] WordPress database error Field ‘visits’ doesn’t have a default value for query INSERT INTO wp_IPBLC_blacklist (IP,timestamp) VALUES(‘175.126.111.48′,’1388592935’) made by require(‘C:\inetpub\mushin-aikido\wp-blog-header.php’), require_once(‘C:\inetpub\mushin-aikido\wp-load.php’), require_once(‘C:\inetpub\mushin-aikido\wp-config.php’), require_once(‘C:\inetpub\mushin-aikido\wp-settings.php’), do_action(‘init’), call_user_func_array, IPBLC_blockip

    Hope this helps. The file I mentioned above has more than one instance of varchar(500) in it….

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 3 months ago

    Hi,
    I will look into it today and will update this bug.

    -Adeel

    Plugin Author Adiie9

    (@ad33lx)

    10 years, 3 months ago

    Btw, did you try “Fix” option?
    In admin panel, goto “IP Blacklist -> Fixes” page.
    Also, please check your email.
    I have replied to you with incomplete version 3.2 and I need you to check it.

Viewing 15 replies - 1 through 15 (of 30 total)
1 2
  • The topic ‘Getting error message in log’ is closed to new replies.

Tags