#4232 (ok 4.1.6) User not found after creating the user

4.1.5
fixed
privileges (5)
1
2015-02-18
2014-01-15
No

I just got the error message "The selected user was not found in the privilege table" after creating the user.

1) Click the Users tab, fill out some bogus information with no global privileges selected. I checked the "Create database with same name and grant all privileges" checkbox, but that doesn't seem to matter.
2) Click Go; the resulting page shows the overview of all users.
3) Click the Edit privileges link for the new user. I get taken to the Edit page, but see "The selected user was not found in the privilege table" at the top of the screen.

I don't know if it's related, but at this point I get two notices and backtraces at the bottom of the screen:

Notice in ./libraries/Util.class.php#1953
 Undefined index: query

Backtrace

./libraries/Util.class.php#1859: PMA_Util::splitURLQuery(string '#')
./libraries/Util.class.php#1319: PMA_Util::linkOrButton(
string '#',
string 'Inline',
array,
)
./libraries/server_privileges.lib.php#2328: PMA_Util::getMessage(
NULL,
string 'CREATE USER \'db\'@\'%\';GRANT USAGE ON *.* TO \'db\'@\'%\' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `db`;GRANT ALL PRIVILEGES ON `db`.* TO \'db\'@\'%\';',
)
./server_privileges.php#276: PMA_getExtraDataForAjaxBehavior(
string '',
string 'CREATE USER \'db\'@\'%\';GRANT USAGE ON *.* TO \'db\'@\'%\' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `db`;GRANT ALL PRIVILEGES ON `db`.* TO \'db\'@\'%\';',
string '',
string 'db',
)
Notice in ./libraries/Util.class.php#1861
 Undefined offset: 1

Backtrace

./libraries/Util.class.php#1319: PMA_Util::linkOrButton(
string '#',
string 'Inline',
array,
)
./libraries/server_privileges.lib.php#2328: PMA_Util::getMessage(
NULL,
string 'CREATE USER \'db\'@\'%\';GRANT USAGE ON *.* TO \'db\'@\'%\' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `db`;GRANT ALL PRIVILEGES ON `db`.* TO \'db\'@\'%\';',
)
./server_privileges.php#276: PMA_getExtraDataForAjaxBehavior(
string '',
string 'CREATE USER \'db\'@\'%\';GRANT USAGE ON *.* TO \'db\'@\'%\' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `db`;GRANT ALL PRIVILEGES ON `db`.* TO \'db\'@\'%\';',
string '',
string 'db',
)

Discussion

  • Isaac Bennetch

    Isaac Bennetch - 2014-01-15
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -6,6 +6,7 @@
    
     I don't know if it's related, but at this point I get two notices and backtraces at the bottom of the screen:
    
    +~~~~
     Notice in ./libraries/Util.class.php#1953
      Undefined index: query
    
    @@ -47,3 +48,4 @@
     string '',
     string 'db',
     )
    +~~~~
    
     
  • Ann + J.M.

    Ann + J.M. - 2014-01-15
    • labels: --> privileges
     
  • Marc Delisle

    Marc Delisle - 2014-01-18
    • Group: Latest_Git --> 4.1.5
     
  • Marc Delisle

    Marc Delisle - 2014-01-18
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2014-01-18
    • summary: User not found after creating the user --> (ok 4.1.6) User not found after creating the user
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-01-26
    • Status: resolved --> fixed