Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#2643 (ok 2.11.5-rc2) Sort Data on a Field name with space

2.11.5
fixed
Marc Delisle
1
2013-06-11
2008-02-25
Jacky_PHP
No

Hello,

i created a view and some field names contain spaces. If I click on the column heading to sort the data in the view, i get an sql error.

e.g.
Link in 2.11.5-rc1
http://domain.de/sql.php?db=db&table=table&token=fbdsf48be046cf5c5sd6176sdb&sql_query=SELECT+%2A+FROM+%60table%60+ORDER+BY+%60table%60.%60fieldname%60+ASC

Link in 2.11.4
http://domain.de/sql.php?db=db&table=table&token=453a45bs458fcvbb7a98ee224s&sql_query=SELECT+%2AFROM+%60table%60++ORDER+BY+%60table%60.%60field+name%60+ASC

In case of privacy I changed some values in the url. The difference is the + in field+name and fieldname.

Discussion

  • Marc Delisle
    Marc Delisle
    2008-02-25

    Logged In: YES
    user_id=210714
    Originator: NO

    No need to use a view, the problem can be reproduced also with a table having a space in a field name (2.11.4 is OK, 2.11.5-rc1 has the bug).

    CREATE TABLE `t1` (
    `id` int(11) NOT NULL,
    `the name` varchar(25) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    INSERT INTO `t1` VALUES(1, 'aaa');
    INSERT INTO `t1` VALUES(2, 'bbbb');

     
  • Marc Delisle
    Marc Delisle
    2008-02-25

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2008-02-25

    • summary: Sort Data in View (Field name with spaces) --> Sort Data on a Field name with space (2.11.5-rc1)
     
  • Marc Delisle
    Marc Delisle
    2008-02-25

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed for 2.11.5-rc2.

     
  • Marc Delisle
    Marc Delisle
    2008-02-25

    • priority: 5 --> 1
    • summary: Sort Data on a Field name with space (2.11.5-rc1) --> (ok 2.11.5-rc2) Sort Data on a Field name with space
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2008-03-01

    • status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed