I'm sorry, if this is the wrong address for submitting bug reports for phpmyadmin. The homepage and documentation is quite unclear concerning this. At least for me :o)
It looks like the following is not fixed already for MySQL 3.23 under Linux. The SQL-Statement returned from get_table_def in lib.inc.php3 is in lower case (,,create table ...''). In tbl_copy.php3, this string is used with ereg_replace to create a SQL-Statement for the new table. But: The regular expression is ,,CREATE TABLE ...'', so this results always in a table already exists error. I changed this by using eregi_replace instead of ereg_replace.
jps
Hi,
what is your exact MySQL version? Under 3.23.38, I cannot reproduce this bug.
Marc
Jan Paul Schmidt a écrit :
It looks like the following is not fixed already for MySQL 3.23 under Linux. The SQL-Statement returned from get_table_def in lib.inc.php3 is in lower case (,,create table ...''). In tbl_copy.php3, this string is used with ereg_replace to create a SQL-Statement for the new table. But: The regular expression is ,,CREATE TABLE ...'', so this results always in a table already exists error. I changed this by using eregi_replace instead of ereg_replace.
jps