Title: WordPress database error Table Last modified: August 21, 2016 --- # WordPress database error Table * [Watch Teller](https://wordpress.org/support/users/watchteller/) * (@watchteller) * [12 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/) * Hi Yoast, * My server’s error log shown as below once I activated WooCommerce Follow Up Email( trouble shooting – followup_cutomer_id, order _id & price database table repeat 8 times): * > [12-Jul-2013 17:40:50 UTC] WordPress database error Table ‘xxxxxxxxx.wp_users’ > doesn’t exist for query SELECT COUNT(*) FROM wp_users INNER JOIN wp_usermeta > ON (wp_users.ID = wp_usermeta.user_id) WHERE 1 = 1 AND ( wp_usermeta.meta_key > = ‘wp_1_capabilities’ ) made by do_action_ref_array, call_user_func_array, > Yoast_Tracking->tracking * Need help and assist * Thanks * [http://wordpress.org/extend/plugins/wordpress-seo/](http://wordpress.org/extend/plugins/wordpress-seo/) Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/wordpress-database-error-table-1/page/2/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-database-error-table-1/page/2/?output_format=md) * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926706) * Oh dear, that is a bit silly indeed. Thank you for reporting this! I have submitted a [pull request](https://github.com/jdevalk/wordpress-seo/pull/99) which will fix this, so it should hopefully be sorted in the next release. * To get rid of the error for now, please uncheck the checkbox enabling tracking in SEO -> Dashboard. * Once the next version has been released, you can check it again if you like. * Hope this helps. * Smile, Juliette * Thread Starter [Watch Teller](https://wordpress.org/support/users/watchteller/) * (@watchteller) * [12 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926732) * Thanks and fast response. * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926734) * You’re welcome 😉 * Thread Starter [Watch Teller](https://wordpress.org/support/users/watchteller/) * (@watchteller) * [12 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926785) * Hi jrf, * **Update** After uncheck the checkbox enabling tracking that my server error log still have error shown as below: * “[14-Jul-2013 17:34:59 UTC] WordPress database error Table ‘xxxxx.xxx.wp_users’ doesn’t exist for query SELECT COUNT(*) FROM wp_users INNER JOIN wp_usermeta ON (wp_users.ID = wp_usermeta.user_id) WHERE 1 = 1 AND ( wp_usermeta.meta_key = ‘wp_1_capabilities’ ) made by do_action_ref_array, call_user_func_array, Yoast_Tracking- >tracking” * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926788) * [@watch](https://wordpress.org/support/users/watch/) Teller Strange… as the code is only being called upon by tracking and shouldn’t even be included if tracking is disabled. Hmm.. will have a look, but that’s another issue altogether. * For now, let’s just bite our time till the next release which should fix the issue. In the mean, if you like, you can [change the line](https://github.com/jrfnl/wordpress-seo/commit/a564f49050efa4c799c4d11744091a4dedf78f6c) I changed in the pull request in your install. That should definitely get rid of the error. * [@ebuzztoday](https://wordpress.org/support/users/ebuzztoday/) glad to hear it’s gone, but a server reboot should not be able to fix this. Or are you not using database table prefixes ? * [mikeotgaar](https://wordpress.org/support/users/mikeotgaar/) * (@mikeotgaar) * [12 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926862) * [@jrf](https://wordpress.org/support/users/jrf/) [@yoast](https://wordpress.org/support/users/yoast/) FYI Seeing this issue again (latest WordPress plugin version, WP 3.6.1) Tracking is not enabled – still shows log error * May not be directly caused by WordPress SEO. There’s a related bug report for Google Analytics for WordPress ([http://wordpress.org/support/topic/wordpress-database-error-when-using-prefix-other-than-wp_?replies=4](http://wordpress.org/support/topic/wordpress-database-error-when-using-prefix-other-than-wp_?replies=4)) for the same error * Going to do the change suggested in that thread and keep an eye on error logs for a few days. * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926863) * [@mikeotgaar](https://wordpress.org/support/users/mikeotgaar/) * Can you check whether this is really the same error and what version of WPSEO you are on. * The latest version (1.4.18) [does include the fix](http://plugins.trac.wordpress.org/browser/wordpress-seo/trunk/admin/class-tracking.php#L111) I send in a while ago and should not give this error. * FYI: the change suggested in the other thread is basically the same as the one already applied, though my actual fix complies with the WP standards of using wpdb->prepare() while the other fix does not and should give error notices (deprecated warnings). * [mikeotgaar](https://wordpress.org/support/users/mikeotgaar/) * (@mikeotgaar) * [12 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926864) * [@jrf](https://wordpress.org/support/users/jrf/) Thanks for prompt response – WordPress SEO plugin version is 1.4.18 Also confirm the fix is in the file as per the change. * I’m sure this is the GA plugin not WordPress SEO * GA has an anonymous tracking setting – (uses php script very similar to the OLD code you fixed) in /google-analytics-for-wordpress/incl/class-tracking.php on line 113 (Version 4.3.3) * `'users' => $wpdb->get_var( "SELECT COUNT(*) FROM wp_users INNER JOIN wp_usermeta ON (wp_users.ID = wp_usermeta.user_id) WHERE 1 = 1 AND ( wp_usermeta.meta_key = 'wp_{$blog_id}_capabilities' ) " ),` * I’ve got both plugins on several sites – been through all the error logs today– only the one with the GA tracking function enabled produced the error which narrows things down. * Think I got confused from the reference to call_user_func_array, Yoast_Tracking in the log – didn’t notice GA is also Yoasts and uses the same class Yoast_Tracking function * Looks like Yoast’s GA plugin hasn’t had that updated yet – submit the fix and put a (another) feather in your cap 🙂 * So not this plugin, and not a conflict – **my mistake for reporting here** * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926865) * Checked and you are right, the issue is with the GA plugin. [Pull request send](https://github.com/Yoast/google-analytics-for-wordpress/pull/8). No idea if and when it’ll be applied and/or a new versions will be available. * If you want to patch your current install, you can pull the code from my pull request/git fork. * [mikeotgaar](https://wordpress.org/support/users/mikeotgaar/) * (@mikeotgaar) * [12 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926866) * Neat… See there’s quite a few changes – Done both files. Didn’t break anything so all is good. Kudos and many thanks * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926867) * You’re welcome 😉 And the rest of the changes where just best practices applied. * [darkpollo](https://wordpress.org/support/users/darkpollo/) * (@darkpollo) * [12 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926871) * Hi, Any ideas on how to fix this manually? * Thanks * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926872) * [@darkpollo](https://wordpress.org/support/users/darkpollo/): as said in previous replies: if you want to patch your current install, look at the pull request and copy the changes to your own version. * Still, this issue is quite old, so you’d be far better off upgrading to the latest versions as those should have the patches included already. * [darkpollo](https://wordpress.org/support/users/darkpollo/) * (@darkpollo) * [12 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926873) * Hi, Sorry i missed that part of the message. I have just install the plugin so it seems it is not fixed on the latest version. * I will try to fix it. I hope i wont break anything. * Thanks * [Juliette Reinders Folmer](https://wordpress.org/support/users/jrf/) * (@jrf) * [12 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/#post-3926874) * [@darkpollo](https://wordpress.org/support/users/darkpollo/): it most definitely is fixed in the latest WP SEO, but you may be using other related plugins in which it is not fixed yet. Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/wordpress-database-error-table-1/page/2/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-database-error-table-1/page/2/?output_format=md) The topic ‘WordPress database error Table’ is closed to new replies. * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908) * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/) * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * 16 replies * 4 participants * Last reply from: [darkpollo](https://wordpress.org/support/users/darkpollo/) * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-1/page/2/#post-3926875) * Status: not resolved