MySQL-Error on a multisite installation
-
Hey,
in my log I saw a MySQL Error:
2016/03/01 12:23:48 [error] 515#515: *1482700 FastCGI sent in stderr: "PHP message: WordPress-Datenbank-Fehler Table 'dbname.wp_2_users' doesn't exist für Abfrage SELECT COUNT( * ) AS items FROMwp_2_users` von require_once(‘wp-admi
n/admin.php’), do_action(‘settings_page_wordpress-social-login’), wsl_admin_main, include(‘/plugins/wordpress-social-login/includes/admin/components/networks/index.php’), wsl_component_networks, wsl_component_networks_sidebar, do_action(
‘wsl_component_networks_sidebar_sections’), wsl_component_networks_sidebar_basic_insights, wsl_get_wordpess_users_count” while reading upstream, client: 77.3.154.22, server: example.com, request: “GET /wp-admin/options-general.p
hp?page=wordpress-social-login&wslp=networks HTTP/1.1″, upstream: “fastcgi://unix:/var/run/nginx-fpm/example.com-php-fpm.socket:”, host: “example.com”, referrer: “https://example.com/wp-admin/options-gen
eral.php?page=wordpress-social-login&wslp=bouncer”
`I fixed it by editing the following file:
“wordpress-social-login/includes/services/wsl.user.data.php”The following line (#48):
$sql = "SELECT COUNT( * ) AS items FROM{$wpdb->prefix}users";Changed the prefix to:
$sql = "SELECT COUNT( * ) AS items FROM{$wpdb->users}";Maybe you can fix it for the next update?
Cheers
Andreas
The topic ‘MySQL-Error on a multisite installation’ is closed to new replies.