Menu

#2708 (ok 2.11.8) Delete multiple views

2.11.6
fixed
None
1
2013-06-11
2008-06-10
Jacky_PHP
No

After selecting a Database I get the overview of the tables and views in the database. Then I check some of these checkboxes of the views to do sth. with all selected. After that I choose Drop in the select box.

phpMyAdmin is asking me if I want to drop these views:
"DROP TABLE `view1`, `view2`;"

If I confim, I get an Unknown table error. It tries to delete a talble with "drop table" instead of "drop view".

Discussion

  • Marc Delisle

    Marc Delisle - 2008-06-23

    Logged In: YES
    user_id=210714
    Originator: NO

    Cannot reproduce with 2.11.6, everything is OK, even if I use the checkbox beside some tables and some views, the generated statements are correct.

     
  • Marc Delisle

    Marc Delisle - 2008-06-23
    • assigned_to: nobody --> lem9
    • status: open --> pending
     
  • Jacky_PHP

    Jacky_PHP - 2008-06-23
    • status: pending --> open
     
  • Jacky_PHP

    Jacky_PHP - 2008-06-23

    Logged In: YES
    user_id=1978378
    Originator: YES

    Ok. I tried it again. It only happens to views, which has a space in the name.

     
  • Marc Delisle

    Marc Delisle - 2008-06-24
    • priority: 5 --> 1
    • summary: Delete multiple views --> (ok 2.11.8) Delete multiple views
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2008-06-24

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2008-07-28
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed