Error when dropping tables

Viewing 8 replies - 1 through 8 (of 8 total)
  • Navjot Singh

    (@navjotjsingh)

    10 years, 9 months ago

    Getting the same error.

    Matt Biscay

    (@skyminds)

    10 years, 7 months ago

    Hi,

    I’m experiencing the same issue – tables cannot be dropped in version 1.4.2.

    Matt Lambert

    (@conversationware)

    10 years, 7 months ago

    Same here I think

    When trying to drop tables I get

    Syntax error near ” at line 1 12:37:27 SQL command

    and the table is not dropped.

    ecdltf

    (@ecdltf)

    10 years, 6 months ago

    Same problem here.

    The issue is in /plugins/adminer/inc/adminer/drivers/mysql.inc :

    The function at line 730 should be changed from…

    function drop_tables($tables) {
		return queries("DROP TABLE " . implode(", ", array_map('table', $tables)));
	}

    to…

    function drop_tables($tables) {
		return queries("DROP TABLE " . implode(", ", array_map('adminer_table', $tables)));
	}

    The same issue seems to be in the drop_views function at line 722.

    Tom

    Matt Biscay

    (@skyminds)

    10 years, 6 months ago

    Thank you Tom, with the code change it’s now possible to drop tables. Very cool.

    Plugin Author Frank Bueltge

    (@bueltge)

    10 years, 6 months ago

    Thanks for the help. I will include this in the next version.

    ecdltf

    (@ecdltf)

    10 years, 6 months ago

    Thanks for the update. Drop tables is working now, but drop views isn’t.

    Probably the same problem? See my post above.

    Plugin Author Frank Bueltge

    (@bueltge)

    10 years, 6 months ago

    Thanks a lot. I’m not see this on reading 🙁
    Now, it is changed and include open topics on my local repository.

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

The topic ‘Error when dropping tables’ is closed to new replies.