Menu

#1082 (ok 3.2.0) add utility for "errno: 150" on innodb

fixed
Utilities (45)
1
2013-06-11
2008-03-13
No

i always use InnoDb engine, so from time to time creates sqls shows the fatal "errno: 150" wich does not help too much.

reading comments on mysql official site:

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

you will see that "SHOW INNODB STATUS" shows too much information, between them it also show information about the last InnoDb Error, wich is really shows more information about the error. this really helps.

on the other hand, you already have this link inside phpmyadmin. so why don't put some link to "SHOW INNODB STATUS" just after the error message IF the error is number 150?

this way will helps users to realice what the hell is going on with the refused innodb sql right away.

thanks.

Discussion

  • Michal Čihař

    Michal Čihař - 2008-11-30
    • summary: [FEATURE REQUEST] add utility for "errno: 150" on innodb --> add utility for "errno: 150" on innodb
     
  • Michal Čihař

    Michal Čihař - 2008-11-30
    • assigned_to: nobody --> nijel
     
  • Michal Čihař

    Michal Čihař - 2008-11-30

    Implemented in SVN, thanks for suggestion.

     
  • Michal Čihař

    Michal Čihař - 2008-11-30
    • summary: add utility for "errno: 150" on innodb --> (ok 3.2.) add utility for "errno: 150" on innodb
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Michal Čihař

    Michal Čihař - 2008-11-30
    • summary: (ok 3.2.) add utility for "errno: 150" on innodb --> (ok 3.2.0) add utility for "errno: 150" on innodb
     
  • Marc Delisle

    Marc Delisle - 2009-06-15
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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