jDownloadsownloads.com


Author Topic: Exporting download list  (Read 326 times)

0 Members and 1 Guest are viewing this topic.

Offline arco

  • Newbie
  • *
  • Posts: 22
Exporting download list
« on: 25.10.2019 14:05:57 »
This is not directly a jDownloads issue, but related. (hope somebody knows what's going on)

I try to create a list of downloads by doing an SQL query.
This works fine on screen, but fails if I add INTO OUTFILE, and I don't understand why...
(according to the manual this should work:

Offline Arno

  • Administrator
  • ***
  • Posts: 12.565
    • jDownloads.com
Re: Exporting download list
« Reply #1 on: 30.10.2019 00:12:18 »
Hi,
I think you should try it in a MySQL forum.
I have never use this.  :-[
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Stefan1200

  • Newbie
  • *
  • Posts: 2
Re: Exporting download list
« Reply #2 on: 02.11.2019 09:56:34 »
Wie man hier sehen kann, ist deine SQL Syntax falsch:
https://dev.mysql.com/doc/refman/8.0/en/select-into.html

Die INTO OUTFILE Anweisung muss vor FROM. Also vermutlich so:
SELECT file_id,file_title,url_download,size INTO OUTFILE ‘test.csv‘ FROM jmdnx_jdownloads_files