Solved

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

Posted on 2013-12-05
1
1,785 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
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
change database name 2 28
MySQL Error Code 2 19
hasing a url 16 24
mysqli_connect error on wamp but not on remote server 8 21
Are you using email marketing software? If not, you're missing out on effortless marketing and the reaching of desired conversion rates through email marketing software.
How important is it to take extra precautions to protect your online business? These are some steps you can take to make sure you're free of any cyber crime.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

776 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