Menu

#2980 (ok 3.4) Copy Table -> SQL error

3.4.0
fixed
1
2013-06-11
2010-02-19
Virsacer
No

When copying a Table ("Structure only" or "Structure and data") in "Operations" you get an SQL error because PMA tries to execute this "query":

<a href="http://dev.mysql.com/doc/refman/5.1/de/create-table.html" target="mysql_doc">CREATE TABLE</a> `data`.`test2` ( `test` <a href="http://dev.mysql.com/doc/refman/5.1/de/numeric-types.html" target="mysql_doc">int</a>( 10 ) NOT NULL ) ENGINE = MyISAM DEFAULT CHARSET = utf8

Version: 3.4.0-dev

Discussion

  • dylfin

    dylfin - 2010-02-20

    libraries/Table.class.php line 673
    $sql_structure = PMA_SQP_formatHtml($parsed_sql, 'query_only')
    returns sql query with html tags, can be replaced with
    $sql_structure = stip_tags(PMA_SQP_formatHtml($parsed_sql, 'query_only'));
    this is not right solution, but i dont found right function

     
  • dylfin

    dylfin - 2010-02-20

    $sql_structure = strip_tags(PMA_SQP_formatHtml($parsed_sql, 'query_only'));

     
  • Marc Delisle

    Marc Delisle - 2010-02-24
    • milestone: --> 3.4.0
     
  • Marc Delisle

    Marc Delisle - 2010-02-24

    This is a bug introduced after 3.3.0.

     
  • Marc Delisle

    Marc Delisle - 2010-02-24
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2010-02-24
    • assigned_to: lem9 --> nobody
     
  • Marc Delisle

    Marc Delisle - 2010-02-24

    Bug introduced in revision 13329.

     
  • Michal Čihař

    Michal Čihař - 2010-02-25
    • assigned_to: nobody --> nijel
     
  • Michal Čihař

    Michal Čihař - 2010-02-25
    • priority: 5 --> 1
    • summary: Copy Table -> SQL error --> (ok 3.4) Copy Table -> SQL error
    • status: open --> open-fixed
     
  • Michal Čihař

    Michal Čihař - 2010-02-25

    Fixed in svn, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2010-02-27

    This can be closed as it was not in a released version.

     
  • Marc Delisle

    Marc Delisle - 2010-02-27
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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