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:
[gelöscht durch Administrator]
Hi,
I think you should try it in a MySQL forum.
I have never use this. :-[
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