Log file grows and grows after installing

  • Recently I installed the shorten-url plugin by SedLex from:
    https://www.ads-software.com/plugins/shorten-url/

    Everything worked fine for a while then all of sudden I kept on getting the below error message in my PHP log. So many that my provider (Windows Azure) started warning me. For now I just keep deleting the log file but that is not really a solution. Does anyone have a clue on how to solve this? I would like to keep the plugin and its config if possible. The plugin works as expected as far as I can see. A wordpress update didn’t help (now on 3.7)

    [28-Oct-2013 20:27:00 UTC] WordPress database error Table ‘DBNAME.wp_pluginsl_shorturl’ doesn’t exist for query SHOW COLUMNS FROM wp_pluginSL_shorturl LIKE ‘url_externe’ made by require(‘DIR\wwwroot\wp-blog-header.php’), require_once(‘DIR\wwwroot\wp-load.php’), require_once(‘DIR\wwwroot\wp-config.php’), require_once(‘DIR\wwwroot\wp-settings.php’), do_action(‘init’), call_user_func_array, pluginSedLex->update_plugin, shorturl->_update

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

  • Have you tried to deactivate the plugin and then reactivate it ?

    Thread Starter kjonge

    (@kjonge)

    yes, it didn’t make a difference.

    Do you have access to you database ? Is there an table wp_pluginsl_shorturl ?

    Thread Starter kjonge

    (@kjonge)

    That table does not exist :(. How can I get it?

    The only way is to deinstall the plugin and reinstall … normally a simple deactivation-reactivation should also work

    Thread Starter kjonge

    (@kjonge)

    Both didn’t work for me :(. Can you point me to the script to create the table so I can create it manually.

    I will give you the script but don’t you have any error log when activating/installing the plugin.

    You could try to avoid the problem but I assume that there is a bigger issue that we should discover as it may generate other further issue in the futur

    Thread Starter kjonge

    (@kjonge)

    This is the issue I found in the log:

    [08-Nov-2013 17:24:45 UTC] WordPress database error BLOB/TEXT column ‘short_url’ can’t have a default value for query CREATE TABLE wp_pluginSL_shorturl (id_post mediumint(9) NOT NULL, nb_hits mediumint(9), short_url TEXT DEFAULT ”, url_externe VARCHAR( 255 ) NOT NULL DEFAULT ”,UNIQUE KEY id_post (id_post, url_externe)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci made by activate_plugin, do_action(‘activate_shorten-url/shorten-url.php’), call_user_func_array, pluginSedLex->install, pluginSedLex->singleSite_install, dbDelta
    [08-Nov-2013 17:24:45 UTC] WordPress database error BLOB/TEXT column ‘short_url’ can’t have a default value for query CREATE TABLE wp_pluginSL_shorturl (id_post mediumint(9) NOT NULL, nb_hits mediumint(9), short_url TEXT DEFAULT ”, url_externe VARCHAR( 255 ) NOT NULL DEFAULT ”,UNIQUE KEY id_post (id_post, url_externe)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci made by activate_plugin, do_action(‘activate_shorten-url/shorten-url.php’), call_user_func_array, pluginSedLex->install, pluginSedLex->singleSite_install

    I am using ClearDB to host the MySQL as part of Windows Azure
    https://www.cleardb.com/developers/help/faq

    ah … we progress…
    Please execute the following command in SQL

    CREATE TABLE wp_pluginSL_shorturl (id_post mediumint(9) NOT NULL, nb_hits mediumint(9), short_url TEXT, url_externe VARCHAR( 255 ) NOT NULL DEFAULT '',UNIQUE KEY id_post (id_post, url_externe)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

    Obviously it is a problem with the version of the SQL database

    I removed the default value of the text field

    Thread Starter kjonge

    (@kjonge)

    thanks, ill try it tonight when I get home.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Log file grows and grows after installing’ is closed to new replies.