#47631 [Opn->Fbk]: Space missing in export query
ID: 47631
Updated by: scottmac@php.net
Reported By: rpaccard at roproductions dot com
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: Linux 2.6.18-92
PHP Version: 5.2.9
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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)