#3078 (ok 3.3.6) pmadb data deleted after DROP any table

3.3.5
fixed
1
2013-06-11
2010-08-10
Zairus
No

There's a bug in version 3.3.3 and it persists in version 3.3.5.

All the relations stored (in PMA database) for a database are deleted after drop any table of the same database.
It should delete all the relationships concerning the table that you are dropping but it make a delete for all relations stored for the database.

In the Mysql log:
DELETE FROM `phpmyadmin`.`pma_relation` WHERE master_db = 'exampledb'

If you are upgrading phpmyadmin from a prior version you should be carefully, because when you drop any table all you stored relations made before will go away.

I will attach the complete log for making easy to debug the problem.

Apache 2.2, PHP v5.2, Mysql 5.0

Discussion

  • Zairus

    Zairus - 2010-08-10

    Mysql log

     
  • Zairus

    Zairus - 2010-08-10
    • priority: 5 --> 9
     
  • Zairus

    Zairus - 2010-08-10
    • priority: 9 --> 8
     
  • Marc Delisle

    Marc Delisle - 2010-08-10
    • assigned_to: nobody --> lem9
    • milestone: 1120825 --> 3.3.5
     
  • Marc Delisle

    Marc Delisle - 2010-08-10

    Confirmed. Not just the relations but bookmarks also.

     
  • Marc Delisle

    Marc Delisle - 2010-08-10
    • summary: PMA relations deleted after DROP any table --> pmadb data deleted after DROP any table
     
  • Zairus

    Zairus - 2010-08-10

    Yes, everything in the PMA db concerning the database is deleted, you can see in the logs 8 delete statements associated to the database but without table restriction.

    If you don't have a backup of the PMA db you should reconstruct all the relations/bookmarks from scratch and you'll loose history, etc...

     
  • Marc Delisle

    Marc Delisle - 2010-08-10

    Bug was introduced in 3.3.2, it's a side effect of patch #2976790.

     
  • Marc Delisle

    Marc Delisle - 2010-08-10

    Fixed for 3.3.6; not yet fixed for 3.4.x.

     
  • Marc Delisle

    Marc Delisle - 2010-08-11

    Fixed for 3.4.x in master.

     
  • Marc Delisle

    Marc Delisle - 2010-08-11
    • summary: pmadb data deleted after DROP any table --> (ok 3.3.6) pmadb data deleted after DROP any table
    • priority: 8 --> 1
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2010-08-28
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks