Schema not escaped correctly

  • Resolved Arkadiusz Rzadkowolski

    (@fliespl)


    11 years, 2 months ago

    When database name consists of “-” character query will fail with:

    ERROR SQL ON : CREATE TABLE IF NOT EXISTS wp_4_commentmeta LIKE test-site.wp_2_commentmeta

    WPDB ERROR : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘-site.wp_2_commentmeta‘ at line 1

    Fixed code:

    // Create new table from source table
    MUCD_Data::do_sql_query(‘CREATE TABLE IF NOT EXISTS ' . $table_name . ' LIKE ' . $schema . '.’ . ‘' . $table . '‘);

    // Populate database with data from source table
    MUCD_Data::do_sql_query(‘INSERT ' . $table_name . ' SELECT * FROM ' . $schema . '.’ . ‘' . $table . '‘);

    https://ww.wp.xz.cn/plugins/multisite-clone-duplicator/

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Schema not escaped correctly’ is closed to new replies.