Menu

#2375 (ok 2.10.1) Error when using \"client\" as table name

2.10.0.1
fixed
1
2013-06-11
2007-03-01
Andi M
No

Apache/2.0.53 (Win32) PHP/5.2.1

I have a table called "client" in my database.

When I tried to join the "client" table using alias with any table:

"SELECT * FROM client c, asset a WHERE c.id=a.cid"

phpMyAdmin 2.9.2 produce a warning and query failed:

Warning: Cannot modify header information - headers already sent by (output started at C:\Apache\Apache2\htdocs\phpMyAdmin\libraries\header_meta_style.inc.php:27) in C:\Apache\Apache2\htdocs\phpMyAdmin\libraries\common.lib.php on line 1154

Even when I run a query:

"SELECT * FROM client c"

the same warning produced by phpMyAdmin.

However, when you removed the alias or add the word AS (client AS c), the query run normally as expected.

I tried to download and upgrade my phpMyAdmin to version 2.10.0.1, and the query still didn't run (failed). It didn't produce the warning, but didn't do anything.

Discussion

  • Marc Delisle

    Marc Delisle - 2007-03-04
    • milestone: --> 2.10.0.1
     
  • Marc Delisle

    Marc Delisle - 2007-03-04
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-03-04
    • summary: Error when running a query "SELECT * FROM client c" --> (ok 2.10.1) Error when using "client" as table name
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-03-04

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2007-04-24
    • summary: (ok 2.10.1) Error when using "client" as table name --> (ok 2.10.1) Error when using \"client\" as table name
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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