Page 1 of 1

List File Won't Download

PostPosted: Fri Apr 14, 2017 11:02 am
by bondkmf
VERSION: 2.12-497a
BUILD: 150717-1333

1 DB/Web - 1.4.21.2 OpenSuse
2 SIP - 1.8.29.0-vici


ISSUE:
There is a list with roughly 54k leads and when I go to 'Click here to download this list' is outputs a BLANK txt file.

Things I have tried reading prior posts from Matt and William:
Changing the values in the php.ini file.
max_execution_time = 330
max_input_time = 360
memory_limit = 256M
default_socket_timeout = 120


Server rebooted and still not downloading. Please advise team!

Re: List File Won't Download

PostPosted: Fri Apr 14, 2017 12:01 pm
by bondkmf
I am not trying to extract it from my DB. This is how close I am getting but I am still getting an error:

select * from vicidial_list where list_id='XXXXX'
INTO OUTFILE '/root/listextport.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

ERROR 1 (HY000): Can't create/write to file '/root/listextport.csv' (Errcode: 13)

So GUI and CLI I am getting no where...anyone?

Re: List File Won't Download

PostPosted: Tue Apr 18, 2017 6:10 am
by hansg
I'm pretty sure the CLI method is not working as you do not have permission to create a file within that directory. Try running mysql with --tmpdir to create a temporary directory for the file to be created.

Re: List File Won't Download

PostPosted: Tue Apr 18, 2017 6:12 am
by hansg
Also make sure that your mysql user has all the correct permissions.

*** Has downloading large files ever worked before?