• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:
    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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