csv upload do not work

vifuturo
(@vifuturo)

9 years, 6 months ago

Hello,

I’ve tried to upload csv file, as explained, with , and not ; but all the uploads returns no data, no records, emply.
I’ve tried to download the csv created by the extension and upload but with same problem: no records are uploaded.
Is it possible to show a csv correct strutue? Or file demo to download?

I’ve tried with these (and others):
“sdsref”,”field1″,”field2″,””
“1”,””,”2″,””
“3”,””,”3″,””

No sucess

Regards
Peter

Viewing 6 replies - 1 through 6 (of 6 total)

arete7
(@arete7)

9 years, 6 months ago
Hi,

I’m having the same problem. Bug maybe?

Thx.
Paul.

Update, MySQL issue
WordPress database error The used command is not allowed with this MySQL version for query LOAD DATA LOCAL INFILE

# mysql -V
mysql Ver 14.14 Distrib 5.5.53
- This reply was modified 9 years, 6 months ago by arete7.
- This reply was modified 9 years, 6 months ago by arete7.
arete7
(@arete7)

9 years, 6 months ago

Hi,

MySQL needs extra config, see http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html

Typically you may need to edit your my.cnf file and add

[client]
loose-local-infile=1

Please read docs before just enabling this as it does have security implications.

Thx
Paul.

arete7
(@arete7)

9 years, 5 months ago

Hi,

Ok, after much looking reading and trying, I’ve resorted to changing LOAD DATA LOCAL INFILE to LOAD DATA INFILE and adding secure-file-priv = “” to my.cnf and GRANT FILE ON *.* TO ‘your_db_user’@’localhost’;.

As there is much controversy about php 5.5 upwards having some issues(bug possibly) that breaks LOAD DATA LOCAL INFILE(see http://stackoverflow.com/questions/13016797/load-data-local-infile-fails-from-php-to-mysql-on-amazon-rds to test this).

After making the about 3 changes, the upload was successful.

HOTH.

Paul.

wyliecoyote26
(@wyliecoyote26)

9 years, 4 months ago

Hi Paul,

Where is the my.cnf file located?

Steve

adinugrahafr
(@adinugrahafr)

9 years, 3 months ago

Hi all, this plugin works beautifully. But i always fail to upload csv. there is this notification

Warning: mysqli_query(): Filename cannot be empty in /home/xxx/public_html/wp-includes/wp-db.php on line 1877

xxx is my username on cpanel

anything to resolve?
thank you 🙂
nounours77
(@nounours77)

9 years, 2 months ago
Having the same problem with MySQL 5.6.33 – MySQL Community Server (GPL).

I’m on shared hosting, and think I do not have access to my.cnf. Is there a possibility to modify this behaviour in PhpAdmin? How?
- This reply was modified 9 years, 2 months ago by nounours77.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘csv upload do not work’ is closed to new replies.