Support » Plugin: All In One WP Security & Firewall » WordPress database error table

  • Resolved sancukosan

    (@sancukosan)


    Hello,

    I have some database table problem with using this plugin.

    I’m using Multisite and when I’m installing and activating the plugin from Network everything seems fine, but when I’m switch to one of my multisite (example: ID 31), I’m keep getting unknown character set error for some of the tables:

    WordPress database error Unknown character set: 'uft8_swedish_ci' for query CREATE TABLE wp_31_aiowps_login_lockdown
    
    WordPress database error Unknown character set: 'uft8_swedish_ci' for query CREATE TABLE wp_31_aiowps_failed_logins
    
    WordPress database error Unknown character set: 'uft8_swedish_ci' for query CREATE TABLE wp_31_aiowps_login_activity
    
    WordPress database error Unknown character set: 'uft8_swedish_ci' for query CREATE TABLE wp_31_aiowps_global_meta
    
    WordPress database error Unknown character set: 'uft8_swedish_ci' for query CREATE TABLE wp_31_aiowps_events
    
    WordPress database error Unknown character set: 'uft8_swedish_ci' for query CREATE TABLE wp_31_aiowps_permanent_block

    WordPress won’t crash on this error, but when I will try to access the dashboard everything is displayed properly, but I’m getting 4 missing table errors, for example:

    WordPress database error Table 'bitnami_wordpress.wp_31_aiowps_events' doesn't exist for query ...
    
    WordPress database error Table 'bitnami_wordpress.wp_31_aiowps_failed_logins' doesn't exist for query ...
    
    WordPress database error Table 'bitnami_wordpress.wp_31_aiowps_login_activity' doesn't exist for query ...
    
    WordPress database error Table 'bitnami_wordpress.wp_31_aiowps_global_meta' doesn't exist for query ...

    I tried to the following solutions, but I still got the same errors.

    • Deactivate/Activate the plugin again
    • Reinstall the plugin completly

    Any suggestion how to fix this problem?

    Many thanks!

    • This topic was modified 3 years, 1 month ago by sancukosan.
    • This topic was modified 3 years, 1 month ago by sancukosan.
    • This topic was modified 3 years, 1 month ago by sancukosan.
    • This topic was modified 3 years, 1 month ago by sancukosan. Reason: Changing some text style
    • This topic was modified 3 years, 1 month ago by sancukosan. Reason: Changing some text format
    • This topic was modified 3 years, 1 month ago by sancukosan. Reason: Changing some text format
    • This topic was modified 3 years, 1 month ago by sancukosan.
    • This topic was modified 3 years, 1 month ago by sancukosan.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi,
    Regarding your multi-site setup, did you network-activate or individually activate the aiowps plugin?

    Thread Starter sancukosan

    (@sancukosan)

    Hi,
    I activated it from network.

    Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi @sancukosan,
    I will try some tests again on my multi-site test platform and see if I can reproduce this.

    Thread Starter sancukosan

    (@sancukosan)

    Hi @wpsolutions

    Unfortunately I had some incorrectly written format in wp-config for the datababase character set. You can see in the error message it says “uft8_swedish_ci“, instant of utf8_swedish_ci.

    Small mistake that you can’t notice that much, my apologies.

    I will mark it as resolved.

    Anyway, thanks for your help!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error table’ is closed to new replies.