php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #47631 Space missing in export query
Submitted: 2009-03-12 09:02 UTC Modified: 2009-03-12 14:13 UTC
From: rpaccard at roproductions dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 5.1.6 OS: Linux 2.6.18-92
Private report: No CVE-ID: None
View Developer Edit
 [2009-03-12 09:02 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-03-12 12:09 UTC] 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 13:01 UTC] 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 13:08 UTC] scottmac@php.net 
Sounds like you're reporting a bug in a piece of software that isn't PHP.
 [2009-03-12 14:13 UTC] rpaccard at roproductions dot com 
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.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Thu Feb 05 21:00:02 2026 UTC