• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Problem export data from phpmyadmin Plesk 12.5 + CentOS 7 MariaDB

JuanjoSC

JuanjoSC

Basic Pleskian
Hi,

I have a problem exporting data from phpmyadmin Plesk 12.5

I execute this query:

Code: 
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
Click to expand...

Also shows me error before running the query, but then works fine.
 
Last edited:
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!
 
You must log in or register to reply here.
Back
Top