Menu ▾ ▴

#4208 (ok 4.1.4) Can't browse tables after sorting on columns with fieldnames that have a '-'. 1054 - Unknown column 'field-name' in 'order clause'

4.1.2
fixed
Madhura Jayaratne
None
1
2014-01-07
2013-12-31
Jeff
No

Server: CentOS, Mysql 5.5.
Bug observed after recent upgrade to phpMyAdmin: 4.1.2.

With a table that has a column with a '-' in the name: such as field-name.

Browse Table.

Click the column header to sort (either asc or desc) the table by this field with the '-' in the name.

Now browse some other table, or click somewhere else.

Then try to Browse this same table again: this error appears. And you are unable to access the table again.

1054 - Unknown column 'field-name' in 'order clause'

Discussion

  • Madhura Jayaratne

    Madhura Jayaratne - 2014-01-01
    • assigned_to: Madhura Jayaratne
     

  • Madhura Jayaratne

    Madhura Jayaratne - 2014-01-01
    • summary: Can't browse tables after sorting on columns with fieldnames that have a '-'. 1054 - Unknown column 'field-name' in 'order clause' --> (ok 4.1.4) Can't browse tables after sorting on columns with fieldnames that have a '-'. 1054 - Unknown column 'field-name' in 'order clause'
    • status: open --> resolved
    • Priority: 5 --> 1
     

  • Marc Delisle

    Marc Delisle - 2014-01-07
    • Status: resolved --> fixed
     
Auth0 Logo