Problem export data from phpmyadmin Plesk 12.5 + CentOS 7 MariaDB

[JuanjoSC]

Hi,

I have a problem exporting data from phpmyadmin Plesk 12.5

I execute this query:

SELECT `id_order_invoice`, `id_order`, `number`, `delivery_date`, REPLACE(CAST(`total_discount_tax_incl` AS CHAR),'.',',') AS Descuentos , REPLACE(CAST(`total_products_wt`AS CHAR),'.',',') AS total_products_wt , REPLACE(CAST(`total_products_wt`- `total_discount_tax_incl` AS CHAR),'.',',') AS 'Total pagado-descuentos', REPLACE(CAST(`total_shipping_tax_incl`AS CHAR),'.',',') AS Portes, REPLACE(CAST(`total_products_wt`- `total_discount_tax_incl`+`total_shipping_tax_incl`AS CHAR),'.',',') AS 'Total Factura' FROM `prstshp_order_invoice` WHERE `delivery_date` >= '2015-01-01 00:00:00' AND `delivery_date` < '2015-04-01 00:00:00' ORDER BY `id_order_invoice` ASC

This work ok but when I try to export to CSV excel into the file appears this:

<div class="error"><h1>Error</h1><p><strong>Análisis estático:</strong></p><p>Se encontraron 1 errores durante el análisis.</p><p><ol><li>Se esperaba una expresión. (near "" at position 0)</li></ol></p><p><strong>consulta SQL:</strong>
<a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentación" alt="Documentación" class="icon ic_b_help" /></a><a href="tbl_sql.php?sql_query=SELECT+%60id_order_invoice%60%2C+%60id_order%60%2C+%60number%60%2C+%60delivery_date%60++FROM&amp
<p>
SELECT `id_order_invoice`, `id_order`, `number`, `delivery_date` FROM
</p>
<p>
<strong>MySQL ha dicho: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentación" alt="Documentación" class="icon ic_b_help" /></a>
</p>
<code>#1064 - You have an error in your SQL syntax

Also shows me error before running the query, but then works fine.

 

[JuanjoSC]

More info:

I tried it with CentOS 6.7 and mysql and the problem is the same.

I run the query:

SELECT REPLACE(CAST(9.9 AS CHAR),'.',',')

It works ok, but the export fails.

Please IgorG you can check?

Thanks!

 

[Wolltronic]

Maybe an update to the latest phpMyAdmin version 4.5.1 could help? See:
https://talk.plesk.com/threads/phpmyadmin-export-problems-latest-version-should-help.335911/

 

[JuanjoSC]

3 months later...

 

[IgorG]

It is related to bug in phpmyadmin:

https://www.phpmyadmin.net/files/4.5.3/

- issue #11679 Cannot export results of some queries

We are going to update phpmyadmin version with one of nearest microupdates.

 

[JuanjoSC]

Thanks IgorG!

 

[JuanjoSC]

Fixed with update #24