Solved

PrestaShop cannot export sql query results to a CSV file in SQL Manager

Posted on 2013-12-05
1
1,877 Views
Last Modified: 2013-12-10
We're using PrestaShop 1.5.4.1

We try to export the list of all the products into a csv file by using a custom sql query in SQL Manager.

Following query works well if you just VIEW it. But when it comes to export the results to a CSV file by clicking the first button next to the query, you get the whole sql query string itself inside a csv file. No results, just the query itself.

SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default 
FROM ps_product p 
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) 
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) 
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) 
LEFT JOIN ps_category c ON (cp.id_category = c.id_category) 
LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) 
WHERE pl.id_lang = 1 
AND cl.id_lang = 1 
AND p.id_shop_default = 1 AND c.id_shop_default = 1 
GROUP BY p.id_product

Open in new window


I don't think that it is related with the sql query itself because I also tried exporting with a single line basic sql query but it didn't work. I also tried different browsers, nothing changed.

Thanks in advance.
0
Comment
Question by:sbayrak
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
sbayrak earned 0 total points
ID: 39709012
Ok. I found the problem.

When I checked the http error log file of the web server, I saw the following lines;
"PHP Warning:  fopen(/.../export/request_sql_1.csv): failed to open stream: Permission denied in /.../controllers/admin/AdminRequestSqlController.php on line xxx, referer: http://www.mysite.com/..."

That means Prestashop cannot generate the csv file inside "export" folder.

Navigating to the admin folder and setting the owner of the export folder as www solves the issue.
# chown www:www export
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn about the eCommerce marketing trends for the year ahead.
Businesses who process credit card payments have to adhere to PCI Compliance standards. Here’s why that’s important.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question