WordPress.org

1. anand_s
   Member
   Posted 1 year ago #

   I have a multisite wordpress installation. Whenever I go to the "Users" link of the root site, the list of users is empty. The list of users for all the other non-root sites seem to work fine.

   (When I say root site, I mean the blog accessible by http://mydomainname.com/, the other blogs address being http://mydomainname.com/something)

   When I look at the php error log, I see this line:

   WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' COUNT(*) FROM wp_usermeta WHERE meta_key = 'wp_1_capabilities'' at line 1 for query SELECT , COUNT(*) FROM wp_usermeta WHERE meta_key = 'wp_1_capabilities' made by WP_List_Table->views, WP_Users_List_Table->get_views, count_users

   I have searched for this error on google, and the forums, but haven't found any similar reports. I started getting this error only after I upgraded to 3.1.1 from 3.0.x.

   Could anyone help me out with this? Thanks.

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   Check if your DB needs a repair (via phpMyAdmin)

3. anand_s
   Member
   Posted 1 year ago #

   If you note the error carefully, you'll see that the query string is malformed. It says "SELECT , COUNT(*)". Why is this happening?

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   Right I got that. Check if the DB need repair first :) Costs you nothing.

   Second would be to re-apply a manual upgrade in case you have a file corruption.

   Third is to turn off ALL your plugins.

   But since you don't even wanna follow step 1 advice....

5. anand_s
   Member
   Posted 1 year ago #

   Well, I have checked the database for corruption -- one of the first things I did. I've tried turning off all plugins -- doesn't help.

6. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   You didn't say you did, I try not to assume people do what I think is logical :) All sorts of skillsets here.

   Did you try a manual re-upgrade?

Topic Closed

This topic has been closed to new replies.