Menu

#2578 (ok 2.11.3) Profile command repeated on older mysql servers

2.11.1.2
fixed
1
2013-06-11
2007-11-02
Maarten123
No

I've multiple servers, some of them are mysql 5.0.*, some of them are version 4.1.*.

If I'm at a 5.0 server, the 'profiling' query option appears. This works fine, but if you enable profiling queries and then navigate to a mysql < 5.0 server and execute a query phpMyAdmin still issues the 'SET PROFILING =1;' command, which results in a '#1193 - Unknown system variable 'PROFILING' error.

Since the 'profiling' checkbox isn't shown, I can't disable this feature, so I have to navigate to a >= 5.0 server to disable it first.

Proposed fix: Hiding the profiling checkbox on pre 5.0 servers is fine, but don't execute the SET PROFILING command either.

Tested with phpMyAdmin 2.11.1.2

Discussion

  • Marc Delisle

    Marc Delisle - 2007-11-02
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-11-02

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2007-11-02
    • priority: 5 --> 1
    • summary: Profile command repeated on older mysql servers --> (ok 2.11.3) Profile command repeated on older mysql servers
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-12-08
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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