phpMyAdmin export function not working

Created:

2016-11-16 12:46:19 UTC

Modified:

2017-08-08 13:15:17 UTC

1

Was this article helpful?


Have more questions?

Submit a request

phpMyAdmin export function not working

Applicable to:

  • Plesk 12.0 for Linux

Symptoms

  • phpMyAdmin 4.5 installed

  • Unable to export SQL query result if the query contains table aliases. For example, clicking on the export link, after executing query below, return back to the query screen.

    SELECT field_name from db_table as tt where tt.b=yy

However, export function works as expected if running an equivalent query without table aliases:

SELECT field_name from db_table where b=yy

Cause

Bug in phpMyAdmin https://github.com/phpmyadmin/phpmyadmin/issues/11509

Resolution

The issue was fixed in phpMyAdmin 4.6 which will be shipped in one of next Plesk updates.

Have more questions? Submit a request
Please sign in to leave a comment.