phpMyEdit - Viewing Bug Advanced Details [ Go Back ]
439 core / general feature always 2007-04-15 17:36 2007-05-17 05:37
michal i386  
FreeBSD  
normal 5.1  
new current from CVS  
open  
none  
none  
column names with space behave badly
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).
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.

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