Forums

[Plugin: WordTwit] MySQL query broken (fix included) (3 posts)

  1. Matt
    Member
    Posted 3 years ago #

    My apache error log was being filled with these 2 errors every page access after installing this plugin.

    [error] WordPress database error Table 'my_database_name.wp_tweet_urls' doesn't exist for query describe wp_tweet_urls made by require, require_once, require_once, require_once, do_action, call_user_func_array, wordtwit_init, wordtwit_check_table
    [error] WordPress database error BLOB/TEXT column 'original' used in key specification without a key length for query CREATE TABLE <code>wp_tweet_urls</code> (<code>id</code> int(10) unsigned NOT NULL auto_increment,<code>original</code> varchar(512) collate utf8_bin default NULL,<code>url</code> varchar(7) collate utf8_bin NOT NULL,<code>views</code> int(11) NOT NULL default '0',<code>post_id</code> int(11) NOT NULL default '0',PRIMARY KEY  (<code>id</code>),UNIQUE KEY <code>url_index</code> (<code>url</code>),KEY <code>original</code> (<code>original</code>),KEY <code>url_index_2</code> (<code>url</code>)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; made by require, require_once, require_once, require_once, do_action, call_user_func_array, wordtwit_init, wordtwit_check_table

    Solution is to define the key length for the 'original' key, in the wordtwit.php file, in the function wordtwi_check_table(), change line to read:
    "KEYoriginal(original`(512))," .
    `

    http://wordpress.org/extend/plugins/wordtwit/

  2. Matt
    Member
    Posted 3 years ago #

    hmm that formatting got messed up, let's try that again...

    "KEY 'original' ('original'(512))," .

  3. dunkydoodle
    Member
    Posted 2 years ago #

    holy f'n crap! that fixed things for me. thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags