Problems with CUSTOM_USER_TABLE/CUSTOM_USER_META_TABLE

  • I have assumed responsibility for multiple WordPress sites that run version 3.3.1.

    I have tried upgrading one site from 3.3.1 -> 3.5 -> 3.7 -> 3.9 -> 4.8.1.

    Everything was working fine up to and including 3.9 but after the final upgrade to 4.8.1 I’m no longer able to log in.

    The site in question is using CUSTOM_USER_TABLE/CUSTOM_USER_META_TABLE in wp-config.php. If I disable CUSTOM_USER_TABLE/CUSTOM_USER_META_TABLE I have no problems logging in using local credentials, but when i reactivate CUSTOM_USER_TABLE/CUSTOM_USER_META_TABLE I get these errors in my apache error log:

    [Mon Aug 21 13:43:52.946664 2017] [:error] WordPress database error Incorrect table name ” for query SHOW FULL COLUMNS FROM innotour-seo.wp_users made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, call_user_func_array, wp_authenticate_username_password, wp_check_password, wp_set_password, referer: https://innoweb.sdu.dk/innovationCases/wp-login.php?redirect_to=http%3A%2F%2Finnoweb.sdu.dk%2FinnovationCases%2Fwp-admin%2F&reauth=1
    [Mon Aug 21 13:43:52.950920 2017] [:error] WordPress database error Incorrect table name ” for query SHOW FULL COLUMNS FROM innotour-seo.wp_usermeta made by wp_signon, wp_set_auth_cookie, WP_Session_Tokens->create, WP_Session_Tokens->update, WP_User_Meta_Session_Tokens->update_session, WP_User_Meta_Session_Tokens->update_sessions, update_user_meta, update_metadata, add_metadata, referer: https://innoweb.sdu.dk/innovationCases/wp-login.php?redirect_to=http%3A%2F%2Finnoweb.sdu.dk%2FinnovationCases%2Fwp-admin%2F&reauth=1

    The two lines in my wp-config.php is as follows:

    define(‘CUSTOM_USER_TABLE’, ‘innotour-seo.wp_users‘);
    define(‘CUSTOM_USER_META_TABLE’, ‘innotour-seo.wp_usermeta‘);

    Has the syntax for CUSTOM_USER_TABLE/CUSTOM_USER_META_TABLE changed from 3.9 to 4.8.1?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jrrsdu

    (@jrrsdu)

    How do insert text that contains the same character used for entering code?

    Some of the text in my original post look strange because it contains the character used to mark code.

    Regards,
    J?rgen

    Thread Starter jrrsdu

    (@jrrsdu)

    Anybody who can help?

    Regards,
    J?rgen

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Problems with CUSTOM_USER_TABLE/CUSTOM_USER_META_TABLE’ is closed to new replies.