Menu

#2218 (ok 2.11) # in database name

Latest_Git
fixed
1
2013-06-11
2006-08-16
No

When there is # in database name, phpMyAdmin silently
fails to select this database.

This can be currently seen on our demo server.

Discussion

1 2 > >> (Page 1 of 2)
  • Sebastian Mendel

    Logged In: YES
    user_id=326580

    cannot reproduce, tested with blah# and #blah

     
  • Jürgen Wind

    Jürgen Wind - 2006-09-25

    Logged In: YES
    user_id=1383652

    only just after creating a new db like "ab#2"
    the navi shows "ab", but as soon as you create a table
    it switches to "ab#2" and is selectable via the db dropdown box.

    i think this is negligible.

     
  • Jürgen Wind

    Jürgen Wind - 2006-09-25

    Logged In: YES
    user_id=1383652

    i can confirm only for pma 2.7.0-pl2 ;)

     
  • Michal Čihař

    Michal Čihař - 2006-10-02

    Logged In: YES
    user_id=192186

    I can reproduce with "hehe#", "#hehe" and "huha#hehe". The
    databse is created and selected, however when I select it
    again from left frame, it fails.

     
  • Jürgen Wind

    Jürgen Wind - 2006-10-02

    Logged In: YES
    user_id=1383652

    nijel wrote:
    >databse is created and selected, however when I select it
    >again from left frame, it fails.

    but only as long as no table exists.
    you can select that db from main.php and import/add tables
    after that the db pops up in Navi

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    cannot confirm:

    * create db 'ho#ho' from server_databases.php
    * ho#ho appears in navi and on top in main
    * selecting ho#ho from navi works fine

    tested with SVN on Linux FC7 using FF2

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    using MySQL 5.0.27 with mysqli

     
  • Michal Čihař

    Michal Čihař - 2007-01-29

    Logged In: YES
    user_id=192186
    Originator: YES

    I still can :-)

    1. Create database he#he
    2. Left frame shows "he" only
    3. With light left frame he#he can not be selected.

    4. Attempt to create table in this database.
    5. Left frame switches again to "he"
    6. However after creating table, it switches back to "he#he"

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    oh, the ligth view ... ;-) ... i have it ... but in the drop down it appears correct ...

    but it is selected correct ... just the name is displayed wrong in the navi

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    the problem is that # is not escaped in the URI - so the user agent (Browser) strips all after and including # from the URI before sending the request to the server

     
  • Sebastian Mendel

    • assigned_to: nobody --> cybot_tm
    • labels: 509096 --> Browser/W3C/JS compatibility
    • status: open --> open-accepted
     
  • Sebastian Mendel

    • status: open-accepted --> open-fixed
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    fixed in TRUNK - don't forget to hit STRG-reload and better close your browser for the .js files to be cleaned from cache before testing.

     
  • Sebastian Mendel

    • summary: # in database name --> (ok 2.11) # in database name
     
  • Sebastian Mendel

    • priority: 5 --> 1
     
  • Michal Čihař

    Michal Čihař - 2007-01-29

    Logged In: YES
    user_id=192186
    Originator: YES

    server.encodeURIComponent is not a function
    http://pma.cihar.com/trunk-config/js/querywindow.js
    Line 83

    Firefox 2.0

    Shouldn't it be encodeURIComponent(server)?

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    tested also with FF2 without errors ...

    it is a string function, like all other string function you can use it as

    string.encodeURIComponent()
    or
    encodeURIComponent(string)

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    probably this vars are not always recognized as strings ... changed this in SVN ... please update and test again

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    probably this vars are not always recognized as strings ... changed this in SVN ... please update and test again

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    probably this vars are not always recognized as strings ... changed this in SVN ... please update and test again

     
  • Michal Čihař

    Michal Čihař - 2007-01-29

    Logged In: YES
    user_id=192186
    Originator: YES

    Now works okay, thanks!

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    very well! ... btw. i have this errors too - but i forgot to activate my Firebug extension to show - my mistake! ;-)

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    very well! ... btw. i have this errors too - but i forgot to activate my Firebug extension to show - my mistake! ;-)

     
  • Marc Delisle

    Marc Delisle - 2007-08-21
    • status: open-fixed --> closed-fixed
     
1 2 > >> (Page 1 of 2)