| Index
» Projects
» phpMyEdit
» Bug list
» Bug #439 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000439 |
core / general |
feature |
always |
2007-04-15 17:36 |
2007-05-17 05:37 |
|
|
|
Reporter |
michal |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
i386 |
|
Status |
new |
Duplicate ID |
|
OS |
FreeBSD |
|
Projection |
none |
|
Version |
5.1 |
|
ETA |
none |
|
Product Version |
current from CVS |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
Summary |
column names with space behave badly |
|
Description |
with cvs phpMyEdit, it is possible to use reserved words and special characters in column names, without any sql error. however certain column names make application unsable. these column names are mainly those with space in them (maybe others also). |
|
Steps To Reproduce |
create a table with space in column name, try to insert record. column will not be filled (any input from user will be ignored. sorting and displaying works correctly. |
|
Additional Information / Solution |
|
|
|
|
System Description |
|
|
Attached Files |
|
|
|
|
Bug Notes |
nepto
2007-04-15 18:03
|
Michal, isn't this bug related to that one with "backticks"?
I see that you recently closed that bug, so didn't that affect also this issue as well? |
|
|
michal
2007-04-15 18:07
|
only partially.
the problem is with html output, variables like 'pme_sys_col name' are parsed 'pme_sys_col' 'name' is ignored... |
|
|
psde
2007-05-17 05:37
|
A related problem is where MySQL columns have names which include a hyphen,
such as START-TIME. The PHP interprets this as the subtraction of two
undefined variables. If it can't easily be fixed, it should at least be
documented as a limitiation.
Regards - Peter |
|
|
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2007-04-15 17:36 |
michal |
New Bug |
|
|
2007-04-15 18:03 |
nepto |
Bugnote Added: 0001872 |
|
|
2007-04-15 18:07 |
michal |
Bugnote Added: 0001873 |
|
|
2007-05-17 05:37 |
psde |
Bugnote Added: 0001881 |
|
|
|