#47631 [Fbk->Opn]: Space missing in export query

ID: 47631 User updated by: rpaccard at roproductions dot com Reported By: rpaccard at roproductions dot com -Status: Feedback +Status: Open Bug Type: MySQL related Operating System: Linux 2.6.18-92 -PHP Version: 5.2.9 +PHP Version: 5.1.6 New Comment: Sorry I don't have any code to provide. It's when I use the "Copy table to (database.table):" command that it happens. Previous Comments: ------------------------------------------------------------------------ [2009-03-12 12:09:03] scottmac@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2009-03-12 09:02:00] rpaccard at roproductions dot com Description: ------------ The system I use runs PHP 5.1.6 and I have no power over this! When using the copy table feature, the CREATE TABLE query is missing a space and causes it to fail. There should be a space before "DEFAUlT CHARSET". Reproduce code: --------------- ENGINE = MYISAM AUTO_INCREMENT = 892DEFAULT CHARSET = utf8 PACK_KEYS =0 Expected result: ---------------- Copy structure et data of table to a new one Actual result: -------------- MySQL said: #1064 - 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 '892DEFAULT CHARSET = utf8 PACK_KEYS =0' at line 21 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47631&edit=1