List File Won't Download

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

List File Won't Download

Postby bondkmf » Fri Apr 14, 2017 11:02 am

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!
bondkmf
 
Posts: 25
Joined: Mon Aug 10, 2015 2:55 pm

Re: List File Won't Download

Postby bondkmf » Fri Apr 14, 2017 12:01 pm

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?
bondkmf
 
Posts: 25
Joined: Mon Aug 10, 2015 2:55 pm

Re: List File Won't Download

Postby hansg » Tue Apr 18, 2017 6:10 am

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.
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm

Re: List File Won't Download

Postby hansg » Tue Apr 18, 2017 6:12 am

Also make sure that your mysql user has all the correct permissions.

*** Has downloading large files ever worked before?
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 81 guests