• 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
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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