#47631 [Bgs]: Space missing in export query
ID: 47631
User updated by: rpaccard at roproductions dot com
Reported By: rpaccard at roproductions dot com
Status: Bogus
Bug Type: MySQL related
Operating System: Linux 2.6.18-92
PHP Version: 5.1.6
New Comment:
My apologies, I followed a link called "bug report" in the phpMyAdmin
2.8.2.4 Documentation but it leads to php.net. Sorry for the
inconvenience.
Previous Comments:
------------------------------------------------------------------------
[2009-03-12 13:08:10] scottmac@php.net
Sounds like you're reporting a bug in a piece of software that isn't
PHP.
------------------------------------------------------------------------
[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] 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
Thread (5 messages)