BUG: Cannot add social accounts

  • Hi there,

    I’ve just installed the latest version of the plugin but it has an ugly bug:

    There are 3 table created on the installation:
    microblogposter_user_accounts
    microblogposter_old_items
    microblogposter_logs

    But the scripts tries to use (many times in fact) a table called microblogposter_accounts that does not exist:
    WordPress Table ‘xxxx_microblogposter_accounts’ doesn’t exist para a consulta SELECT * FROM xxxx_microblogposter_accounts WHERE type=’flickr’ AND account_id NOT IN (SELECT DISTINCT account_id FROM xxxx_microblogposter_accounts) feita por require_once(‘wp-admin/admin.php’), do_action(‘settings_page_microblogposter’), call_user_func_array, microblogposter_settings_output, microblogposter_show_mini_control_dashboard, MicroblogPoster_Poster::get_accounts_object

    Also there is no unstall function which leaves lots of garbage after removing the plugin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Efficient Scripts

    (@cybperic)

    Try Deactivating / Reactivating the plugin.
    The missing table should be created.

    Thread Starter fkraus

    (@fkraus)

    Thanks for the quick replay.

    In fact I went a bit further on the logs and found out the root cause: “Specified key was too long; max key length is 767 bytes”. It refers to the “UNIQUE username_type (username,type)” statement.

    The issue is mainly due to my DB type (InnoDB) + chartset (utf8mb4_unicode_520_ci) and key length (100+200 chars) meaning that the username+type cannot exceed 255 chars long.

    I will change this manually but I would recommend to change this is the code for the future as other people could have the same issue.

    Notice: I’m just changing this small piece of code: “UNIQUE username_type (username(150),type(100))” so the total key length is under 255 chars.

    Thanks again
    Felipe

    • This reply was modified 7 years, 11 months ago by fkraus.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘BUG: Cannot add social accounts’ is closed to new replies.