Page 1 of 2 12 LastLast
Results 1 to 15 of 19

Thread: Unable to use phpmyadmin to search "users" table.

  1. #1
    Registered Member
    Join Date
    Mar 2004
    Posts
    1,062

    Default Unable to use phpmyadmin to search "users" table.

    Not quite sure what to make of this. We've got a customer on one an older server who is unable to use the cPanel installed, phpmyadmin utility to search their "users" table. Keeps returning:

    " MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0075 sec )"

    But this same customer also has another account on a newer cPanel server where there is no such issue, i.e. the searches work just fine.

    Any advice?

  2. #2
    Registered Member
    Join Date
    Mar 2004
    Posts
    1,062

    Default Re: Unable to use phpmyadmin to search "users" table.

    Update - Looks like I've got the exact same problem as this person:

    SourceForge.net: phpMyAdmin: MySQL returned an empty result set

    I'm totally perplexed by this.

  3. #3
    Registered User
    Join Date
    Aug 2002
    Posts
    3

    Default Re: Unable to use phpmyadmin to search "users" table.

    Having the same problem. Were you able to find any solution?

  4. #4
    Registered Member
    Join Date
    Mar 2004
    Posts
    1,062

    Default Re: Unable to use phpmyadmin to search "users" table.

    No, regretfully no. I've searched all over too.

    At first I thought it was a permissions issue, but there is an issue with trying this from both using phpMyAdmin within cPanel (by the individual hosted account member) and WHM (by the server admin), so I really don't think this is permissions related, but rather possibly some kind of compatibility issue between phpMyAdmin and a recent update of the cPanel system.

  5. #5
    Registered User
    Join Date
    Jan 2013
    Posts
    4
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    I have this same problem. What version of PHP do you use?

    Mine only started after I downgraded from PHP 5.3 to PHP 5.2 due to compatibility issues with my site on my new server. I have read around the internet and a lot of sites seem to suggest it is related to a variable (max_input_vars) which was implemented in PHP 5.3.

    I have not managed to solve it yet, and it's rather annoying. It also affects the users table in my database. I have over 150,000 users and I cannot search the database. If I query it, it works fine. But the search in phpmyadmin does not.

  6. #6
    Registered Member
    Join Date
    Mar 2004
    Posts
    1,062

    Default Re: Unable to use phpmyadmin to search "users" table.

    On the particular server where this problem exists, we are still at 5.2.x. Another server with 5.3.x does not have this issue.

  7. #7
    Registered Member
    Join Date
    Oct 2010
    Posts
    88
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    is your mysql server intact? check /var/lib/mysql/[yourhostname].err file..

  8. #8
    Registered User
    Join Date
    Jan 2013
    Posts
    3
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    I'm getting the same exact issue. It only happens on some tables, not all. When I search using the SQL command it works fine. Definitely a bug and an annoying one at that.

  9. #9
    Registered User
    Join Date
    Aug 2002
    Posts
    3

    Default Re: Unable to use phpmyadmin to search "users" table.

    Ok, I have only tested this on one table, but the problem appears to be on tables with ENUM fields. After I changed ENUM to SET on one of the tables having problems I was able to get results returned from my search.

  10. #10
    Registered User
    Join Date
    Jan 2013
    Posts
    3
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    Quote Originally Posted by Gleem View Post
    Ok, I have only tested this on one table, but the problem appears to be on tables with ENUM fields. After I changed ENUM to SET on one of the tables having problems I was able to get results returned from my search.
    It happens for me on INT but only on some tables. It's very strange.

  11. #11
    Registered Member
    Join Date
    Oct 2010
    Posts
    88
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    are the engines all the same?

  12. #12
    Registered User
    Join Date
    Jan 2013
    Posts
    3
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    Quote Originally Posted by hgrg View Post
    are the engines all the same?
    Yes. All are INNODB.

  13. #13
    Registered Member
    Join Date
    Dec 2012
    Posts
    5
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    Same problem here for the last 3 weeks or so - since the last update. Problem was occurring on all of my servers (5 of them) with different PHP, MySQL ver.

    I've searched on the web and the problem definitely exists because I've found it on few forums - but no solution given so far and cPanel staff doesn't seem to pick this up or do anything about it.

    Just spent some time investigating and won't be getting into to many details - the problem is connected to tables that have ENUM fields and it's connected to the javascript that is used to build AJAX request. Basically if you have an ENUM field and you won't select it, it is being passed as NULL so simple query which should look like that:

    SELECT * FROM test WHERE userid = 1

    looks like that (firebug will help you see the response from AJAX request)

    SELECT * FROM test WHERE userid = 1 AND enum_field = 'null'

    Now how to fix that. Edit this file:

    /usr/local/cpanel/base/3rdparty/phpMyAdmin/js/tbl_select.js

    and replace this:

    if(a["fields["+d+"]"]=="")

    with this:

    if(a["fields["+d+"]"]=="" || a["fields["+d+"]"]==undefined)

    Hope that helps (very annoying bug)!!!

  14. #14
    Registered User
    Join Date
    Jan 2013
    Posts
    4
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Unable to use phpmyadmin to search "users" table.

    Thanks so much slawn - that fixed the problem!

  15. #15
    Registered Member
    Join Date
    Feb 2008
    Posts
    104

    Default Re: Unable to use phpmyadmin to search "users" table.

    Has this issue been reported to / fixed by phpMyAdmin itself ?
    Looks like something they'd want to fix (and not us or cPanel )

Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 5
    Last Post: 08-01-2014, 09:31 AM
  2. Replies: 5
    Last Post: 07-14-2012, 03:48 PM
  3. How to fix the "from email" and "return-path" for users?
    By rhm.geerts in forum E-mail Discussions
    Replies: 3
    Last Post: 09-16-2011, 08:59 AM
  4. Replies: 9
    Last Post: 08-07-2006, 09:22 AM
bargain