ID: 47631 Updated by: [email protected] Reported By: rpaccard at roproductions dot com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux 2.6.18-92 PHP Version: 5.1.6 New Comment:
Sounds like you're reporting a bug in a piece of software that isn't PHP. Previous Comments: ------------------------------------------------------------------------ [2009-03-12 13:01:02] rpaccard at roproductions dot com Sorry I don't have any code to provide. It's when I use the "Copy table to (database.table):" command that it happens. ------------------------------------------------------------------------ [2009-03-12 12:09:03] [email protected] 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
